DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on FND_GLOBAL

Line 640: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID

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

Line 641: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID

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:

Line 642: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;

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

Line 648: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID

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:

Line 649: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID

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

Line 655: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID

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: --}

Line 656: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID

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:

Line 2349: WHERE crb.request_id = FND_GLOBAL.CONC_REQUEST_ID;

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;

Line 2783: WHERE crb.request_id = FND_GLOBAL.CONC_REQUEST_ID;

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;

Line 3329: FND_GLOBAL.USER_ID,

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,

Line 3330: FND_GLOBAL.USER_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,

Line 3332: FND_GLOBAL.USER_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);

Line 3333: FND_GLOBAL.CONC_REQUEST_ID,

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:

Line 3334: FND_GLOBAL.CONC_PROGRAM_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:
3338: debug('Insert_build_parameters-');

Line 3335: FND_GLOBAL.PROG_APPL_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-');
3339:

Line 3580: WHERE crb.request_id = FND_GLOBAL.CONC_REQUEST_ID;

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

Line 4171: AND gtt.request_id = FND_GLOBAL.CONC_REQUEST_ID

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,