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.80.12010000.8 2008/11/06 14:08:26 anuragar ship $ */
3:
4: RESOURCE_BUSY EXCEPTION;
5: PRAGMA EXCEPTION_INIT( RESOURCE_BUSY, -0054 );

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

222: AND nvl( i.non_labor_resource, 'DUMMY' ) =
223: nvl( X_nl_resource, 'DUMMY' )
224: AND i.transaction_source ||'' = X_trx_source
225: AND nvl( i.net_zero_adjustment_flag, 'N' ) = 'N'
226: AND pa_adjustments.ei_adjusted_in_cache(i.expenditure_item_id) = 'N'
227: -- SSt changes: If we have the orig_txn_ref of the reversing item,
228: -- then the item we find must have the matching orig_txn_reference.
229: -- If we don't have the orig_txn_reference of the reversing item,
230: -- then the item we find does not need to satisfy the following

Line 772: Pa_Adjustments.BackOutId := X_backout_id;

768: /*
769: Project Summarization changes:
770: Store the backout_id in the global variable
771: */
772: Pa_Adjustments.BackOutId := X_backout_id;
773:
774: SetNetZero( X_exp_item_id
775: , X_user
776: , X_login

Line 1028: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

1024: WHERE
1025: expenditure_item_id = eachRec.expenditure_item_id;
1026:
1027:
1028: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
1029: , 'REVENUE RECALC'
1030: , X_module
1031: , X_user
1032: , X_login

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

1183: , raw_cost_rate = NULL
1184: , acct_raw_cost = NULL
1185: , raw_cost = NULL
1186: /* Added denom_currency_code for Bug#2291180 */
1187: , denom_currency_code = pa_adjustments.get_denom_curr_code(transaction_source,expenditure_type,denom_currency_code,acct_currency_code,system_linkage_function)
1188: , denom_burdened_cost = NULL
1189: , acct_burdened_cost = NULL
1190: , burden_cost_rate = NULL
1191: , burden_cost = NULL

Line 1205: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

1201: expenditure_item_id = eachRec.expenditure_item_id;
1202:
1203: item_count := item_count + 1;
1204:
1205: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
1206: , 'COST AND REV RECALC'
1207: , X_module
1208: , X_user
1209: , X_login

Line 1279: , 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)

1275: , ei.raw_cost = NULL
1276: , ei.denom_burdened_cost = decode( trx_source_burden, 'N',
1277: decode(system_linkage, 'BTC', ei.denom_burdened_cost, NULL),decode(getprojburdenflag(ei.project_id),'N',NULL,ei.denom_burdened_cost) ) /*Added for bug:7157616*/
1278: /* Added denom_currency_code for Bug#2291180 */
1279: , 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)
1280: , ei.acct_burdened_cost = NULL
1281: , ei.burden_cost_rate = NULL
1282: , ei.burden_cost = NULL
1283: /* Begin Burdening Changes - PA.L */

Line 1337: , 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)

1333: , ei.raw_cost = NULL
1334: , ei.denom_burdened_cost =
1335: decode( trx_source_burden, 'N', NULL, decode(getprojburdenflag(ei.project_id),'N',NULL,ei.denom_burdened_cost) ) /*Added for bug:7157616*/
1336: /* Added denom_currency_code for Bug#2291180 */
1337: , 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)
1338: , ei.acct_burdened_cost = NULL
1339: , ei.burden_cost_rate = NULL
1340: , ei.burden_cost = NULL
1341: , ei.project_burdened_cost = NULL

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

1555: , acct_raw_cost = NULL
1556: , raw_cost = NULL
1557: , raw_cost_rate = NULL
1558: /* Added denom_currency_code for Bug#2291180 */
1559: , denom_currency_code = pa_adjustments.get_denom_curr_code(transaction_source,expenditure_type,denom_currency_code,acct_currency_code,system_linkage_function)
1560: , denom_burdened_cost = NULL
1561: , acct_burdened_cost = NULL
1562: , burden_cost_rate = NULL
1563: , burden_cost = NULL

Line 1577: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

1573: expenditure_item_id = eachRec.expenditure_item_id;
1574:
1575: item_count := item_count + 1;
1576:
1577: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
1578: , 'RAW COST RECALC'
1579: , X_module
1580: , X_user
1581: , X_login

Line 1653: , 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)

1649: , ei.denom_burdened_cost =decode( trx_source_burden, 'N',
1650: decode(system_linkage, 'BTC', ei.denom_burdened_cost, NULL)
1651: ,decode(getprojburdenflag(ei.project_id),'N',NULL,ei.denom_burdened_cost)) /*added for bug:7157616*/
1652: /* Added denom_currency_code for Bug#2291180 */
1653: , 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)
1654: , ei.acct_burdened_cost = NULL
1655: , ei.burden_cost_rate = NULL
1656: , ei.burden_cost = NULL
1657: /* Begin Burdening Changes - PA.L */

Line 1710: , 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)

1706: decode( trx_source_accounted, 'N', NULL, ei.acct_raw_cost ) )
1707: , ei.denom_burdened_cost =
1708: decode( trx_source_burden, 'N', NULL, decode(getprojburdenflag(ei.project_id),'N',NULL,ei.denom_burdened_cost) ) /*added for bug:7157616*/
1709: /* Added denom_currency_code for Bug#2291180 */
1710: , 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)
1711: , ei.acct_burdened_cost = NULL
1712: , ei.burden_cost_rate = NULL
1713: , ei.burden_cost = NULL
1714: , ei.raw_cost = NULL

