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_ADJUSTMENTS dependencies on PA_ADJUSTMENTS

Line 1: PACKAGE BODY PA_ADJUSTMENTS AS

1: PACKAGE BODY PA_ADJUSTMENTS AS
2: /* $Header: PAXTADJB.pls 120.107.12020000.6 2013/04/18 13:47:56 rboyalap ship $ */
3:
4: RESOURCE_BUSY EXCEPTION;
5: PRAGMA EXCEPTION_INIT( RESOURCE_BUSY, -0054 );

Line 214: AND pa_adjustments.ei_adjusted_in_cache(i.expenditure_item_id) = 'N'

210: AND NVL( i.net_zero_adjustment_flag, 'N' ) = 'N'
211: AND i.transaction_source = ts.transaction_source
212: AND (i.orig_transaction_reference = X_reversed_orig_txn_reference
213: OR X_reversed_orig_txn_reference IS NULL)
214: AND pa_adjustments.ei_adjusted_in_cache(i.expenditure_item_id) = 'N'
215: AND i.expenditure_id = e.expenditure_id
216: AND ( ( ts.costed_flag = 'Y'
217: AND ( i.denom_raw_cost * -1) = pa_currency.round_trans_currency_amt(X_denom_raw_cost,X_denom_currency_code))
218: OR ( ts.costed_flag = 'N' ) )

Line 800: Pa_Adjustments.BackOutId := X_backout_id;

