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,
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
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
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),
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,
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
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
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;
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,
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
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
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,
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,
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,
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,
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,