DBA Data[Home] [Help]

APPS.CST_OVHD_RATE_IMPORT_INTERFACE dependencies on FND_GLOBAL

Line 108: request_id = FND_GLOBAL.CONC_REQUEST_ID,

104: /* Set the unique transaction_id for each row */
105:
106: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
107: SET transaction_id = CST_ITEM_CST_DTLS_INTERFACE_S.NEXTVAL,
108: request_id = FND_GLOBAL.CONC_REQUEST_ID,
109: error_code = null,
110: error_explanation = null,
111: program_application_id = FND_GLOBAL.PROG_APPL_ID,
112: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

Line 111: program_application_id = FND_GLOBAL.PROG_APPL_ID,

107: SET transaction_id = CST_ITEM_CST_DTLS_INTERFACE_S.NEXTVAL,
108: request_id = FND_GLOBAL.CONC_REQUEST_ID,
109: error_code = null,
110: error_explanation = null,
111: program_application_id = FND_GLOBAL.PROG_APPL_ID,
112: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
113: program_update_date = sysdate,
114: process_flag = 2
115: where cdoi.group_id=SEQ_NEXTVAL

Line 112: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

108: request_id = FND_GLOBAL.CONC_REQUEST_ID,
109: error_code = null,
110: error_explanation = null,
111: program_application_id = FND_GLOBAL.PROG_APPL_ID,
112: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
113: program_update_date = sysdate,
114: process_flag = 2
115: where cdoi.group_id=SEQ_NEXTVAL
116: AND cdoi.process_flag = 1

Line 421: FND_GLOBAL.USER_ID,

417: SELECT department_id,
418: cost_type_id,
419: overhead_id,
420: sysdate,
421: FND_GLOBAL.USER_ID,
422: sysdate,
423: FND_GLOBAL.USER_ID,
424: organization_id,
425: NVL(cdoi.basis_type,1),

Line 423: FND_GLOBAL.USER_ID,

419: overhead_id,
420: sysdate,
421: FND_GLOBAL.USER_ID,
422: sysdate,
423: FND_GLOBAL.USER_ID,
424: organization_id,
425: NVL(cdoi.basis_type,1),
426: rate_or_amount,
427: Activity_id,

Line 444: FND_GLOBAL.CONC_REQUEST_ID,

440: attribute12,
441: attribute13,
442: attribute14,
443: attribute15,
444: FND_GLOBAL.CONC_REQUEST_ID,
445: FND_GLOBAL.PROG_APPL_ID,
446: FND_GLOBAL.CONC_PROGRAM_ID,
447: sysdate
448: FROM CST_DEPT_OVERHEADS_INTERFACE cdoi

Line 445: FND_GLOBAL.PROG_APPL_ID,

441: attribute13,
442: attribute14,
443: attribute15,
444: FND_GLOBAL.CONC_REQUEST_ID,
445: FND_GLOBAL.PROG_APPL_ID,
446: FND_GLOBAL.CONC_PROGRAM_ID,
447: sysdate
448: FROM CST_DEPT_OVERHEADS_INTERFACE cdoi
449: WHERE cdoi.error_flag is null

Line 446: FND_GLOBAL.CONC_PROGRAM_ID,

442: attribute14,
443: attribute15,
444: FND_GLOBAL.CONC_REQUEST_ID,
445: FND_GLOBAL.PROG_APPL_ID,
446: FND_GLOBAL.CONC_PROGRAM_ID,
447: sysdate
448: FROM CST_DEPT_OVERHEADS_INTERFACE cdoi
449: WHERE cdoi.error_flag is null
450: AND cdoi.group_id = SEQ_NEXTVAL;

Line 565: request_id = FND_GLOBAL.CONC_REQUEST_ID,

561: /* Set the unique transaction_id for each row */
562:
563: Update CST_RES_OVERHEADS_INTERFACE croi
564: SET transaction_id = CST_ITEM_CST_DTLS_INTERFACE_S.NEXTVAL,
565: request_id = FND_GLOBAL.CONC_REQUEST_ID,
566: error_code = null,
567: error_explanation = null,
568: program_application_id = FND_GLOBAL.PROG_APPL_ID,
569: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

Line 568: program_application_id = FND_GLOBAL.PROG_APPL_ID,

564: SET transaction_id = CST_ITEM_CST_DTLS_INTERFACE_S.NEXTVAL,
565: request_id = FND_GLOBAL.CONC_REQUEST_ID,
566: error_code = null,
567: error_explanation = null,
568: program_application_id = FND_GLOBAL.PROG_APPL_ID,
569: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
570: program_update_date = sysdate,
571: process_flag = 2
572: where error_flag is null

Line 569: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

565: request_id = FND_GLOBAL.CONC_REQUEST_ID,
566: error_code = null,
567: error_explanation = null,
568: program_application_id = FND_GLOBAL.PROG_APPL_ID,
569: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
570: program_update_date = sysdate,
571: process_flag = 2
572: where error_flag is null
573: AND croi.process_flag = 1

Line 834: FND_GLOBAL.USER_ID,

830: SELECT cost_type_id,
831: resource_id,
832: overhead_id,
833: sysdate,
834: FND_GLOBAL.USER_ID,
835: sysdate,
836: FND_GLOBAL.USER_ID,
837: organization_id,
838: FND_GLOBAL.CONC_REQUEST_ID,

Line 836: FND_GLOBAL.USER_ID,

832: overhead_id,
833: sysdate,
834: FND_GLOBAL.USER_ID,
835: sysdate,
836: FND_GLOBAL.USER_ID,
837: organization_id,
838: FND_GLOBAL.CONC_REQUEST_ID,
839: FND_GLOBAL.PROG_APPL_ID,
840: FND_GLOBAL.CONC_PROGRAM_ID,

Line 838: FND_GLOBAL.CONC_REQUEST_ID,

834: FND_GLOBAL.USER_ID,
835: sysdate,
836: FND_GLOBAL.USER_ID,
837: organization_id,
838: FND_GLOBAL.CONC_REQUEST_ID,
839: FND_GLOBAL.PROG_APPL_ID,
840: FND_GLOBAL.CONC_PROGRAM_ID,
841: sysdate,
842: attribute_category,

Line 839: FND_GLOBAL.PROG_APPL_ID,

835: sysdate,
836: FND_GLOBAL.USER_ID,
837: organization_id,
838: FND_GLOBAL.CONC_REQUEST_ID,
839: FND_GLOBAL.PROG_APPL_ID,
840: FND_GLOBAL.CONC_PROGRAM_ID,
841: sysdate,
842: attribute_category,
843: attribute1,

Line 840: FND_GLOBAL.CONC_PROGRAM_ID,

836: FND_GLOBAL.USER_ID,
837: organization_id,
838: FND_GLOBAL.CONC_REQUEST_ID,
839: FND_GLOBAL.PROG_APPL_ID,
840: FND_GLOBAL.CONC_PROGRAM_ID,
841: sysdate,
842: attribute_category,
843: attribute1,
844: attribute2,