Line 3017: X_backout_id => Pa_Adjustments.BackOutId,

3013: print_message('get_denom_curr_code: ' || 'calling Pa_Costing.CreateReverseCdl api');
3014: END IF;
3015:
3016: Pa_Costing.CreateReverseCdl( X_exp_item_id => X_exp_item_id,
3017: X_backout_id => Pa_Adjustments.BackOutId,
3018: X_user => X_user,
3019: X_status => temp_status);
3020:
3021: CheckStatus( status_indicator => temp_status );

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

5745: || ' and cdl1.line_num = 1'
5746: || ' and NVL(cdl1.reversed_flag,''N'') <> ''Y'')'
5747: || ' AND ei.net_zero_adjustment_flag = ''N'''
5748: || ' AND ei.transferred_from_exp_item_id IS NULL'
5749: || ' AND pa_adjustments.is_orphaned_src_sys_reversal(ei.document_distribution_id,ei.transaction_source) = ''Y'''; /* 4901129 */
5750: END IF;
5751:
5752: if X_cc_code_to_be_determined <> 'N'
5753: or X_cc_code_not_crosscharged <> 'XX'

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

6716: IF NVL(FND_PROFILE.VALUE('PA_ALLOW_RCV_ERV_ADJ_WHEN_JOURNAL_CONVERT'), 'N') = 'N'
6717: AND RepCurrOrSecLedgerDiffCurr(v_exp_org_id) THEN
6718:
6719: IF l_transaction_source = 'AP ERV'
6720: AND not PA_Adjustments.IsPeriodEndAccrual(l_document_distribution_id) THEN /* Bug 5381260 */
6721: v_allow_adjustments := 'PA_ERV_PROF_SET_TO_NO';
6722: END IF;
6723: IF l_transaction_source IN ( 'PO RECEIPT', 'PO RECEIPT NRTAX'
6724: , 'PO RECEIPT NRTAX PRICE ADJ', 'PO RECEIPT PRICE ADJ') THEN

Line 6747: IF pa_adjustments.is_recoverability_affected

6743: , 'COST AND REV RECALC')
6744: OR ( X_adj_action = 'CHANGE WORK TYPE ATTRIBUTE'
6745: AND NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag)) THEN
6746:
6747: IF pa_adjustments.is_recoverability_affected
6748: (p_expenditure_item_id => v_expenditure_item_id
6749: ,p_org_id => v_exp_org_id
6750: ,p_system_linkage_function => v_system_linkage
6751: ,p_transaction_source => l_transaction_source

Line 6793: IF NOT pa_adjustments.Allow_Adjust_with_Auto_Offset

6789: , 'COST AND REV RECALC')
6790: OR ( X_adj_action = 'CHANGE WORK TYPE ATTRIBUTE'
6791: AND NVL(PA_UTILS4.get_trxn_work_billabilty(p_dest_work_type_id, NULL),l_billable_flag) <> l_billable_flag)) THEN
6792:
6793: IF NOT pa_adjustments.Allow_Adjust_with_Auto_Offset
6794: (p_expenditure_item_id => v_expenditure_item_id
6795: ,p_org_id => v_exp_org_id
6796: ,p_system_linkage_function => v_system_linkage
6797: ,p_transaction_source => l_transaction_source

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

7654: l_exp_item_id Number(15) := NULL;
7655:
7656: BEGIN
7657:
7658: l_exp_item_id := pa_adjustments.ExpAdjItemTab(X_exp_item_id);
7659: RETURN('Y');
7660:
7661: EXCEPTION WHEN NO_DATA_FOUND THEN
7662: RETURN('N');

Line 7766: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

7762: expenditure_item_id = eachRec.expenditure_item_id;
7763:
7764: item_count := item_count + 1;
7765:
7766: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
7767: , 'CHANGE FUNC ATTRIBUTE'
7768: , X_module
7769: , X_user
7770: , X_login

Line 8026: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

8022: expenditure_item_id = eachRec.expenditure_item_id;
8023:
8024: item_count := item_count + 1;
8025:
8026: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
8027: , 'CHANGE PROJ FUNC ATTRIBUTE'
8028: , X_module
8029: , X_user
8030: , X_login

Line 8273: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

8269: expenditure_item_id = eachRec.expenditure_item_id;
8270:
8271: item_count := item_count + 1;
8272:
8273: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
8274: , 'CHANGE PROJ ATTRIBUTE'
8275: , X_module
8276: , X_user
8277: , X_login

Line 8499: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

8495: expenditure_item_id = eachRec.expenditure_item_id;
8496:
8497: item_count := item_count + 1;
8498:
8499: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
8500: , 'REPROCESS CROSS CHARGE'
8501: , X_module
8502: , X_user
8503: , X_login

Line 8774: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

8770: expenditure_item_id = eachRec.expenditure_item_id;
8771:
8772: item_count := item_count + 1;
8773:
8774: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
8775: , 'MARK NO CC PROCESS'
8776: , X_module
8777: , X_user
8778: , X_login

Line 8966: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id

8962: expenditure_item_id = eachRec.expenditure_item_id;
8963:
8964: item_count := item_count + 1;
8965:
8966: pa_adjustments.InsAuditRec( eachRec.expenditure_item_id
8967: , 'CHANGE TP ATTRIBUTE'
8968: , X_module
8969: , X_user
8970: , X_login

Line 10879: END PA_ADJUSTMENTS ;

10875: RETURN FALSE;
10876: END IsRelatedToPrepayApp;
10877: /* Bug 5501250 - End */
10878:
10879: END PA_ADJUSTMENTS ;