| 1 |
- window.repositoryObject = {"parameters_custom_fields":[],"object_id":"f373","name":"FN_GET_CARD_CODE","subtype":"FUNCTION","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"FN_GET_CARD_CODE"},{"field":"Type","value":"Function"}],"script":"BEGIN\r\n\r\nDECLARE O_RET_VALUE VARCHAR(150);\r\n\r\nSELECT COM_CARD_CD\r\n INTO O_RET_VALUE\r\nFROM TB_PG_CARD\r\nWHERE PG_GB = I_PG_GB\r\n AND CARD_CD = I_CARD_CD\r\n;\r\n\r\nRETURN O_RET_VALUE;\r\n\r\nEND","parameters":[{"name":"Returns","description":null,"mode":"OUT","data_type":"varchar(150)","custom_fields":{}},{"name":"I_PG_GB","description":null,"mode":"IN","data_type":"varchar(20)","custom_fields":{}},{"name":"I_CARD_CD","description":null,"mode":"IN","data_type":"varchar(10)","custom_fields":{}}],"dependencies":null,"imported_at":"2021-11-11 16:37"};
|
