DBA Data[Home] [Help]

APPS.FTP_BR_ROM_PVT dependencies on FTP_RATE_OUTPUT_MAPPING_RULE

Line 21: DELETE FROM FTP_RATE_OUTPUT_MAPPING_RULE

17: g_api_name constant varchar2(30) := 'DeleteObjectDefinition';
18:
19: BEGIN
20:
21: DELETE FROM FTP_RATE_OUTPUT_MAPPING_RULE
22: WHERE object_definition_id = p_obj_def_id;
23:
24: EXCEPTION
25:

Line 56: INSERT INTO FTP_RATE_OUTPUT_MAPPING_RULE (

52: g_api_name constant varchar2(30) := 'CopyObjectDefinition';
53:
54: BEGIN
55:
56: INSERT INTO FTP_RATE_OUTPUT_MAPPING_RULE (
57: OBJECT_DEFINITION_ID,
58: FTP_ACCOUNT_TABLE_NAME,
59: TRANSFER_RATE_COL_NAME,
60: MATCHED_SPREAD_COL_NAME,

Line 93: FROM FTP_RATE_OUTPUT_MAPPING_RULE

89: NVL(p_created_by,CREATED_BY),
90: FND_GLOBAL.user_id,
91: SYSDATE,
92: FND_GLOBAL.login_id
93: FROM FTP_RATE_OUTPUT_MAPPING_RULE
94: WHERE OBJECT_DEFINITION_ID = p_source_obj_def_id;
95:
96: EXCEPTION
97: