636: /* check for incompatibility. If there is another load running for the same OU,error out this one */
637: --{BUG 12625738
638: /*SELECT FCR.argument1 into l_req_arg
639: FROM FND_CONCURRENT_REQUESTS FCR
640: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
641: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
642: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
643:
644: debug(' l_req_arg:'||l_req_arg);
637: --{BUG 12625738
638: /*SELECT FCR.argument1 into l_req_arg
639: FROM FND_CONCURRENT_REQUESTS FCR
640: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
641: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
642: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
643:
644: debug(' l_req_arg:'||l_req_arg);
645:
638: /*SELECT FCR.argument1 into l_req_arg
639: FROM FND_CONCURRENT_REQUESTS FCR
640: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
641: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
642: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
643:
644: debug(' l_req_arg:'||l_req_arg);
645:
646: SELECT count(*) into l_req_running
644: debug(' l_req_arg:'||l_req_arg);
645:
646: SELECT count(*) into l_req_running
647: FROM FND_CONCURRENT_REQUESTS FCR
648: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
649: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
650: AND FCR.phase_code = 'R'
651: AND FCR.argument1 = l_req_arg;*/
652:
645:
646: SELECT count(*) into l_req_running
647: FROM FND_CONCURRENT_REQUESTS FCR
648: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
649: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
650: AND FCR.phase_code = 'R'
651: AND FCR.argument1 = l_req_arg;*/
652:
653: SELECT count(*) into l_req_running
651: AND FCR.argument1 = l_req_arg;*/
652:
653: SELECT count(*) into l_req_running
654: FROM FND_CONCURRENT_REQUESTS FCR
655: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
656: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
657: AND FCR.phase_code = 'R'
658: AND FCR.org_id = p_operating_unit;
659: --}
652:
653: SELECT count(*) into l_req_running
654: FROM FND_CONCURRENT_REQUESTS FCR
655: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
656: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
657: AND FCR.phase_code = 'R'
658: AND FCR.org_id = p_operating_unit;
659: --}
660:
2345: l_program_application_id,
2346: l_program_id,
2347: l_program_update_date
2348: FROM cst_reconciliation_build crb
2349: WHERE crb.request_id = FND_GLOBAL.CONC_REQUEST_ID;
2350:
2351: debug(' l_build_id:'||l_build_id);
2352:
2353: l_stmt_num := 15;
2779: l_program_application_id,
2780: l_program_id,
2781: l_program_update_date
2782: FROM cst_reconciliation_build crb
2783: WHERE crb.request_id = FND_GLOBAL.CONC_REQUEST_ID;
2784:
2785: debug(' l_build_id :'|| l_build_id);
2786:
2787: l_stmt_num := 20;
3325: p_operating_unit,
3326: p_from_date,
3327: p_to_date,
3328: sysdate,
3329: FND_GLOBAL.USER_ID,
3330: FND_GLOBAL.USER_ID,
3331: sysdate,
3332: FND_GLOBAL.USER_ID,
3333: FND_GLOBAL.CONC_REQUEST_ID,
3326: p_from_date,
3327: p_to_date,
3328: sysdate,
3329: FND_GLOBAL.USER_ID,
3330: FND_GLOBAL.USER_ID,
3331: sysdate,
3332: FND_GLOBAL.USER_ID,
3333: FND_GLOBAL.CONC_REQUEST_ID,
3334: FND_GLOBAL.CONC_PROGRAM_ID,
3328: sysdate,
3329: FND_GLOBAL.USER_ID,
3330: FND_GLOBAL.USER_ID,
3331: sysdate,
3332: FND_GLOBAL.USER_ID,
3333: FND_GLOBAL.CONC_REQUEST_ID,
3334: FND_GLOBAL.CONC_PROGRAM_ID,
3335: FND_GLOBAL.PROG_APPL_ID,
3336: sysdate);
3329: FND_GLOBAL.USER_ID,
3330: FND_GLOBAL.USER_ID,
3331: sysdate,
3332: FND_GLOBAL.USER_ID,
3333: FND_GLOBAL.CONC_REQUEST_ID,
3334: FND_GLOBAL.CONC_PROGRAM_ID,
3335: FND_GLOBAL.PROG_APPL_ID,
3336: sysdate);
3337:
3330: FND_GLOBAL.USER_ID,
3331: sysdate,
3332: FND_GLOBAL.USER_ID,
3333: FND_GLOBAL.CONC_REQUEST_ID,
3334: FND_GLOBAL.CONC_PROGRAM_ID,
3335: FND_GLOBAL.PROG_APPL_ID,
3336: sysdate);
3337:
3338: debug('Insert_build_parameters-');
3331: sysdate,
3332: FND_GLOBAL.USER_ID,
3333: FND_GLOBAL.CONC_REQUEST_ID,
3334: FND_GLOBAL.CONC_PROGRAM_ID,
3335: FND_GLOBAL.PROG_APPL_ID,
3336: sysdate);
3337:
3338: debug('Insert_build_parameters-');
3339:
3576: l_program_application_id,
3577: l_program_id,
3578: l_program_update_date
3579: FROM cst_reconciliation_build crb
3580: WHERE crb.request_id = FND_GLOBAL.CONC_REQUEST_ID;
3581: debug(' l_build_id :'||l_build_id);
3582:
3583: OPEN c_po_dists;
3584: LOOP
4167: FROM cst_reconciliation_gtt gtt
4168: WHERE gtt.operating_unit_id = p_operating_unit
4169: AND gtt.po_distribution_id = po_dists_tab(indx)
4170: AND gtt.build_id = l_build_id
4171: AND gtt.request_id = FND_GLOBAL.CONC_REQUEST_ID
4172: GROUP BY
4173: gtt.po_distribution_id,
4174: gtt.accrual_account_id,
4175: gtt.inventory_item_id,