eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BURDEN_COSTING dependencies on PA_BURDEN_COSTING

Line 1: PACKAGE BODY PA_BURDEN_COSTING as

1: PACKAGE BODY PA_BURDEN_COSTING as
2: -- /* $Header: PAXCBCAB.pls 120.32.12020000.4 2013/04/10 09:21:36 rboyalap ship $
3:
4: --Start Of Mods(SOM) Bug # 5743708
5: l_tbl_eiid typ_tbl_eiid;

Line 642: -- Set current project id in the package pa_burden_costing for

638: IF P_DEBUG_MODE THEN
639: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '250:Processing for Project:'||to_char(proj_rec.project_id));
640: END IF;
641: stage := 110; -- in project loop
642: -- Set current project id in the package pa_burden_costing for
643: -- view definitions and for local variable
644:
645: IF P_DEBUG_MODE THEN
646: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '300:before set current project id');

Line 649: /PA_BURDEN_COSTING.set_current_project_id(proj_rec.project_id); 5406802/

645: IF P_DEBUG_MODE THEN
646: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '300:before set current project id');
647: END IF;
648:
649: /*PA_BURDEN_COSTING.set_current_project_id(proj_rec.project_id); 5406802*/
650:
651:
652: /*Bug# 5406802*/
653: IF l_gms_installed THEN

Line 657: PA_BURDEN_COSTING.set_current_sponsored_flag(proj_rec.project_id);

653: IF l_gms_installed THEN
654: -- ======
655: -- Bug : 3699045 - PJ.M:B4:P13:OTH:PERF:XPL PERFORMANCE ISSUES IN PAVW341.SQL
656: -- ======
657: PA_BURDEN_COSTING.set_current_sponsored_flag(proj_rec.project_id);
658: END IF;
659:
660: current_project_id := proj_rec.project_id;
661: IF P_DEBUG_MODE THEN

Line 812: PA_BURDEN_COSTING.set_current_run_id(current_run_id);

808: * Bug#2255068
809: * Setting the current_run_id in the global variable so that the cdl_burden_detail_v
810: * will pick-up only these records.
811: */
812: PA_BURDEN_COSTING.set_current_run_id(current_run_id);
813:
814: /*
815: * Bug#2255068
816: * Added - so, new expenditure group is created per batch - since the run_id

Line 833: if PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'N' then -- bug 9165385

829: /*SOM Bug# 5743708*/
830: l_tbl_eiid.delete;
831: l_tbl_cdlln.delete;
832: /*EOM Bug# 5743708*/
833: if PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'N' then -- bug 9165385
834: UPDATE pa_cost_distribution_lines cdl
835: SET cdl.prev_ind_compiled_set_id = decode(cdl.burden_sum_source_run_id,init_cdl_run_id,NULL
836: ,cdl.ind_compiled_set_id), /*3071338*/
837: request_id = x_request_id,

Line 856: else -- PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'Y' -- bug 9165385

852: and ei.expenditure_item_date <= nvl(l_end_date,ei.expenditure_item_date))
853: and rownum <= l_profile_set_size /*2933915*/
854: returning expenditure_item_id, line_num bulk collect into l_tbl_eiid, l_tbl_cdlln; /* Bug# 5406802 */
855:
856: else -- PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'Y' -- bug 9165385
857:
858: UPDATE pa_cost_distribution_lines cdl
859: SET cdl.prev_ind_compiled_set_id = decode(cdl.burden_sum_source_run_id,init_cdl_run_id,NULL
860: ,cdl.ind_compiled_set_id),

Line 903: PA_BURDEN_COSTING.InsBurdenAudit(current_project_id,x_request_id,l_user_id,lstatus);

899: IF P_DEBUG_MODE THEN
900: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '604:Creating Audit in pa_aud_cost_dist_lines');
901: END IF;
902:
903: PA_BURDEN_COSTING.InsBurdenAudit(current_project_id,x_request_id,l_user_id,lstatus);
904:
905: /*To get compiled set for special cdls and update on ei and cdl*/
906:
907: IF P_DEBUG_MODE THEN

Line 1272: if PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'N' then -- bug 9165385

1268: THEN
1269: /* Removed ei table and pa_tasks table and changed cdl_all table to cdl view for
1270: bug# 1668634
1271: */
1272: if PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'N' then -- bug 9165385
1273:
1274: /* Bug# 9373031: Added hint for performane issue */
1275:
1276: update /*+ INDEX (cdl, PA_COST_DISTRIBUTION_LINES_N10) */ pa_cost_distribution_lines cdl

Line 1296: else -- PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'Y' -- bug 9165385

1292: )
1293: and rownum <= l_profile_set_size;
1294: /*and cdl.PA_DATE <= nvl(l_end_date,cdl.PA_DATE); Bug# 2255068*/
1295:
1296: else -- PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'Y' -- bug 9165385
1297:
1298: update pa_cost_distribution_lines cdl
1299: set burden_sum_rejection_code = NULL,
1300: request_id = x_request_id, /*2161261*/

