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 902: FND_GLOBAL.USER_ID,

898: Select Inventory_item_id,
899: organization_id,
900: cost_type_id,
901: sysdate,
902: FND_GLOBAL.USER_ID,
903: sysdate,
904: FND_GLOBAL.USER_ID,
905: inventory_asset_flag,
906: lot_size,

Line 904: FND_GLOBAL.USER_ID,

900: cost_type_id,
901: sysdate,
902: FND_GLOBAL.USER_ID,
903: sysdate,
904: FND_GLOBAL.USER_ID,
905: inventory_asset_flag,
906: lot_size,
907: based_on_rollup_flag,
908: shrinkage_rate,

Line 930: FND_GLOBAL.CONC_REQUEST_ID,

926: SUM(item_cost),
927: SUM(item_cost),
928: (SUM(item_cost) - SUM(decode(ct.cost_element_id,2,ct.item_cost,0))),
929: SUM(decode(ct.cost_element_id,2,ct.item_cost,null)),
930: FND_GLOBAL.CONC_REQUEST_ID,
931: FND_GLOBAL.PROG_APPL_ID,
932: FND_GLOBAL.CONC_PROGRAM_ID,
933: sysdate
934: FROM CST_ITEM_CST_DTLS_INTERFACE ct

Line 931: FND_GLOBAL.PROG_APPL_ID,

927: SUM(item_cost),
928: (SUM(item_cost) - SUM(decode(ct.cost_element_id,2,ct.item_cost,0))),
929: SUM(decode(ct.cost_element_id,2,ct.item_cost,null)),
930: FND_GLOBAL.CONC_REQUEST_ID,
931: FND_GLOBAL.PROG_APPL_ID,
932: FND_GLOBAL.CONC_PROGRAM_ID,
933: sysdate
934: FROM CST_ITEM_CST_DTLS_INTERFACE ct
935: WHERE error_flag is null

Line 932: FND_GLOBAL.CONC_PROGRAM_ID,

928: (SUM(item_cost) - SUM(decode(ct.cost_element_id,2,ct.item_cost,0))),
929: SUM(decode(ct.cost_element_id,2,ct.item_cost,null)),
930: FND_GLOBAL.CONC_REQUEST_ID,
931: FND_GLOBAL.PROG_APPL_ID,
932: FND_GLOBAL.CONC_PROGRAM_ID,
933: sysdate
934: FROM CST_ITEM_CST_DTLS_INTERFACE ct
935: WHERE error_flag is null
936: AND group_id = SEQ_NEXTVAL

Line 990: FND_GLOBAL.USER_ID,

986: SELECT inventory_item_id,
987: organization_id,
988: cost_type_id,
989: sysdate,
990: FND_GLOBAL.USER_ID,
991: sysdate,
992: FND_GLOBAL.USER_ID,
993: level_type,
994: activity_id,

Line 992: FND_GLOBAL.USER_ID,

988: cost_type_id,
989: sysdate,
990: FND_GLOBAL.USER_ID,
991: sysdate,
992: FND_GLOBAL.USER_ID,
993: level_type,
994: activity_id,
995: resource_id,
996: resource_rate,

Line 1007: FND_GLOBAL.CONC_REQUEST_ID,

1003: item_cost,
1004: cost_element_id,
1005: rollup_source_type,
1006: activity_context,
1007: FND_GLOBAL.CONC_REQUEST_ID,
1008: FND_GLOBAL.PROG_APPL_ID,
1009: FND_GLOBAL.CONC_PROGRAM_ID,
1010: sysdate,
1011: attribute_category,

Line 1008: FND_GLOBAL.PROG_APPL_ID,

1004: cost_element_id,
1005: rollup_source_type,
1006: activity_context,
1007: FND_GLOBAL.CONC_REQUEST_ID,
1008: FND_GLOBAL.PROG_APPL_ID,
1009: FND_GLOBAL.CONC_PROGRAM_ID,
1010: sysdate,
1011: attribute_category,
1012: attribute1,

Line 1009: FND_GLOBAL.CONC_PROGRAM_ID,

1005: rollup_source_type,
1006: activity_context,
1007: FND_GLOBAL.CONC_REQUEST_ID,
1008: FND_GLOBAL.PROG_APPL_ID,
1009: FND_GLOBAL.CONC_PROGRAM_ID,
1010: sysdate,
1011: attribute_category,
1012: attribute1,
1013: attribute2,