796: /*
797: Project Summarization changes:
798: Store the backout_id in the global variable
799: */
800: Pa_Adjustments.BackOutId := X_backout_id;
801:
802: SetNetZero( X_exp_item_id
803: , X_user
804: , X_login

Line 1057: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

1053: WHERE
1054: expenditure_item_id = eachRec.expenditure_item_id;
1055:
1056:
1057: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
1058: , 'REVENUE RECALC'
1059: , X_module
1060: , X_user
1061: , X_login

Line 1226: , denom_currency_code = pa_adjustments.get_denom_curr_code(l_transaction_source,expenditure_type,denom_currency_code,acct_currency_code,system_linkage_function) --Bug 12816655

1222: , raw_cost_rate = NULL
1223: , acct_raw_cost = NULL
1224: , raw_cost = NULL
1225: /* Added denom_currency_code for Bug#2291180 */
1226: , denom_currency_code = pa_adjustments.get_denom_curr_code(l_transaction_source,expenditure_type,denom_currency_code,acct_currency_code,system_linkage_function) --Bug 12816655
1227: , denom_burdened_cost = NULL
1228: , acct_burdened_cost = NULL
1229: , burden_cost_rate = NULL
1230: , burden_cost = NULL

Line 1245: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

1241: expenditure_item_id = eachRec.expenditure_item_id;
1242:
1243: item_count := item_count + 1;
1244:
1245: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
1246: , 'COST AND REV RECALC'
1247: , X_module
1248: , X_user
1249: , X_login

Line 1320: , ei.denom_currency_code = pa_adjustments.get_denom_curr_code(ei.transaction_source,ei.expenditure_type, ei.denom_currency_code, ei.acct_currency_code, ei.system_linkage_function)

1316: , ei.raw_cost = NULL
1317: , ei.denom_burdened_cost = decode( trx_source_burden, 'N',
1318: decode(system_linkage, 'BTC', ei.denom_burdened_cost, NULL),decode(getprojburdenflag(ei.project_id),'N',NULL,ei.denom_burdened_cost) ) /*Added for bug:7157616*/
1319: /* Added denom_currency_code for Bug#2291180 */
1320: , ei.denom_currency_code = pa_adjustments.get_denom_curr_code(ei.transaction_source,ei.expenditure_type, ei.denom_currency_code, ei.acct_currency_code, ei.system_linkage_function)
1321: , ei.acct_burdened_cost = NULL
1322: , ei.burden_cost_rate = NULL
1323: , ei.burden_cost = NULL
1324: /* Begin Burdening Changes - PA.L */

Line 1380: , ei.denom_currency_code = pa_adjustments.get_denom_curr_code(ei.transaction_source,ei.expenditure_type, ei.denom_currency_code, ei.acct_currency_code, ei.system_linkage_function)

1376: , ei.raw_cost = NULL
1377: , ei.denom_burdened_cost =
1378: decode( trx_source_burden, 'N', NULL, decode(getprojburdenflag(ei.project_id),'N',NULL,ei.denom_burdened_cost) ) /*Added for bug:7157616*/
1379: /* Added denom_currency_code for Bug#2291180 */
1380: , ei.denom_currency_code = pa_adjustments.get_denom_curr_code(ei.transaction_source,ei.expenditure_type, ei.denom_currency_code, ei.acct_currency_code, ei.system_linkage_function)
1381: , ei.acct_burdened_cost = NULL
1382: , ei.burden_cost_rate = NULL
1383: , ei.burden_cost = NULL
1384: , ei.project_burdened_cost = NULL

Line 1610: , denom_currency_code = pa_adjustments.get_denom_curr_code(l_transaction_source,expenditure_type,denom_currency_code,acct_currency_code,system_linkage_function) --Bug 12816655

1606: , acct_raw_cost = NULL
1607: , raw_cost = NULL
1608: , raw_cost_rate = NULL
1609: /* Added denom_currency_code for Bug#2291180 */
1610: , denom_currency_code = pa_adjustments.get_denom_curr_code(l_transaction_source,expenditure_type,denom_currency_code,acct_currency_code,system_linkage_function) --Bug 12816655
1611: , denom_burdened_cost = NULL
1612: , acct_burdened_cost = NULL
1613: , burden_cost_rate = NULL
1614: , burden_cost = NULL

Line 1629: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

1625: expenditure_item_id = eachRec.expenditure_item_id;
1626:
1627: item_count := item_count + 1;
1628:
1629: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
1630: , 'RAW COST RECALC'
1631: , X_module
1632: , X_user
1633: , X_login

Line 1706: , ei.denom_currency_code = pa_adjustments.get_denom_curr_code(ei.transaction_source,ei.expenditure_type, ei.denom_currency_code, ei.acct_currency_code, ei.system_linkage_function)

1702: , ei.denom_burdened_cost =decode( trx_source_burden, 'N',
1703: decode(system_linkage, 'BTC', ei.denom_burdened_cost, NULL)
1704: ,decode(getprojburdenflag(ei.project_id),'N',NULL,ei.denom_burdened_cost)) /*added for bug:7157616*/
1705: /* Added denom_currency_code for Bug#2291180 */
1706: , ei.denom_currency_code = pa_adjustments.get_denom_curr_code(ei.transaction_source,ei.expenditure_type, ei.denom_currency_code, ei.acct_currency_code, ei.system_linkage_function)
1707: , ei.acct_burdened_cost = NULL
1708: , ei.burden_cost_rate = NULL
1709: , ei.burden_cost = NULL
1710: /* Begin Burdening Changes - PA.L */

Line 1765: , ei.denom_currency_code = pa_adjustments.get_denom_curr_code(ei.transaction_source,ei.expenditure_type, ei.denom_currency_code, ei.acct_currency_code, ei.system_linkage_function)

1761: decode( trx_source_accounted, 'N', NULL, ei.acct_raw_cost ) )
1762: , ei.denom_burdened_cost =
1763: decode( trx_source_burden, 'N', NULL, decode(getprojburdenflag(ei.project_id),'N',NULL,ei.denom_burdened_cost) ) /*added for bug:7157616*/
1764: /* Added denom_currency_code for Bug#2291180 */
1765: , ei.denom_currency_code = pa_adjustments.get_denom_curr_code(ei.transaction_source,ei.expenditure_type, ei.denom_currency_code, ei.acct_currency_code, ei.system_linkage_function)
1766: , ei.acct_burdened_cost = NULL
1767: , ei.burden_cost_rate = NULL
1768: , ei.burden_cost = NULL
1769: , ei.raw_cost = NULL

Line 3076: X_backout_id => Pa_Adjustments.BackOutId,

3072: print_message('get_denom_curr_code: ' || 'calling Pa_Costing.CreateReverseCdl api');
3073: END IF;
3074:
3075: Pa_Costing.CreateReverseCdl( X_exp_item_id => X_exp_item_id,
3076: X_backout_id => Pa_Adjustments.BackOutId,
3077: X_user => X_user,
3078: X_status => temp_status);
3079:
3080: CheckStatus( status_indicator => temp_status );

Line 5893: || ' AND pa_adjustments.is_orphaned_src_sys_reversal(ei.document_distribution_id,ei.transaction_source) = ''Y'''; /* 4901129 */

5889: || ' and cdl1.line_num = 1'
5890: || ' and NVL(cdl1.reversed_flag,''N'') <> ''Y'')'
5891: || ' AND ei.net_zero_adjustment_flag = ''N'''
5892: || ' AND ei.transferred_from_exp_item_id IS NULL'
5893: || ' AND pa_adjustments.is_orphaned_src_sys_reversal(ei.document_distribution_id,ei.transaction_source) = ''Y'''; /* 4901129 */
5894: END IF;
5895:
5896: if X_cc_code_to_be_determined <> 'N'
5897: or X_cc_code_not_crosscharged <> 'XX'

