DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on FND_GLOBAL

Line 656: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID

652: /* check for incompatibility. If there is another load running for the same OU,error out this one */
653:
654: SELECT FCR.argument1 into l_req_arg
655: FROM FND_CONCURRENT_REQUESTS FCR
656: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
657: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
658: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
659:
660: debug(' l_req_arg:'||l_req_arg);

Line 657: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID

653:
654: SELECT FCR.argument1 into l_req_arg
655: FROM FND_CONCURRENT_REQUESTS FCR
656: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
657: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
658: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
659:
660: debug(' l_req_arg:'||l_req_arg);
661:

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

654: SELECT FCR.argument1 into l_req_arg
655: FROM FND_CONCURRENT_REQUESTS FCR
656: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
657: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
658: AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;
659:
660: debug(' l_req_arg:'||l_req_arg);
661:
662: SELECT count(*) into l_req_running

Line 664: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID

660: debug(' l_req_arg:'||l_req_arg);
661:
662: SELECT count(*) into l_req_running
663: FROM FND_CONCURRENT_REQUESTS FCR
664: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
665: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
666: AND FCR.phase_code = 'R'
667: AND FCR.argument1 = l_req_arg;
668:

Line 665: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID

661:
662: SELECT count(*) into l_req_running
663: FROM FND_CONCURRENT_REQUESTS FCR
664: WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
665: AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
666: AND FCR.phase_code = 'R'
667: AND FCR.argument1 = l_req_arg;
668:
669: debug(' l_req_running:'||l_req_running);

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

2275: l_program_application_id,
2276: l_program_id,
2277: l_program_update_date
2278: FROM cst_reconciliation_build crb
2279: WHERE crb.request_id = FND_GLOBAL.CONC_REQUEST_ID;
2280:
2281: debug(' l_build_id:'||l_build_id);
2282:
2283: l_stmt_num := 15;

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

2587: l_program_application_id,
2588: l_program_id,
2589: l_program_update_date
2590: FROM cst_reconciliation_build crb
2591: WHERE crb.request_id = FND_GLOBAL.CONC_REQUEST_ID;
2592:
2593: debug(' l_build_id :'|| l_build_id);
2594:
2595: l_stmt_num := 20;

Line 3031: FND_GLOBAL.USER_ID,

3027: p_operating_unit,
3028: p_from_date,
3029: p_to_date,
3030: sysdate,
3031: FND_GLOBAL.USER_ID,
3032: FND_GLOBAL.USER_ID,
3033: sysdate,
3034: FND_GLOBAL.USER_ID,
3035: FND_GLOBAL.CONC_REQUEST_ID,

Line 3032: FND_GLOBAL.USER_ID,

3028: p_from_date,
3029: p_to_date,
3030: sysdate,
3031: FND_GLOBAL.USER_ID,
3032: FND_GLOBAL.USER_ID,
3033: sysdate,
3034: FND_GLOBAL.USER_ID,
3035: FND_GLOBAL.CONC_REQUEST_ID,
3036: FND_GLOBAL.CONC_PROGRAM_ID,

Line 3034: FND_GLOBAL.USER_ID,

3030: sysdate,
3031: FND_GLOBAL.USER_ID,
3032: FND_GLOBAL.USER_ID,
3033: sysdate,
3034: FND_GLOBAL.USER_ID,
3035: FND_GLOBAL.CONC_REQUEST_ID,
3036: FND_GLOBAL.CONC_PROGRAM_ID,
3037: FND_GLOBAL.PROG_APPL_ID,
3038: sysdate);

Line 3035: FND_GLOBAL.CONC_REQUEST_ID,

3031: FND_GLOBAL.USER_ID,
3032: FND_GLOBAL.USER_ID,
3033: sysdate,
3034: FND_GLOBAL.USER_ID,
3035: FND_GLOBAL.CONC_REQUEST_ID,
3036: FND_GLOBAL.CONC_PROGRAM_ID,
3037: FND_GLOBAL.PROG_APPL_ID,
3038: sysdate);
3039:

Line 3036: FND_GLOBAL.CONC_PROGRAM_ID,

3032: FND_GLOBAL.USER_ID,
3033: sysdate,
3034: FND_GLOBAL.USER_ID,
3035: FND_GLOBAL.CONC_REQUEST_ID,
3036: FND_GLOBAL.CONC_PROGRAM_ID,
3037: FND_GLOBAL.PROG_APPL_ID,
3038: sysdate);
3039:
3040: debug('Insert_build_parameters-');

Line 3037: FND_GLOBAL.PROG_APPL_ID,

3033: sysdate,
3034: FND_GLOBAL.USER_ID,
3035: FND_GLOBAL.CONC_REQUEST_ID,
3036: FND_GLOBAL.CONC_PROGRAM_ID,
3037: FND_GLOBAL.PROG_APPL_ID,
3038: sysdate);
3039:
3040: debug('Insert_build_parameters-');
3041:

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

3246: l_program_application_id,
3247: l_program_id,
3248: l_program_update_date
3249: FROM cst_reconciliation_build crb
3250: WHERE crb.request_id = FND_GLOBAL.CONC_REQUEST_ID;
3251: debug(' l_build_id :'||l_build_id);
3252:
3253: OPEN c_po_dists;
3254: LOOP

Line 3800: AND gtt.request_id = FND_GLOBAL.CONC_REQUEST_ID

3796: FROM cst_reconciliation_gtt gtt
3797: WHERE gtt.operating_unit_id = p_operating_unit
3798: AND gtt.po_distribution_id = po_dists_tab(indx)
3799: AND gtt.build_id = l_build_id
3800: AND gtt.request_id = FND_GLOBAL.CONC_REQUEST_ID
3801: GROUP BY
3802: gtt.po_distribution_id,
3803: gtt.accrual_account_id,
3804: gtt.inventory_item_id,