DBA Data[Home] [Help]

APPS.CST_ITEM_COST_IMPORT_INTERFACE dependencies on FND_GLOBAL

Line 96: request_id = FND_GLOBAL.CONC_REQUEST_ID,

92:
93: /* Set the unique transaction_id for each row */
94: Update CST_ITEM_CST_DTLS_INTERFACE
95: SET transaction_id = CST_ITEM_CST_DTLS_INTERFACE_S.NEXTVAL,
96: request_id = FND_GLOBAL.CONC_REQUEST_ID,
97: error_code = null,
98: error_explanation = null,
99: program_application_id = FND_GLOBAL.PROG_APPL_ID,
100: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

Line 99: program_application_id = FND_GLOBAL.PROG_APPL_ID,

95: SET transaction_id = CST_ITEM_CST_DTLS_INTERFACE_S.NEXTVAL,
96: request_id = FND_GLOBAL.CONC_REQUEST_ID,
97: error_code = null,
98: error_explanation = null,
99: program_application_id = FND_GLOBAL.PROG_APPL_ID,
100: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
101: program_update_date = sysdate,
102: process_flag = 2
103: where error_flag is null

Line 100: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

96: request_id = FND_GLOBAL.CONC_REQUEST_ID,
97: error_code = null,
98: error_explanation = null,
99: program_application_id = FND_GLOBAL.PROG_APPL_ID,
100: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
101: program_update_date = sysdate,
102: process_flag = 2
103: where error_flag is null
104: AND process_flag = 1

Line 897: FND_GLOBAL.USER_ID,

893: Select Inventory_item_id,
894: organization_id,
895: cost_type_id,
896: sysdate,
897: FND_GLOBAL.USER_ID,
898: sysdate,
899: FND_GLOBAL.USER_ID,
900: inventory_asset_flag,
901: lot_size,

Line 899: FND_GLOBAL.USER_ID,

895: cost_type_id,
896: sysdate,
897: FND_GLOBAL.USER_ID,
898: sysdate,
899: FND_GLOBAL.USER_ID,
900: inventory_asset_flag,
901: lot_size,
902: based_on_rollup_flag,
903: shrinkage_rate,

Line 925: FND_GLOBAL.CONC_REQUEST_ID,

921: SUM(item_cost),
922: SUM(item_cost),
923: (SUM(ct.item_cost) - SUM(decode(ct.cost_element_id,2,ct.item_cost,0))),
924: SUM(decode(ct.cost_element_id,2,ct.item_cost,null)),
925: FND_GLOBAL.CONC_REQUEST_ID,
926: FND_GLOBAL.PROG_APPL_ID,
927: FND_GLOBAL.CONC_PROGRAM_ID,
928: sysdate
929: FROM CST_ITEM_CST_DTLS_INTERFACE ct

Line 926: FND_GLOBAL.PROG_APPL_ID,

922: SUM(item_cost),
923: (SUM(ct.item_cost) - SUM(decode(ct.cost_element_id,2,ct.item_cost,0))),
924: SUM(decode(ct.cost_element_id,2,ct.item_cost,null)),
925: FND_GLOBAL.CONC_REQUEST_ID,
926: FND_GLOBAL.PROG_APPL_ID,
927: FND_GLOBAL.CONC_PROGRAM_ID,
928: sysdate
929: FROM CST_ITEM_CST_DTLS_INTERFACE ct
930: WHERE error_flag is null

Line 927: FND_GLOBAL.CONC_PROGRAM_ID,

923: (SUM(ct.item_cost) - SUM(decode(ct.cost_element_id,2,ct.item_cost,0))),
924: SUM(decode(ct.cost_element_id,2,ct.item_cost,null)),
925: FND_GLOBAL.CONC_REQUEST_ID,
926: FND_GLOBAL.PROG_APPL_ID,
927: FND_GLOBAL.CONC_PROGRAM_ID,
928: sysdate
929: FROM CST_ITEM_CST_DTLS_INTERFACE ct
930: WHERE error_flag is null
931: AND group_id = SEQ_NEXTVAL

Line 1034: FND_GLOBAL.USER_ID,

1030: SELECT inventory_item_id,
1031: organization_id,
1032: cost_type_id,
1033: sysdate,
1034: FND_GLOBAL.USER_ID,
1035: sysdate,
1036: FND_GLOBAL.USER_ID,
1037: level_type,
1038: activity_id,

Line 1036: FND_GLOBAL.USER_ID,

1032: cost_type_id,
1033: sysdate,
1034: FND_GLOBAL.USER_ID,
1035: sysdate,
1036: FND_GLOBAL.USER_ID,
1037: level_type,
1038: activity_id,
1039: resource_id,
1040: resource_rate,

Line 1051: FND_GLOBAL.CONC_REQUEST_ID,

1047: item_cost,
1048: cost_element_id,
1049: rollup_source_type,
1050: activity_context,
1051: FND_GLOBAL.CONC_REQUEST_ID,
1052: FND_GLOBAL.PROG_APPL_ID,
1053: FND_GLOBAL.CONC_PROGRAM_ID,
1054: sysdate,
1055: attribute_category,

Line 1052: FND_GLOBAL.PROG_APPL_ID,

1048: cost_element_id,
1049: rollup_source_type,
1050: activity_context,
1051: FND_GLOBAL.CONC_REQUEST_ID,
1052: FND_GLOBAL.PROG_APPL_ID,
1053: FND_GLOBAL.CONC_PROGRAM_ID,
1054: sysdate,
1055: attribute_category,
1056: attribute1,

Line 1053: FND_GLOBAL.CONC_PROGRAM_ID,

1049: rollup_source_type,
1050: activity_context,
1051: FND_GLOBAL.CONC_REQUEST_ID,
1052: FND_GLOBAL.PROG_APPL_ID,
1053: FND_GLOBAL.CONC_PROGRAM_ID,
1054: sysdate,
1055: attribute_category,
1056: attribute1,
1057: attribute2,