Line 6884: AND not PA_Adjustments.IsPeriodEndAccrual(l_document_distribution_id) THEN /* Bug 5381260 */

6880: IF NVL(FND_PROFILE.VALUE('PA_ALLOW_RCV_ERV_ADJ_WHEN_JOURNAL_CONVERT'), 'N') = 'N'
6881: AND RepCurrOrSecLedgerDiffCurr(v_exp_org_id) THEN
6882:
6883: IF l_transaction_source = 'AP ERV'
6884: AND not PA_Adjustments.IsPeriodEndAccrual(l_document_distribution_id) THEN /* Bug 5381260 */
6885: v_allow_adjustments := 'PA_ERV_PROF_SET_TO_NO';
6886: END IF;
6887: IF l_transaction_source IN ( 'PO RECEIPT', 'PO RECEIPT NRTAX'
6888: , 'PO RECEIPT NRTAX PRICE ADJ', 'PO RECEIPT PRICE ADJ') THEN

Line 6911: IF pa_adjustments.is_recoverability_affected

6907: , 'COST AND REV RECALC')
6908: OR ( X_adj_action = 'CHANGE WORK TYPE ATTRIBUTE'
6909: AND NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag)) THEN
6910:
6911: IF pa_adjustments.is_recoverability_affected
6912: (p_expenditure_item_id => v_expenditure_item_id
6913: ,p_org_id => v_exp_org_id
6914: ,p_system_linkage_function => v_system_linkage
6915: ,p_transaction_source => l_transaction_source

Line 6958: IF NOT pa_adjustments.Allow_Adjust_with_Auto_Offset

6954: , 'COST AND REV RECALC')
6955: OR ( X_adj_action = 'CHANGE WORK TYPE ATTRIBUTE'
6956: AND NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag)) THEN
6957:
6958: IF NOT pa_adjustments.Allow_Adjust_with_Auto_Offset
6959: (p_expenditure_item_id => v_expenditure_item_id
6960: ,p_org_id => v_exp_org_id
6961: ,p_system_linkage_function => v_system_linkage
6962: ,p_transaction_source => l_transaction_source

Line 7877: l_exp_item_id := pa_adjustments.ExpAdjItemTab(X_exp_item_id);

7873: l_exp_item_id Number(15) := NULL;
7874:
7875: BEGIN
7876:
7877: l_exp_item_id := pa_adjustments.ExpAdjItemTab(X_exp_item_id);
7878: RETURN('Y');
7879:
7880: EXCEPTION WHEN NO_DATA_FOUND THEN
7881: RETURN('N');

Line 7986: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

7982: expenditure_item_id = eachRec.expenditure_item_id;
7983:
7984: item_count := item_count + 1;
7985:
7986: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
7987: , 'CHANGE FUNC ATTRIBUTE'
7988: , X_module
7989: , X_user
7990: , X_login

Line 8248: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

8244: expenditure_item_id = eachRec.expenditure_item_id;
8245:
8246: item_count := item_count + 1;
8247:
8248: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
8249: , 'CHANGE PROJ FUNC ATTRIBUTE'
8250: , X_module
8251: , X_user
8252: , X_login

Line 8497: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

8493: expenditure_item_id = eachRec.expenditure_item_id;
8494:
8495: item_count := item_count + 1;
8496:
8497: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
8498: , 'CHANGE PROJ ATTRIBUTE'
8499: , X_module
8500: , X_user
8501: , X_login

Line 8756: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

8752: l_parent_Cc_Code:=NULL;
8753:
8754: item_count := item_count + 1;
8755:
8756: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
8757: , 'REPROCESS CROSS CHARGE'
8758: , X_module
8759: , X_user
8760: , X_login

Line 9057: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

9053: expenditure_item_id = eachRec.expenditure_item_id;
9054:
9055: item_count := item_count + 1;
9056:
9057: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
9058: , 'MARK NO CC PROCESS'
9059: , X_module
9060: , X_user
9061: , X_login

Line 9249: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

9245: expenditure_item_id = eachRec.expenditure_item_id;
9246:
9247: item_count := item_count + 1;
9248:
9249: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
9250: , 'CHANGE TP ATTRIBUTE'
9251: , X_module
9252: , X_user
9253: , X_login

Line 11224: END PA_ADJUSTMENTS ;

11220: RETURN FALSE;
11221: END IsRelatedToPrepayApp;
11222: /* Bug 5501250 - End */
11223:
11224: END PA_ADJUSTMENTS ;