APPS.PA_REVERSE_COSTED_LAB dependencies on PA_ADJUSTMENTS

Line 374: pa_adjustments.InsAuditRec

370: THEN
371: write_log(LOG,'Project:'|| l_project_id_tbl(i)||'is Closed ');
372: END IF;
373: l_Reverse_eligibile_flag_Tab(i) := 'N';
374: pa_adjustments.InsAuditRec
375: ( l_Exp_item_id_tbl(i)
376: , 'PA_REVERSAL'
377: , 'PAXREVTXN'
378: , g_user_id

Line 388: pa_adjustments.CheckStatus(temp_status);

384: , SYSDATE
385: , 'PA_SUM_PROJECT_CLOSED'
386: );
387:
388: pa_adjustments.CheckStatus(temp_status);
389:
390:
391: END IF ;
392:

Line 413: pa_adjustments.InsAuditRec( l_Exp_item_id_tbl(j)

409: LOOP
410: IF ((l_PersonIdTab(i) = l_PersonIdTab(j)) AND (l_Interface_run_idTab(i) = l_Interface_run_idTab(j)) AND l_Cost_Dist_Flag_tbl(j) = 'Y' )
411: THEN
412: l_Reverse_eligibile_flag_Tab(j) := 'N';
413: pa_adjustments.InsAuditRec( l_Exp_item_id_tbl(j)
414: , 'PA_REVERSAL'
415: , 'PAXREVTXN'
416: , g_user_id
417: , g_login_id

Line 425: pa_adjustments.CheckStatus(temp_status);

421: , G_PROG_APPL_ID
422: , SYSDATE
423: , 'PA_EMP_COSTSET_REJECT'
424: );
425: pa_adjustments.CheckStatus(temp_status);
426: END IF;
427: END LOOP;
428:
429: OPEN c_uncosted_costset( l_PersonIdTab(i),l_Interface_run_idTab(i));

Line 434: pa_adjustments.InsAuditRec( l_Exp_item_id_tb2(i) /*Added for bug:12611695 */

430: FETCH c_uncosted_costset BULK COLLECT INTO l_Exp_item_id_tb2;
431: FOR i in 1 .. l_Exp_item_id_tb2.COUNT
432: LOOP
433: l_Reverse_eligibile_flag_Tab(i) :='N';
434: pa_adjustments.InsAuditRec( l_Exp_item_id_tb2(i) /*Added for bug:12611695 */
435: , 'PA_REVERSAL'
436: , 'PAXREVTXN'
437: , g_user_id
438: , g_login_id

Line 446: pa_adjustments.CheckStatus(temp_status);

442: , G_PROG_APPL_ID
443: , SYSDATE
444: , 'PA_EMP_COSTSET_UNCOSTED' /*Added for bug:12611695 */
445: );
446: pa_adjustments.CheckStatus(temp_status);
447: END LOOP;
448: CLOSE c_uncosted_costset;
449:
450: --Added for Bug 12779047

Line 460: pa_adjustments.InsAuditRec( l_Exp_item_id_tb3(i)

456:
457: write_log(LOG,'cannot roll back ei - ' || l_Exp_item_id_tb3(i) );
458: l_Reverse_eligibile_flag_Tab(i) :='N';
459:
460: pa_adjustments.InsAuditRec( l_Exp_item_id_tb3(i)
461: , 'PA_REVERSAL'
462: , 'PAXREVTXN'
463: , g_user_id
464: , g_login_id

Line 472: pa_adjustments.CheckStatus(temp_status);

468: , G_PROG_APPL_ID
469: , SYSDATE
470: , 'PA_COSTSET_ADJUSTED'
471: );
472: pa_adjustments.CheckStatus(temp_status);
473:
474: END LOOP;
475: CLOSE c_block_backout;
476:

Line 543: pa_adjustments.backoutitem (

539:
540: G_err_stage := ' Stage-1 :Calling backoutitem Procedure to reverse selected Costed expenditure Items';
541: write_log(LOG, G_err_stage);
542:
543: pa_adjustments.backoutitem (
544: X_exp_item_id => l_Exp_item_id_tbl(i)
545: ,X_expenditure_id => NULL
546: ,X_adj_activity => 'BACKOUT_COSTED_ITEM'
547: ,X_module => 'PAXREVTXN'

Line 700: pa_adjustments.InsAuditRec( X_expenditure_item_id

696: l_is_ei_reversable :='N';
697: END IF ;
698: IF l_is_ei_reversable ='N' THEN
699: --AUDITING
700: pa_adjustments.InsAuditRec( X_expenditure_item_id
701: , 'REVERSAL'
702: , 'PAXREVTXN'
703: , g_user_id
704: , g_login_id

Line 711: pa_adjustments.CheckStatus(temp_status);

707: , G_PROGRAM_ID
708: , G_PROG_APPL_ID
709: , sysdate
710: , 'PA_TR_APE_NO_ADJUST');
711: pa_adjustments.CheckStatus(temp_status);
712: IF g_debug_mode ='Y' THEN
713: write_log(LOG, 'Transaction Source Do Not Allow Adjustements for Expenditure Item:=>'||X_expenditure_item_id);
714: END IF;
715: END IF;

Line 1563: PA_ADJUSTMENTS.CheckStatus( status_indicator => temp_status );

1559: , X_ei_comment => item_comment
1560: , X_user => X_user
1561: , X_login => X_login
1562: , X_status => temp_status );
1563: PA_ADJUSTMENTS.CheckStatus( status_indicator => temp_status );
1564: END IF;
1565: /* End of Fix for bug 2211472 */
1566:
1567: PA_ADJUSTMENTS.InsAuditRec( X_transfer_id

Line 1567: PA_ADJUSTMENTS.InsAuditRec( X_transfer_id

1563: PA_ADJUSTMENTS.CheckStatus( status_indicator => temp_status );
1564: END IF;
1565: /* End of Fix for bug 2211472 */
1566:
1567: PA_ADJUSTMENTS.InsAuditRec( X_transfer_id
1568: , X_adj_activity
1569: , X_module
1570: , X_user
1571: , X_login

Line 1579: PA_ADJUSTMENTS.CheckStatus( temp_status );

1575: , G_PROGRAM_ID
1576: , G_PROG_APPL_ID
1577: , sysdate );
1578: /* R12 Changes End */
1579: PA_ADJUSTMENTS.CheckStatus( temp_status );
1580: X_status := 0;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: X_status := SQLCODE;