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_EXPENDITURE_ITEMS_ALL

Line 436: UPDATE pa_expenditure_items_all ei

432: , X_login IN NUMBER
433: , X_status OUT NOCOPY NUMBER )
434: IS
435: BEGIN
436: UPDATE pa_expenditure_items_all ei
437: SET
438: ei.net_zero_adjustment_flag = 'Y'
439: , ei.last_update_date = sysdate
440: , ei.last_updated_by = X_user

Line 475: INSERT INTO pa_expenditure_items_all(

471: BEGIN
472:
473: X_backout_id := pa_utils.GetNextEiId;
474:
475: INSERT INTO pa_expenditure_items_all(
476: expenditure_item_id
477: , task_id
478: , expenditure_type
479: , system_linkage_function

Line 715: pa_expenditure_items_all ei

711: , ei.document_type
712: , ei.document_distribution_type
713: /* R12 Changes - End */
714: FROM
715: pa_expenditure_items_all ei
716: WHERE
717: ei.expenditure_item_id = X_exp_item_id;
718:
719: /* Fix for Bug 3684711 */

Line 897: pa_expenditure_items_all ei

893: CURSOR GetRelatedItems IS
894: SELECT
895: ei.expenditure_item_id
896: FROM
897: pa_expenditure_items_all ei
898: WHERE
899: ei.source_expenditure_item_id = X_source_exp_item_id
900: AND nvl(ei.net_zero_adjustment_flag, 'N') <> 'Y';
901:

Line 963: Update pa_expenditure_items_all ei

959: -- in the sub-query.
960: --------------------------------------------------------------------------------
961:
962:
963: Update pa_expenditure_items_all ei
964: set ei.source_expenditure_item_id =
965: (select ei1.expenditure_item_id
966: from pa_expenditure_items_all ei1
967: where ei1.adjusted_expenditure_item_id =

Line 966: from pa_expenditure_items_all ei1

962:
963: Update pa_expenditure_items_all ei
964: set ei.source_expenditure_item_id =
965: (select ei1.expenditure_item_id
966: from pa_expenditure_items_all ei1
967: where ei1.adjusted_expenditure_item_id =
968: X_source_exp_item_id)
969: where ei.adjusted_expenditure_item_id = eachRec.expenditure_item_id;
970:

Line 1011: pa_expenditure_items_all

1007: CURSOR GetRelatedItems IS
1008: SELECT
1009: expenditure_item_id
1010: FROM
1011: pa_expenditure_items_all
1012: WHERE
1013: source_expenditure_item_id = X_expenditure_item_id;
1014: BEGIN
1015:

Line 1018: UPDATE pa_expenditure_items_all

1014: BEGIN
1015:
1016: FOR eachRec IN GetRelatedItems LOOP
1017:
1018: UPDATE pa_expenditure_items_all
1019: SET
1020: revenue_distributed_flag = 'N'
1021: , last_updated_by = X_user
1022: , last_update_date = sysdate

Line 1070: UPDATE pa_expenditure_items_all ei

1066: temp_status NUMBER DEFAULT NULL;
1067: BEGIN
1068: FOR i IN 1..rows LOOP
1069:
1070: UPDATE pa_expenditure_items_all ei
1071: SET
1072: ei.revenue_distributed_flag = 'N'
1073: , ei.last_update_date = sysdate
1074: , ei.last_updated_by = X_user

Line 1095: UPDATE pa_expenditure_items_all eia

1091: CheckStatus( temp_status );
1092:
1093: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
1094:
1095: UPDATE pa_expenditure_items_all eia
1096: SET
1097: eia.revenue_distributed_flag = 'N'
1098: , eia.last_update_date = sysdate
1099: , eia.last_updated_by = X_user

Line 1171: pa_expenditure_items_all

1167: CURSOR GetRelatedItems IS
1168: SELECT
1169: expenditure_item_id
1170: FROM
1171: pa_expenditure_items_all
1172: WHERE
1173: source_expenditure_item_id = X_expenditure_item_id;
1174: BEGIN
1175:

Line 1178: UPDATE pa_expenditure_items_all

1174: BEGIN
1175:
1176: FOR eachRec IN GetRelatedItems LOOP
1177:
1178: UPDATE pa_expenditure_items_all
1179: SET
1180: cost_distributed_flag = 'N'
1181: , revenue_distributed_flag = 'N'
1182: , denom_raw_cost = NULL

Line 1244: pa_expenditure_items_all ei

1240: , trx_source_accounted
1241: , trx_source_burden
1242: , system_linkage
1243: FROM
1244: pa_expenditure_items_all ei
1245: , pa_transaction_sources txs
1246: WHERE
1247: ei.transaction_source = txs.transaction_source(+)
1248: AND ei.expenditure_item_id = ItemsIdTab(i);

Line 1254: UPDATE pa_expenditure_items_all ei

1250: /* R12 Changes - Added system linkage ER in addition to VI. In R12, users
1251: cannot create Expense Reports in Projects. The following change
1252: will prohibit the user from recalculating cost for historical
1253: Expense Reports created in Projects */
1254: UPDATE pa_expenditure_items_all ei
1255: SET
1256: ei.cost_distributed_flag = 'N'
1257: /* Reverted: Added for bug #2027985
1258: decode( system_linkage, 'VI', ei.cost_distributed_flag,

Line 1312: UPDATE pa_expenditure_items_all ei

1308: CheckStatus( temp_status );
1309:
1310: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
1311:
1312: UPDATE pa_expenditure_items_all ei
1313: SET
1314: ei.cost_distributed_flag = 'N'
1315: /* Reverted : Added for bug #2027985
1316: decode( system_linkage, 'VI', ei.cost_distributed_flag,

Line 1413: pa_expenditure_items_all ei

1409: INTO
1410: trx_source_burden,
1411: system_linkage
1412: FROM
1413: pa_expenditure_items_all ei
1414: , pa_transaction_sources txs
1415: WHERE
1416: ei.transaction_source = txs.transaction_source(+)
1417: AND ei.expenditure_item_id = ItemsIdTab(i);

Line 1422: UPDATE pa_expenditure_items_all ei

1418:
1419: -- Added the Decode function for the acct_burdened_cost,burden_cost_rate,burden_cost
1420: -- to fix the bug fix : 1490316
1421:
1422: UPDATE pa_expenditure_items_all ei
1423: SET
1424: ei.cost_distributed_flag = 'N'
1425: , ei.denom_burdened_cost =
1426: decode( trx_source_burden, 'N',

Line 1466: UPDATE pa_expenditure_items_all eia

1462: CheckStatus( temp_status );
1463:
1464: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
1465:
1466: UPDATE pa_expenditure_items_all eia
1467: SET
1468: eia.cost_distributed_flag = 'N'
1469: , eia.denom_burdened_cost =
1470: decode( trx_source_burden, 'N', NULL, eia.denom_burdened_cost )

Line 1543: pa_expenditure_items_all

1539: CURSOR GetRelatedItems IS
1540: SELECT
1541: expenditure_item_id
1542: FROM
1543: pa_expenditure_items_all
1544: WHERE
1545: source_expenditure_item_id = X_expenditure_item_id;
1546: BEGIN
1547:

Line 1550: UPDATE pa_expenditure_items_all

1546: BEGIN
1547:
1548: FOR eachRec IN GetRelatedItems LOOP
1549:
1550: UPDATE pa_expenditure_items_all
1551: SET
1552: cost_distributed_flag = 'N'
1553: , revenue_distributed_flag = 'N'
1554: , denom_raw_cost = NULL

Line 1617: pa_expenditure_items_all ei

1613: , trx_source_accounted
1614: , trx_source_burden
1615: , system_linkage
1616: FROM
1617: pa_expenditure_items_all ei
1618: , pa_transaction_sources txs
1619: WHERE
1620: ei.transaction_source = txs.transaction_source(+)
1621: AND ei.expenditure_item_id = ItemsIdTab(i);

Line 1627: UPDATE pa_expenditure_items_all ei

1623: /* R12 Changes - Added system linkage ER in addition to VI. In R12, users
1624: cannot create Expense Reports in Projects. The following change
1625: will prohibit the user from recalculating cost for historical
1626: Expense Reports created in Projects */
1627: UPDATE pa_expenditure_items_all ei
1628: SET
1629: ei.cost_distributed_flag = 'N'
1630: /* Reverted: Added for bug #2027985
1631: decode( system_linkage, 'VI', ei.cost_distributed_flag,

Line 1686: UPDATE pa_expenditure_items_all ei

1682: CheckStatus( temp_status );
1683:
1684: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
1685:
1686: UPDATE pa_expenditure_items_all ei
1687: SET
1688: ei.cost_distributed_flag ='N'
1689: /* Reverted: Added for bug #2027985
1690: decode( system_linkage, 'VI', ei.cost_distributed_flag,

Line 1791: pa_expenditure_items_all ei

1787: INTO
1788: trx_source_burden,
1789: system_linkage
1790: FROM
1791: pa_expenditure_items_all ei
1792: , pa_transaction_sources txs
1793: WHERE
1794: ei.transaction_source = txs.transaction_source(+)
1795: AND ei.expenditure_item_id = ItemsIdTab(i);

Line 1801: UPDATE pa_expenditure_items_all ei

1797: --- Added the decode function for the following columns acct_burdened_cost,burden_cost_rate,
1798: --- burden_cost as a bug fix : 1490316, it enables to recalc BTC ei only for the accounting
1799: --- purpose.
1800:
1801: UPDATE pa_expenditure_items_all ei
1802: SET
1803: ei.cost_distributed_flag = 'N'
1804: , ei.revenue_distributed_flag = 'N'
1805: , ei.denom_burdened_cost =

Line 1846: UPDATE pa_expenditure_items_all eia

1842: CheckStatus( temp_status );
1843:
1844: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
1845:
1846: UPDATE pa_expenditure_items_all eia
1847: SET
1848: eia.cost_distributed_flag = 'N'
1849: , eia.denom_burdened_cost =
1850: decode( trx_source_burden, 'N', NULL, eia.denom_burdened_cost )

Line 1901: from pa_expenditure_items_all peia

1897:
1898: CURSOR c2 is
1899:
1900: select expenditure_item_id
1901: from pa_expenditure_items_all peia
1902: where exists( select null
1903: from pa_cost_distribution_lines_all cdl
1904: where cdl.expenditure_item_id = peia.expenditure_item_id)
1905: start with expenditure_item_id = X_expenditure_item_id

Line 2009: UPDATE pa_expenditure_items_all ei

2005: BEGIN
2006:
2007: FOR i IN 1..rows LOOP
2008:
2009: UPDATE pa_expenditure_items_all ei
2010: SET
2011: ei.bill_hold_flag = X_hold
2012: , ei.last_updated_by = X_user
2013: , ei.last_update_date = sysdate

Line 2034: UPDATE pa_expenditure_items_all eia

2030: CheckStatus( temp_status );
2031:
2032: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
2033:
2034: UPDATE pa_expenditure_items_all eia
2035: SET
2036: eia.bill_hold_flag = X_hold
2037: , eia.last_updated_by = X_user
2038: , eia.last_update_date = sysdate

Line 2193: FROM pa_expenditure_items_all ei,

2189: l_projfunc_cost_rate_date,
2190: l_projfunc_cost_rate_type,
2191: l_projfunc_cost_exchg_rate,
2192: l_work_type_id
2193: FROM pa_expenditure_items_all ei,
2194: pa_transaction_sources tr
2195: WHERE tr.transaction_source(+) = ei.transaction_source
2196: AND expenditure_item_id = p_exp_item_id;
2197:

Line 2309: FROM pa_expenditure_items_all EI

2305: INTO l_old_work_type_id
2306: ,l_gl_accounted_flag
2307: ,l_proj_type_class_code
2308: ,l_old_billability
2309: FROM pa_expenditure_items_all EI
2310: ,pa_transaction_sources tr
2311: ,pa_project_types_all pt /** Bug fix 2262118 **/
2312: ,pa_projects_all pp
2313: -- ,pa_tasks t /* Bug 3457922 */

Line 2468: UPDATE pa_expenditure_items_all ei

2464: Y N - success Y
2465: Y/N N - No cdls N
2466: Solution: added decode(nvl(ei.cost_distributed_flag,'N'),'Y','Y','N')
2467: **/
2468: UPDATE pa_expenditure_items_all ei
2469: SET ei.work_type_id = p_work_type_id
2470: ,ei.cost_distributed_flag =
2471: decode(l_change_in_billable,
2472: 'Y', decode(l_gl_accounted_flag,

Line 2560: UPDATE pa_expenditure_items_all ei

2556: BEGIN
2557:
2558: FOR i IN 1..rows LOOP
2559:
2560: UPDATE pa_expenditure_items_all ei
2561: SET ei.billable_flag = X_billable
2562: , ei.revenue_distributed_flag = 'N'
2563: , ei.cost_distributed_flag = 'N'
2564: /* Begin Burdening Changes - PA.L */

Line 2627: FROM pa_expenditure_items_all ei,

2623: l_projfunc_cost_rate_date,
2624: l_projfunc_cost_rate_type,
2625: l_projfunc_cost_exchg_rate,
2626: l_work_type_id
2627: FROM pa_expenditure_items_all ei,
2628: pa_transaction_sources tr
2629: WHERE tr.transaction_source = ei.transaction_source
2630: AND expenditure_item_id = ItemsIdTab(i) ;
2631:

Line 2685: UPDATE pa_expenditure_items_all

2681: Mark ei as cost distributed
2682: */
2683: -- start 12i MOAC changes
2684: -- UPDATE pa_expenditure_items
2685: UPDATE pa_expenditure_items_all
2686: -- end 12i MOAC changes
2687: SET cost_distributed_flag = 'Y'
2688: WHERE expenditure_item_id = ItemsIdTab(i);
2689:

Line 2715: UPDATE pa_expenditure_items_all eia

2711:
2712: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
2713:
2714:
2715: UPDATE pa_expenditure_items_all eia
2716: SET
2717: eia.billable_flag = X_billable
2718: , eia.revenue_distributed_flag = 'N'
2719: , eia.cost_distributed_flag = 'N'

Line 2779: FROM pa_expenditure_items_all ei,

2775: l_projfunc_cost_rate_date,
2776: l_projfunc_cost_rate_type,
2777: l_projfunc_cost_exchg_rate,
2778: l_work_type_id
2779: FROM pa_expenditure_items_all ei,
2780: pa_transaction_sources tr
2781: WHERE tr.transaction_source = ei.transaction_source
2782: AND expenditure_item_id = AdjustsIdTab(i) ;
2783:

Line 2826: UPDATE pa_expenditure_items_all

2822: Mark ei as cost distributed
2823: */
2824: -- start 12i MOAC changes
2825: -- UPDATE pa_expenditure_items
2826: UPDATE pa_expenditure_items_all
2827: -- end 12i MOAC changes
2828: SET cost_distributed_flag = 'Y'
2829: WHERE expenditure_item_id = AdjustsIdTab(i);
2830:

Line 2928: l_transaction_source pa_expenditure_items_all.transaction_source%type;

2924: l_denom_cur_code VARCHAR2(30);
2925: l_acct_cur_code VARCHAR2(30);
2926: l_sys_link_func VARCHAR2(3);
2927: l_denom_raw_cost NUMBER := NULL;
2928: l_transaction_source pa_expenditure_items_all.transaction_source%type;
2929: l_expenditure_id pa_expenditure_items_all.expenditure_id%type;
2930: l_person_id pa_expenditures_all.incurred_by_person_id%type;
2931: l_expenditure_item_date Date;
2932:

Line 2929: l_expenditure_id pa_expenditure_items_all.expenditure_id%type;

2925: l_acct_cur_code VARCHAR2(30);
2926: l_sys_link_func VARCHAR2(3);
2927: l_denom_raw_cost NUMBER := NULL;
2928: l_transaction_source pa_expenditure_items_all.transaction_source%type;
2929: l_expenditure_id pa_expenditure_items_all.expenditure_id%type;
2930: l_person_id pa_expenditures_all.incurred_by_person_id%type;
2931: l_expenditure_item_date Date;
2932:
2933: /* Commented the following code as part of Bug#2291180 -- Start */

Line 3072: pa_expenditure_items_all

3068: l_denom_raw_cost,
3069: l_expenditure_id,
3070: l_expenditure_item_date
3071: from
3072: pa_expenditure_items_all
3073: where
3074: expenditure_item_id = X_exp_item_id;
3075:
3076: /* bug fix: 2798742 */

Line 3137: INSERT INTO pa_expenditure_items_all(

3133: IF P_DEBUG_MODE THEN
3134: print_message('get_denom_curr_code: ' || 'calling insert into EI');
3135: END IF;
3136:
3137: INSERT INTO pa_expenditure_items_all(
3138: expenditure_item_id
3139: , task_id
3140: , expenditure_type
3141: , system_linkage_function

Line 3363: pa_expenditure_items_all ei

3359: , ei.document_distribution_type
3360: /* R12 Changes - End */
3361:
3362: FROM
3363: pa_expenditure_items_all ei
3364: WHERE
3365: ei.expenditure_item_id = X_exp_item_id;
3366:
3367: IF P_DEBUG_MODE THEN

Line 3616: , pa_expenditure_items_all ei

3612: , ei.document_distribution_type
3613: /* R12 Changes - End */
3614: FROM
3615: pa_expenditures_all e
3616: , pa_expenditure_items_all ei
3617: , pa_expenditure_items_all ei2
3618: , pa_transaction_sources ts
3619: , pa_expenditure_comments ec
3620: /* R12 changes - Removed table pa_cost_distribution_lines */

Line 3617: , pa_expenditure_items_all ei2

3613: /* R12 Changes - End */
3614: FROM
3615: pa_expenditures_all e
3616: , pa_expenditure_items_all ei
3617: , pa_expenditure_items_all ei2
3618: , pa_transaction_sources ts
3619: , pa_expenditure_comments ec
3620: /* R12 changes - Removed table pa_cost_distribution_lines */
3621: WHERE

Line 4176: , pa_expenditure_items_all ei

4172: ei.expenditure_item_id
4173: , eia.expenditure_item_id adj_expenditure_item_id
4174: FROM
4175: pa_expenditures_all e
4176: , pa_expenditure_items_all ei
4177: , pa_expenditure_items_all eia
4178: WHERE
4179: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4180: AND ei.expenditure_id = e.expenditure_id

Line 4177: , pa_expenditure_items_all eia

4173: , eia.expenditure_item_id adj_expenditure_item_id
4174: FROM
4175: pa_expenditures_all e
4176: , pa_expenditure_items_all ei
4177: , pa_expenditure_items_all eia
4178: WHERE
4179: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4180: AND ei.expenditure_id = e.expenditure_id
4181: AND ei.task_id IN

Line 4350: , pa_expenditure_items_all ei

4346: ei.expenditure_item_id
4347: , eia.expenditure_item_id adj_expenditure_item_id
4348: FROM
4349: pa_expenditures_all e
4350: , pa_expenditure_items_all ei
4351: , pa_expenditure_items_all eia
4352: WHERE
4353: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4354: AND ei.expenditure_id = e.expenditure_id

Line 4351: , pa_expenditure_items_all eia

4347: , eia.expenditure_item_id adj_expenditure_item_id
4348: FROM
4349: pa_expenditures_all e
4350: , pa_expenditure_items_all ei
4351: , pa_expenditure_items_all eia
4352: WHERE
4353: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4354: AND ei.expenditure_id = e.expenditure_id
4355: AND ei.expenditure_item_id = X_expenditure_item_id

Line 4448: , pa_expenditure_items_all ei

4444: ei.expenditure_item_id
4445: , eia.expenditure_item_id adj_expenditure_item_id
4446: FROM
4447: pa_cust_rev_dist_lines r
4448: , pa_expenditure_items_all ei
4449: , pa_expenditure_items_all eia
4450: WHERE
4451: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4452: AND ei.adjusted_expenditure_item_id IS NULL

Line 4449: , pa_expenditure_items_all eia

4445: , eia.expenditure_item_id adj_expenditure_item_id
4446: FROM
4447: pa_cust_rev_dist_lines r
4448: , pa_expenditure_items_all ei
4449: , pa_expenditure_items_all eia
4450: WHERE
4451: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4452: AND ei.adjusted_expenditure_item_id IS NULL
4453: AND r.project_id = X_project_id

Line 4514: , pa_expenditure_items_all ei

4510: ei.expenditure_item_id
4511: , eia.expenditure_item_id adj_expenditure_item_id
4512: FROM
4513: pa_draft_invoice_items ii
4514: , pa_expenditure_items_all ei
4515: , pa_expenditure_items_all eia
4516: WHERE
4517: /* Bug # 3457873
4518: ei.task_id IN (

Line 4515: , pa_expenditure_items_all eia

4511: , eia.expenditure_item_id adj_expenditure_item_id
4512: FROM
4513: pa_draft_invoice_items ii
4514: , pa_expenditure_items_all ei
4515: , pa_expenditure_items_all eia
4516: WHERE
4517: /* Bug # 3457873
4518: ei.task_id IN (
4519: SELECT task_id

Line 4585: pa_expenditure_items_all ei

4581: SELECT
4582: ei.expenditure_item_id
4583: , eia.expenditure_item_id adj_expenditure_item_id
4584: FROM
4585: pa_expenditure_items_all ei
4586: , pa_expenditure_items_all eia
4587: WHERE
4588: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4589: AND ei.expenditure_item_id = X_expenditure_item_id

Line 4586: , pa_expenditure_items_all eia

4582: ei.expenditure_item_id
4583: , eia.expenditure_item_id adj_expenditure_item_id
4584: FROM
4585: pa_expenditure_items_all ei
4586: , pa_expenditure_items_all eia
4587: WHERE
4588: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4589: AND ei.expenditure_item_id = X_expenditure_item_id
4590: AND ( 1 = 2

Line 4698: FROM pa_expenditure_items_all

4694: BEGIN
4695: -- get the adjusted ei also
4696: SELECT expenditure_item_id adj
4697: INTO adj_ei
4698: FROM pa_expenditure_items_all
4699: WHERE adjusted_expenditure_item_id = X_expenditure_item_id;
4700:
4701: AdjustsIdTab(i) := adj_ei;
4702: EXCEPTION

Line 4764: FROM pa_expenditure_items_all

4760: BEGIN
4761: -- get the adjusted ei also
4762: SELECT expenditure_item_id adj
4763: INTO adj_ei
4764: FROM pa_expenditure_items_all
4765: WHERE adjusted_expenditure_item_id = X_expenditure_item_id;
4766:
4767: AdjustsIdTab(i) := adj_ei;
4768: EXCEPTION

Line 5438: l_document_payment_id PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_PAYMENT_ID%TYPE; /* Bug 5006835 */

5434: l_document_distribution_id number;
5435: l_document_type varchar2(30);
5436: l_vendor_id number;
5437: l_gl_accounted varchar2(1);
5438: l_document_payment_id PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_PAYMENT_ID%TYPE; /* Bug 5006835 */
5439: l_encoded_error_message varchar2(2000);
5440: l_error_message_name varchar2(30);
5441: l_application_short_name varchar2(30);
5442: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;

Line 5442: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;

5438: l_document_payment_id PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_PAYMENT_ID%TYPE; /* Bug 5006835 */
5439: l_encoded_error_message varchar2(2000);
5440: l_error_message_name varchar2(30);
5441: l_application_short_name varchar2(30);
5442: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;
5443: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;
5444: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5445: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5446: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;

Line 5443: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;

5439: l_encoded_error_message varchar2(2000);
5440: l_error_message_name varchar2(30);
5441: l_application_short_name varchar2(30);
5442: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;
5443: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;
5444: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5445: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5446: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5447: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;

Line 5446: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;

5442: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;
5443: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;
5444: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5445: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5446: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5447: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5448: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5449: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;
5450: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;

Line 5447: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;

5443: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;
5444: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5445: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5446: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5447: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5448: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5449: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;
5450: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
5451: l_orig_transaction_reference PA_EXPENDITURE_ITEMS_ALL.ORIG_TRANSACTION_REFERENCE%TYPE;

Line 5448: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;

5444: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5445: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5446: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5447: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5448: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5449: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;
5450: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
5451: l_orig_transaction_reference PA_EXPENDITURE_ITEMS_ALL.ORIG_TRANSACTION_REFERENCE%TYPE;
5452: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;

Line 5449: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;

5445: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5446: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5447: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5448: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5449: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;
5450: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
5451: l_orig_transaction_reference PA_EXPENDITURE_ITEMS_ALL.ORIG_TRANSACTION_REFERENCE%TYPE;
5452: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
5453: l_adjust_allowed BOOLEAN := TRUE;

Line 5450: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;

5446: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5447: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5448: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5449: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;
5450: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
5451: l_orig_transaction_reference PA_EXPENDITURE_ITEMS_ALL.ORIG_TRANSACTION_REFERENCE%TYPE;
5452: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
5453: l_adjust_allowed BOOLEAN := TRUE;
5454: l_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE; /* Bug 5436420 */

Line 5451: l_orig_transaction_reference PA_EXPENDITURE_ITEMS_ALL.ORIG_TRANSACTION_REFERENCE%TYPE;

5447: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5448: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5449: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;
5450: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
5451: l_orig_transaction_reference PA_EXPENDITURE_ITEMS_ALL.ORIG_TRANSACTION_REFERENCE%TYPE;
5452: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
5453: l_adjust_allowed BOOLEAN := TRUE;
5454: l_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE; /* Bug 5436420 */
5455: l_project_id_cache PA_PROJECTS_ALL.PROJECT_ID%TYPE := -1; /* Bug 5441891 */

Line 5518: || ' pa_expenditure_items_all ei'

5514: || ',ei.tp_amt_type_code'
5515: || ',ei.organization_id';
5516:
5517: from_clause := ' FROM'
5518: || ' pa_expenditure_items_all ei'
5519: || ',pa_expenditures_all e';
5520:
5521: where_clause := ' WHERE ei.expenditure_id = e.expenditure_id';
5522:

Line 6283: FROM pa_expenditure_items_all

6279: PRAGMA EXCEPTION_INIT(row_locked, -54);
6280: BEGIN
6281: SELECT NULL
6282: INTO l_dummy
6283: FROM pa_expenditure_items_all
6284: WHERE expenditure_item_id = v_expenditure_item_id
6285: FOR UPDATE OF expenditure_item_id NOWAIT;
6286: EXCEPTION
6287: WHEN row_locked THEN

Line 7715: pa_expenditure_items_all

7711: CURSOR GetRelatedItems IS
7712: SELECT
7713: expenditure_item_id
7714: FROM
7715: pa_expenditure_items_all
7716: WHERE
7717: source_expenditure_item_id = X_expenditure_item_id;
7718: BEGIN
7719:

Line 7722: UPDATE pa_expenditure_items_all

7718: BEGIN
7719:
7720: FOR eachRec IN GetRelatedItems LOOP
7721:
7722: UPDATE pa_expenditure_items_all
7723: SET
7724: cost_distributed_flag = 'N'
7725: , revenue_distributed_flag = 'N'
7726: , acct_rate_type = X_acct_rate_type

Line 7848: UPDATE pa_expenditure_items_all ei

7844: /* R12 Changes End */
7845:
7846: ELSE
7847:
7848: UPDATE pa_expenditure_items_all ei
7849: SET
7850: ei.cost_distributed_flag = 'N'
7851: , ei.revenue_distributed_flag = 'N'
7852: , acct_rate_type = X_acct_rate_type

Line 7976: pa_expenditure_items_all

7972: CURSOR GetRelatedItems IS
7973: SELECT
7974: expenditure_item_id
7975: FROM
7976: pa_expenditure_items_all
7977: WHERE
7978: source_expenditure_item_id = X_expenditure_item_id;
7979: BEGIN
7980: FOR eachRec IN GetRelatedItems LOOP

Line 7982: UPDATE pa_expenditure_items_all

7978: source_expenditure_item_id = X_expenditure_item_id;
7979: BEGIN
7980: FOR eachRec IN GetRelatedItems LOOP
7981:
7982: UPDATE pa_expenditure_items_all
7983: SET
7984: cost_distributed_flag = 'N'
7985: , revenue_distributed_flag = 'N'
7986: , projfunc_cost_rate_type = X_projfunc_cost_rate_type

Line 8101: UPDATE pa_expenditure_items_all ei

8097: CheckStatus(temp_status);
8098: /* R12 Changes End */
8099:
8100: ELSE
8101: UPDATE pa_expenditure_items_all ei
8102: SET
8103: ei.cost_distributed_flag = 'N'
8104: , ei.revenue_distributed_flag = 'N'
8105: , projfunc_cost_rate_type = p_projfunc_cost_rate_type

Line 8234: pa_expenditure_items_all

8230: CURSOR GetRelatedItems IS
8231: SELECT
8232: expenditure_item_id
8233: FROM
8234: pa_expenditure_items_all
8235: WHERE
8236: source_expenditure_item_id = X_expenditure_item_id;
8237: BEGIN
8238:

Line 8241: UPDATE pa_expenditure_items_all

8237: BEGIN
8238:
8239: FOR eachRec IN GetRelatedItems LOOP
8240:
8241: UPDATE pa_expenditure_items_all
8242: SET
8243: cost_distributed_flag = 'N'
8244: , revenue_distributed_flag = 'N'
8245: , project_rate_type = X_project_rate_type

Line 8335: UPDATE pa_expenditure_items_all ei

8331: CheckStatus(temp_status);
8332: /* R12 Changes End */
8333: ELSE
8334:
8335: UPDATE pa_expenditure_items_all ei
8336: SET
8337: ei.cost_distributed_flag = 'N'
8338: , ei.revenue_distributed_flag = 'N'
8339: , project_rate_type = X_project_rate_type

Line 8454: pa_expenditure_items_all

8450: CURSOR GetRelatedItems IS
8451: SELECT
8452: expenditure_item_id
8453: FROM
8454: pa_expenditure_items_all
8455: WHERE
8456: source_expenditure_item_id = X_expenditure_item_id;
8457: BEGIN
8458:

Line 8461: UPDATE pa_expenditure_items_all

8457: BEGIN
8458:
8459: FOR eachRec IN GetRelatedItems LOOP
8460:
8461: UPDATE pa_expenditure_items_all
8462: SET
8463: cc_cross_charge_code =DECODE(X_adjust_level,'I', X_cc_code, l_cc_code)
8464: , cc_cross_charge_type = DECODE(X_adjust_level,'I',X_cc_type, l_cc_type)
8465: , cc_bl_distributed_code = DECODE(X_adjust_level,'I',X_bl_dist_code, l_bl_dist_code)

Line 8635: UPDATE pa_expenditure_items_all

8631: ']X_ic_proc_code['||X_ic_proc_code||']X_prvdr_orgnzn_id['||X_prvdr_orgnzn_id||
8632: ']X_recvr_orgnzn_id['||X_recvr_orgnzn_id||']l_PrvdrOrganizationId['||l_PrvdrOrganizationId||
8633: ']l_RecvrOrganizationId['||l_RecvrOrganizationId||']');
8634:
8635: UPDATE pa_expenditure_items_all
8636: SET
8637: cc_cross_charge_code =DECODE(X_adjust_level,'I', X_cc_code, l_cc_code)
8638: , cc_cross_charge_type = DECODE(X_adjust_level,'I',X_cc_type, l_cc_type)
8639: , cc_bl_distributed_code = DECODE(X_adjust_level,'I',X_bl_dist_code, l_bl_dist_code)

Line 8732: pa_expenditure_items_all

8728: CURSOR GetRelatedItems IS
8729: SELECT
8730: expenditure_item_id
8731: FROM
8732: pa_expenditure_items_all
8733: WHERE
8734: source_expenditure_item_id = X_expenditure_item_id;
8735: BEGIN
8736: --print_message('in related ei');

Line 8739: UPDATE pa_expenditure_items_all

8735: BEGIN
8736: --print_message('in related ei');
8737: FOR eachRec IN GetRelatedItems LOOP
8738: --print_message('in related ei loop');
8739: UPDATE pa_expenditure_items_all
8740: SET
8741: cc_cross_charge_code = 'N'
8742: , cc_bl_distributed_code = DECODE(X_adjust_level,'I',X_bl_dist_code, l_bl_dist_code)
8743: , cc_ic_processed_code = DECODE(X_adjust_level,'I',X_ic_proc_code, l_ic_proc_code)

Line 8815: UPDATE pa_expenditure_items_all

8811: end if;
8812: END IF;
8813:
8814:
8815: UPDATE pa_expenditure_items_all
8816: SET
8817: cc_cross_charge_code = 'N'
8818: , cc_bl_distributed_code = DECODE(X_adjust_level,'I',X_bl_dist_code, l_bl_dist_code)
8819: , cc_ic_processed_code = DECODE(X_adjust_level,'I',X_ic_proc_code, l_ic_proc_code)

Line 8936: pa_expenditure_items_all

8932: CURSOR GetRelatedItems IS
8933: SELECT
8934: expenditure_item_id
8935: FROM
8936: pa_expenditure_items_all
8937: WHERE
8938: source_expenditure_item_id = X_expenditure_item_id;
8939: BEGIN
8940:

Line 8943: UPDATE pa_expenditure_items_all

8939: BEGIN
8940:
8941: FOR eachRec IN GetRelatedItems LOOP
8942:
8943: UPDATE pa_expenditure_items_all
8944:
8945: SET
8946: cc_bl_distributed_code = DECODE(X_adjust_level,'I',X_bl_dist_code, l_bl_dist_code)
8947: , cc_ic_processed_code = DECODE(X_adjust_level,'I',X_ic_proc_code, l_ic_proc_code)

Line 9045: UPDATE pa_expenditure_items_all ei

9041: CheckStatus(temp_status);
9042: /* R12 Changes End */
9043: ELSE
9044:
9045: UPDATE pa_expenditure_items_all ei
9046: SET
9047: cc_bl_distributed_code = DECODE(X_adjust_level, 'I', X_bl_dist_code, l_bl_dist_code)
9048: , cc_ic_processed_code = DECODE(X_adjust_level, 'I',X_ic_proc_code, l_ic_proc_code)
9049: , acct_tp_rate_type = X_acct_tp_rate_type

Line 9148: net_zero_adjustment_flag_1 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

9144:
9145: IS
9146:
9147: TYPE net_zero_ei_date_rec_type IS RECORD (
9148: net_zero_adjustment_flag_1 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9149: expenditure_item_date_1 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9150: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9151: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9152: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

Line 9149: expenditure_item_date_1 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

9145: IS
9146:
9147: TYPE net_zero_ei_date_rec_type IS RECORD (
9148: net_zero_adjustment_flag_1 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9149: expenditure_item_date_1 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9150: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9151: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9152: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9153: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

Line 9150: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

9146:
9147: TYPE net_zero_ei_date_rec_type IS RECORD (
9148: net_zero_adjustment_flag_1 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9149: expenditure_item_date_1 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9150: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9151: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9152: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9153: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9154: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

Line 9151: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

9147: TYPE net_zero_ei_date_rec_type IS RECORD (
9148: net_zero_adjustment_flag_1 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9149: expenditure_item_date_1 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9150: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9151: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9152: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9153: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9154: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9155: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

Line 9152: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

9148: net_zero_adjustment_flag_1 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9149: expenditure_item_date_1 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9150: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9151: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9152: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9153: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9154: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9155: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9156: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

Line 9153: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

9149: expenditure_item_date_1 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9150: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9151: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9152: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9153: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9154: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9155: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9156: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9157: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

Line 9154: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

9150: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9151: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9152: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9153: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9154: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9155: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9156: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9157: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9158: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

Line 9155: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

9151: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9152: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9153: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9154: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9155: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9156: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9157: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9158: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9159: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

Line 9156: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

9152: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9153: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9154: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9155: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9156: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9157: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9158: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9159: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9160: net_zero_adjustment_flag_7 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

Line 9157: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

9153: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9154: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9155: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9156: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9157: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9158: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9159: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9160: net_zero_adjustment_flag_7 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9161: expenditure_item_date_7 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL);

Line 9158: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

9154: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9155: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9156: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9157: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9158: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9159: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9160: net_zero_adjustment_flag_7 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9161: expenditure_item_date_7 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL);
9162:

Line 9159: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

9155: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9156: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9157: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9158: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9159: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9160: net_zero_adjustment_flag_7 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9161: expenditure_item_date_7 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL);
9162:
9163: l_net_zero_ei_date net_zero_ei_date_rec_type;

Line 9160: net_zero_adjustment_flag_7 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

9156: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9157: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9158: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9159: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9160: net_zero_adjustment_flag_7 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9161: expenditure_item_date_7 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL);
9162:
9163: l_net_zero_ei_date net_zero_ei_date_rec_type;
9164: l_allow_adjustment_flag VARCHAR2(1);

Line 9161: expenditure_item_date_7 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL);

9157: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9158: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9159: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9160: net_zero_adjustment_flag_7 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9161: expenditure_item_date_7 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL);
9162:
9163: l_net_zero_ei_date net_zero_ei_date_rec_type;
9164: l_allow_adjustment_flag VARCHAR2(1);
9165: l_predefined_flag VARCHAR2(1);

Line 9366: l_return_currency_code pa_expenditure_items_all.denom_currency_code%type;

9362: , p_person_id IN NUMBER default NULL /*Bugfix:2798742 */
9363: , p_ei_date IN DATE default NULL /*Bugfix:2798742 */
9364: ) RETURN VARCHAR2 IS
9365:
9366: l_return_currency_code pa_expenditure_items_all.denom_currency_code%type;
9367: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;
9368: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */
9369: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;
9370: l_job_id pa_expenditure_items_all.job_id%TYPE;

Line 9370: l_job_id pa_expenditure_items_all.job_id%TYPE;

9366: l_return_currency_code pa_expenditure_items_all.denom_currency_code%type;
9367: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;
9368: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */
9369: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;
9370: l_job_id pa_expenditure_items_all.job_id%TYPE;
9371: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
9372: l_cost_rate pa_bill_rates_all.rate%TYPE;
9373: l_start_date Date;
9374: l_end_date Date;

Line 9378: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;

9374: l_end_date Date;
9375: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
9376: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
9377: l_rate_sch_id pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE;
9378: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
9379: l_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
9380: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
9381: l_ot_project_id pa_projects_all.project_id%TYPE;
9382: l_ot_task_id pa_tasks.task_id%TYPE;

Line 9901: l_historical_flag PA_EXPENDITURE_ITEMS_ALL.HISTORICAL_FLAG%TYPE := 'N'; /* Bug 5551933 */

9897: l_billable_flag VARCHAR2(1);
9898: l_return BOOLEAN := TRUE;
9899: l_pooled_flag VARCHAR(1); /* Bug 5006835 */
9900: l_encoded_error_message VARCHAR2(2000); /* Bug 4997739 */
9901: l_historical_flag PA_EXPENDITURE_ITEMS_ALL.HISTORICAL_FLAG%TYPE := 'N'; /* Bug 5551933 */
9902:
9903: CURSOR c_get_ap_offset_method IS
9904: SELECT LIABILITY_POST_LOOKUP_CODE
9905: FROM AP_SYSTEM_PARAMETERS;

Line 10706: FUNCTION is_orphaned_src_sys_reversal( p_document_distribution_id IN PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_ID%TYPE

10702: END is_recoverability_affected;
10703: /* R12 Changes End */
10704:
10705: /* Bug 4901129 - Start */
10706: FUNCTION is_orphaned_src_sys_reversal( p_document_distribution_id IN PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_ID%TYPE
10707: , p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE%TYPE)
10708: RETURN VARCHAR2 IS
10709: l_result VARCHAR2(1) := 'N';
10710:

Line 10707: , p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE%TYPE)

10703: /* R12 Changes End */
10704:
10705: /* Bug 4901129 - Start */
10706: FUNCTION is_orphaned_src_sys_reversal( p_document_distribution_id IN PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_ID%TYPE
10707: , p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE%TYPE)
10708: RETURN VARCHAR2 IS
10709: l_result VARCHAR2(1) := 'N';
10710:
10711: CURSOR c_get_count IS

Line 10713: FROM pa_expenditure_items_all ei /* Bug 5561597 */

10709: l_result VARCHAR2(1) := 'N';
10710:
10711: CURSOR c_get_count IS
10712: SELECT DECODE(count(*),0,'N','Y')
10713: FROM pa_expenditure_items_all ei /* Bug 5561597 */
10714: WHERE ( ei.document_header_id, ei.document_distribution_id) IN
10715: ( SELECT apdist2.invoice_id, apdist2.invoice_distribution_id /* Bug 5561597 */
10716: FROM ap_invoice_distributions_all apdist1, /* Bug 5561597 */
10717: ap_invoice_distributions_all apdist2 /* Bug 5561597 */

Line 10750: FUNCTION RepCurrOrSecLedgerDiffCurr(p_org_id PA_EXPENDITURE_ITEMS_ALL.ORG_ID%TYPE)

10746: END is_orphaned_src_sys_reversal;
10747: /* Bug 4901129 - End */
10748:
10749: /* Bug 5235354 - Start */
10750: FUNCTION RepCurrOrSecLedgerDiffCurr(p_org_id PA_EXPENDITURE_ITEMS_ALL.ORG_ID%TYPE)
10751: RETURN BOOLEAN IS
10752:
10753: l_count NUMBER := -1;
10754: l_return BOOLEAN := FALSE;