Line 1329: if PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'N' then -- bug 9165385

1325: /* bug 9165385 ends */
1326:
1327: ELSE
1328:
1329: if PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'N' then -- bug 9165385
1330:
1331: /* Bug# 9373031: Added hint for performane issue */
1332: update /*+ INDEX (cdl, PA_COST_DISTRIBUTION_LINES_N10) */ pa_cost_distribution_lines cdl
1333: set burden_sum_rejection_code = NULL,

Line 1345: else -- PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'Y' -- bug 9165385

1341: and cdl.burden_sum_source_run_id = init_cdl_run_id
1342: and cdl.project_id = current_project_id
1343: and rownum <= l_profile_set_size;
1344:
1345: else -- PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'Y' -- bug 9165385
1346:
1347: update pa_cost_distribution_lines cdl
1348: set burden_sum_rejection_code = NULL,
1349: request_id = x_request_id, /*2161261*/

Line 1389: if PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'N' then -- bug 9165385

1385: * The following update ensures that all CDLs of an EI gets processed
1386: * in the same batch.
1387: */
1388:
1389: if PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'N' then -- bug 9165385
1390:
1391: /* Bug# 9373031: Added hint for performane issue */
1392: update /*+ INDEX (cdl, PA_COST_DISTRIBUTION_LINES_N10) */ pa_cost_distribution_lines cdl
1393: set burden_sum_rejection_code = NULL

Line 1410: else -- PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'Y' -- bug 9165385

1406: where cdl1.burden_sum_source_run_id+0 = current_run_id
1407: and cdl1.burden_sum_rejection_code is NULL /*3071338*/
1408: and cdl1.expenditure_item_id= cdl.expenditure_item_id) ;
1409:
1410: else -- PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'Y' -- bug 9165385
1411:
1412: update pa_cost_distribution_lines cdl
1413: set burden_sum_rejection_code = NULL
1414: ,request_id = x_request_id

Line 2083: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;

2079: -- ------------------------------------------------------------------------
2080: IF P_DEBUG_MODE THEN
2081: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500');
2082: END IF;
2083: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
2084: IF P_DEBUG_MODE THEN
2085: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');
2086: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1800:Call FlushEiTabs');
2087: END IF;

Line 2582: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;

2578: IF P_DEBUG_MODE THEN
2579: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500');
2580: END IF;
2581:
2582: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
2583:
2584: IF P_DEBUG_MODE THEN
2585: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');
2586: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2350:Process Last Set ..Call Flusheitabs');

Line 2627: PA_BURDEN_COSTING.InsBurdenAudit(current_project_id,x_request_id,l_user_id,lstatus);

2623:
2624: IF l_burden_profile ='Y' Then /*3040724*/
2625: /*2933915 :Create Audit records for the special cdls using prev_ind_compiled_set_id and burden_sum_source_run_id*/
2626:
2627: PA_BURDEN_COSTING.InsBurdenAudit(current_project_id,x_request_id,l_user_id,lstatus);
2628:
2629: /*2933915 :Resetting 'special eis' -Adjustment Type and commiting by batches */
2630:
2631: /* LOOP commented for Bug 4747865 */

Line 2904: -- Set current project id in the package pa_burden_costing for view definitions and for local variable

2900:
2901: stage := 200; -- at start
2902: for proj_rec in projects loop
2903: --dbms_output.put_line('no of projects');
2904: -- Set current project id in the package pa_burden_costing for view definitions and for local variable
2905:
2906: PA_BURDEN_COSTING.set_current_project_id(proj_rec.project_id);
2907: current_project_id := proj_rec.project_id;
2908:

Line 2906: PA_BURDEN_COSTING.set_current_project_id(proj_rec.project_id);

2902: for proj_rec in projects loop
2903: --dbms_output.put_line('no of projects');
2904: -- Set current project id in the package pa_burden_costing for view definitions and for local variable
2905:
2906: PA_BURDEN_COSTING.set_current_project_id(proj_rec.project_id);
2907: current_project_id := proj_rec.project_id;
2908:
2909: -- ======
2910: -- Bug : 3699045 - PJ.M:B4:P13:OTH:PERF:XPL PERFORMANCE ISSUES IN PAVW341.SQL

Line 2912: PA_BURDEN_COSTING.set_current_sponsored_flag(proj_rec.project_id);

2908:
2909: -- ======
2910: -- Bug : 3699045 - PJ.M:B4:P13:OTH:PERF:XPL PERFORMANCE ISSUES IN PAVW341.SQL
2911: -- ======
2912: PA_BURDEN_COSTING.set_current_sponsored_flag(proj_rec.project_id);
2913:
2914: -- Step 2a. Project level validations
2915: -- Set the project and task id of the burden expenditure item
2916: -- depending on burden_accounting flag

Line 3557: end PA_BURDEN_COSTING;

3553:
3554:
3555: END update_gtemp;
3556:
3557: end PA_BURDEN_COSTING;