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 431: UPDATE pa_expenditure_items_all ei

427: , X_login IN NUMBER
428: , X_status OUT NOCOPY NUMBER )
429: IS
430: BEGIN
431: UPDATE pa_expenditure_items_all ei
432: SET
433: ei.net_zero_adjustment_flag = 'Y'
434: , ei.last_update_date = sysdate
435: , ei.last_updated_by = X_user

Line 477: INSERT INTO pa_expenditure_items_all(

473: G_PROG_APPL_ID := FND_GLOBAL.PROG_APPL_ID;
474: END IF;
475: /*End of 12.2 Payroll Integration changes*/
476:
477: INSERT INTO pa_expenditure_items_all(
478: expenditure_item_id
479: , task_id
480: , expenditure_type
481: , system_linkage_function

Line 743: pa_expenditure_items_all ei

739: ,G_PROGRAM_ID
740: ,G_PROG_APPL_ID
741: ,ei.cbs_element_id -- Added as part of Bug 16220146
742: FROM
743: pa_expenditure_items_all ei
744: WHERE
745: ei.expenditure_item_id = X_exp_item_id;
746:
747: /* Fix for Bug 3684711 */

Line 925: pa_expenditure_items_all ei

921: CURSOR GetRelatedItems IS
922: SELECT
923: ei.expenditure_item_id
924: FROM
925: pa_expenditure_items_all ei
926: WHERE
927: ei.source_expenditure_item_id = X_source_exp_item_id
928: AND nvl(ei.net_zero_adjustment_flag, 'N') <> 'Y';
929:

Line 991: Update pa_expenditure_items_all ei

987: -- in the sub-query.
988: --------------------------------------------------------------------------------
989:
990:
991: Update pa_expenditure_items_all ei
992: set ei.source_expenditure_item_id =
993: (select ei1.expenditure_item_id
994: from pa_expenditure_items_all ei1
995: where ei1.adjusted_expenditure_item_id =

Line 994: from pa_expenditure_items_all ei1

990:
991: Update pa_expenditure_items_all ei
992: set ei.source_expenditure_item_id =
993: (select ei1.expenditure_item_id
994: from pa_expenditure_items_all ei1
995: where ei1.adjusted_expenditure_item_id =
996: X_source_exp_item_id)
997: where ei.adjusted_expenditure_item_id = eachRec.expenditure_item_id;
998:

Line 1039: pa_expenditure_items_all

1035: CURSOR GetRelatedItems IS
1036: SELECT
1037: expenditure_item_id
1038: FROM
1039: pa_expenditure_items_all
1040: WHERE
1041: source_expenditure_item_id = X_expenditure_item_id;
1042: BEGIN
1043:

Line 1046: UPDATE pa_expenditure_items_all

1042: BEGIN
1043:
1044: FOR eachRec IN GetRelatedItems LOOP
1045:
1046: UPDATE pa_expenditure_items_all
1047: SET
1048: revenue_distributed_flag = 'N'
1049: , rev_dist_rejection_code = NULL /*Added for bug 9367103*/
1050: , last_updated_by = X_user

Line 1099: UPDATE pa_expenditure_items_all ei

1095: temp_status NUMBER DEFAULT NULL;
1096: BEGIN
1097: FOR i IN 1..rows LOOP
1098:
1099: UPDATE pa_expenditure_items_all ei
1100: SET
1101: ei.revenue_distributed_flag = 'N'
1102: , ei.rev_dist_rejection_code = NULL /*Added for bug 9367103*/
1103: , ei.last_update_date = sysdate

Line 1125: UPDATE pa_expenditure_items_all eia

1121: CheckStatus( temp_status );
1122:
1123: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
1124:
1125: UPDATE pa_expenditure_items_all eia
1126: SET
1127: eia.revenue_distributed_flag = 'N'
1128: , eia.rev_dist_rejection_code = NULL /*Added for bug 9367103*/
1129: , eia.last_update_date = sysdate

Line 1202: pa_expenditure_items_all

1198: CURSOR GetRelatedItems IS
1199: SELECT
1200: expenditure_item_id
1201: FROM
1202: pa_expenditure_items_all
1203: WHERE
1204: source_expenditure_item_id = X_expenditure_item_id;
1205:
1206: l_transaction_source VARCHAR2(30); --Bug 12816655

Line 1211: INTO l_transaction_source FROM pa_expenditure_items_all

1207:
1208: BEGIN
1209:
1210: SELECT NVL(transaction_source, NULL)
1211: INTO l_transaction_source FROM pa_expenditure_items_all
1212: WHERE expenditure_item_id = X_expenditure_item_id; --Bug 12816655
1213:
1214: FOR eachRec IN GetRelatedItems LOOP
1215:

Line 1216: UPDATE pa_expenditure_items_all ei

1212: WHERE expenditure_item_id = X_expenditure_item_id; --Bug 12816655
1213:
1214: FOR eachRec IN GetRelatedItems LOOP
1215:
1216: UPDATE pa_expenditure_items_all ei
1217: SET
1218: cost_distributed_flag = 'N'
1219: , revenue_distributed_flag = 'N'
1220: , rev_dist_rejection_code = NULL /*Added for bug 9367103*/

Line 1284: pa_expenditure_items_all ei

1280: , trx_source_accounted
1281: , trx_source_burden
1282: , system_linkage
1283: FROM
1284: pa_expenditure_items_all ei
1285: , pa_transaction_sources txs
1286: WHERE
1287: ei.transaction_source = txs.transaction_source(+)
1288: AND ei.expenditure_item_id = ItemsIdTab(i);

Line 1294: UPDATE pa_expenditure_items_all ei

1290: /* R12 Changes - Added system linkage ER in addition to VI. In R12, users
1291: cannot create Expense Reports in Projects. The following change
1292: will prohibit the user from recalculating cost for historical
1293: Expense Reports created in Projects */
1294: UPDATE pa_expenditure_items_all ei
1295: SET
1296: ei.cost_distributed_flag = 'N'
1297: /* Reverted: Added for bug #2027985
1298: decode( system_linkage, 'VI', ei.cost_distributed_flag,

Line 1354: UPDATE pa_expenditure_items_all ei

1350: CheckStatus( temp_status );
1351:
1352: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
1353:
1354: UPDATE pa_expenditure_items_all ei
1355: SET
1356: ei.cost_distributed_flag = 'N'
1357: /* Reverted : Added for bug #2027985
1358: decode( system_linkage, 'VI', ei.cost_distributed_flag,

Line 1456: pa_expenditure_items_all ei

1452: INTO
1453: trx_source_burden,
1454: system_linkage
1455: FROM
1456: pa_expenditure_items_all ei
1457: , pa_transaction_sources txs
1458: WHERE
1459: ei.transaction_source = txs.transaction_source(+)
1460: AND ei.expenditure_item_id = ItemsIdTab(i);

Line 1465: UPDATE pa_expenditure_items_all ei

1461:
1462: -- Added the Decode function for the acct_burdened_cost,burden_cost_rate,burden_cost
1463: -- to fix the bug fix : 1490316
1464:
1465: UPDATE pa_expenditure_items_all ei
1466: SET
1467: ei.cost_distributed_flag = 'N'
1468: , ei.denom_burdened_cost =
1469: decode( trx_source_burden, 'N',

Line 1509: UPDATE pa_expenditure_items_all eia

1505: CheckStatus( temp_status );
1506:
1507: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
1508:
1509: UPDATE pa_expenditure_items_all eia
1510: SET
1511: eia.cost_distributed_flag = 'N'
1512: , eia.denom_burdened_cost =
1513: decode( trx_source_burden, 'N', NULL, eia.denom_burdened_cost )

Line 1586: pa_expenditure_items_all

1582: CURSOR GetRelatedItems IS
1583: SELECT
1584: expenditure_item_id
1585: FROM
1586: pa_expenditure_items_all
1587: WHERE
1588: source_expenditure_item_id = X_expenditure_item_id;
1589:
1590: l_transaction_source VARCHAR2(30); --Bug 12816655

Line 1595: INTO l_transaction_source FROM pa_expenditure_items_all

1591:
1592: BEGIN
1593:
1594: SELECT NVL(transaction_source, NULL)
1595: INTO l_transaction_source FROM pa_expenditure_items_all
1596: WHERE expenditure_item_id = X_expenditure_item_id; --Bug 12816655
1597:
1598: FOR eachRec IN GetRelatedItems LOOP
1599:

Line 1600: UPDATE pa_expenditure_items_all ei

1596: WHERE expenditure_item_id = X_expenditure_item_id; --Bug 12816655
1597:
1598: FOR eachRec IN GetRelatedItems LOOP
1599:
1600: UPDATE pa_expenditure_items_all ei
1601: SET
1602: cost_distributed_flag = 'N'
1603: , revenue_distributed_flag = 'N'
1604: , rev_dist_rejection_code = NULL /*Added for bug 9304451*/

Line 1669: pa_expenditure_items_all ei

1665: , trx_source_accounted
1666: , trx_source_burden
1667: , system_linkage
1668: FROM
1669: pa_expenditure_items_all ei
1670: , pa_transaction_sources txs
1671: WHERE
1672: ei.transaction_source = txs.transaction_source(+)
1673: AND ei.expenditure_item_id = ItemsIdTab(i);

Line 1679: UPDATE pa_expenditure_items_all ei

1675: /* R12 Changes - Added system linkage ER in addition to VI. In R12, users
1676: cannot create Expense Reports in Projects. The following change
1677: will prohibit the user from recalculating cost for historical
1678: Expense Reports created in Projects */
1679: UPDATE pa_expenditure_items_all ei
1680: SET
1681: ei.cost_distributed_flag = 'N'
1682: /* Reverted: Added for bug #2027985
1683: decode( system_linkage, 'VI', ei.cost_distributed_flag,

Line 1740: UPDATE pa_expenditure_items_all ei

1736: CheckStatus( temp_status );
1737:
1738: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
1739:
1740: UPDATE pa_expenditure_items_all ei
1741: SET
1742: ei.cost_distributed_flag ='N'
1743: /* Reverted: Added for bug #2027985
1744: decode( system_linkage, 'VI', ei.cost_distributed_flag,

Line 1846: pa_expenditure_items_all ei

1842: INTO
1843: trx_source_burden,
1844: system_linkage
1845: FROM
1846: pa_expenditure_items_all ei
1847: , pa_transaction_sources txs
1848: WHERE
1849: ei.transaction_source = txs.transaction_source(+)
1850: AND ei.expenditure_item_id = ItemsIdTab(i);

Line 1856: UPDATE pa_expenditure_items_all ei

1852: --- Added the decode function for the following columns acct_burdened_cost,burden_cost_rate,
1853: --- burden_cost as a bug fix : 1490316, it enables to recalc BTC ei only for the accounting
1854: --- purpose.
1855:
1856: UPDATE pa_expenditure_items_all ei
1857: SET
1858: ei.cost_distributed_flag = 'N'
1859: , ei.revenue_distributed_flag = 'N'
1860: , ei.rev_dist_rejection_code = NULL /*Added for bug:9367103 */

Line 1902: UPDATE pa_expenditure_items_all eia

1898: CheckStatus( temp_status );
1899:
1900: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
1901:
1902: UPDATE pa_expenditure_items_all eia
1903: SET
1904: eia.cost_distributed_flag = 'N'
1905: , eia.denom_burdened_cost =
1906: decode( trx_source_burden, 'N', NULL, eia.denom_burdened_cost )

Line 1957: from pa_expenditure_items_all peia

1953:
1954: CURSOR c2 is
1955:
1956: select expenditure_item_id
1957: from pa_expenditure_items_all peia
1958: where exists( select null
1959: from pa_cost_distribution_lines_all cdl
1960: where cdl.expenditure_item_id = peia.expenditure_item_id)
1961: start with expenditure_item_id = X_expenditure_item_id

Line 2065: UPDATE pa_expenditure_items_all ei

2061: BEGIN
2062:
2063: FOR i IN 1..rows LOOP
2064:
2065: UPDATE pa_expenditure_items_all ei
2066: SET
2067: ei.bill_hold_flag = X_hold
2068: , ei.last_updated_by = X_user
2069: , ei.last_update_date = sysdate

Line 2090: UPDATE pa_expenditure_items_all eia

2086: CheckStatus( temp_status );
2087:
2088: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
2089:
2090: UPDATE pa_expenditure_items_all eia
2091: SET
2092: eia.bill_hold_flag = X_hold
2093: , eia.last_updated_by = X_user
2094: , eia.last_update_date = sysdate

Line 2249: FROM pa_expenditure_items_all ei,

2245: l_projfunc_cost_rate_date,
2246: l_projfunc_cost_rate_type,
2247: l_projfunc_cost_exchg_rate,
2248: l_work_type_id
2249: FROM pa_expenditure_items_all ei,
2250: pa_transaction_sources tr
2251: WHERE tr.transaction_source(+) = ei.transaction_source
2252: AND expenditure_item_id = p_exp_item_id;
2253:

Line 2365: FROM pa_expenditure_items_all EI

2361: INTO l_old_work_type_id
2362: ,l_gl_accounted_flag
2363: ,l_proj_type_class_code
2364: ,l_old_billability
2365: FROM pa_expenditure_items_all EI
2366: ,pa_transaction_sources tr
2367: ,pa_project_types_all pt /** Bug fix 2262118 **/
2368: ,pa_projects_all pp
2369: -- ,pa_tasks t /* Bug 3457922 */

Line 2524: UPDATE pa_expenditure_items_all ei

2520: Y N - success Y
2521: Y/N N - No cdls N
2522: Solution: added decode(nvl(ei.cost_distributed_flag,'N'),'Y','Y','N')
2523: **/
2524: UPDATE pa_expenditure_items_all ei
2525: SET ei.work_type_id = p_work_type_id
2526: ,ei.cost_distributed_flag =
2527: decode(l_change_in_billable,
2528: 'Y', decode(l_gl_accounted_flag,

Line 2617: UPDATE pa_expenditure_items_all ei

2613: BEGIN
2614:
2615: FOR i IN 1..rows LOOP
2616:
2617: UPDATE pa_expenditure_items_all ei
2618: SET ei.billable_flag = X_billable
2619: , ei.revenue_distributed_flag = 'N'
2620: , ei.rev_dist_rejection_code = NULL /*Added for bug 9304451*/
2621: , ei.cost_distributed_flag = 'N'

Line 2685: FROM pa_expenditure_items_all ei,

2681: l_projfunc_cost_rate_date,
2682: l_projfunc_cost_rate_type,
2683: l_projfunc_cost_exchg_rate,
2684: l_work_type_id
2685: FROM pa_expenditure_items_all ei,
2686: pa_transaction_sources tr
2687: WHERE tr.transaction_source = ei.transaction_source
2688: AND expenditure_item_id = ItemsIdTab(i) ;
2689:

Line 2743: UPDATE pa_expenditure_items_all

2739: Mark ei as cost distributed
2740: */
2741: -- start 12i MOAC changes
2742: -- UPDATE pa_expenditure_items
2743: UPDATE pa_expenditure_items_all
2744: -- end 12i MOAC changes
2745: SET cost_distributed_flag = 'Y'
2746: WHERE expenditure_item_id = ItemsIdTab(i);
2747:

Line 2773: UPDATE pa_expenditure_items_all eia

2769:
2770: IF ( AdjustsIdTab(i) IS NOT NULL ) THEN
2771:
2772:
2773: UPDATE pa_expenditure_items_all eia
2774: SET
2775: eia.billable_flag = X_billable
2776: , eia.revenue_distributed_flag = 'N'
2777: , eia.rev_dist_rejection_code = NULL /*Added for bug:9367103 */

Line 2838: FROM pa_expenditure_items_all ei,

2834: l_projfunc_cost_rate_date,
2835: l_projfunc_cost_rate_type,
2836: l_projfunc_cost_exchg_rate,
2837: l_work_type_id
2838: FROM pa_expenditure_items_all ei,
2839: pa_transaction_sources tr
2840: WHERE tr.transaction_source = ei.transaction_source
2841: AND expenditure_item_id = AdjustsIdTab(i) ;
2842:

Line 2885: UPDATE pa_expenditure_items_all

2881: Mark ei as cost distributed
2882: */
2883: -- start 12i MOAC changes
2884: -- UPDATE pa_expenditure_items
2885: UPDATE pa_expenditure_items_all
2886: -- end 12i MOAC changes
2887: SET cost_distributed_flag = 'Y'
2888: WHERE expenditure_item_id = AdjustsIdTab(i);
2889:

Line 2987: l_transaction_source pa_expenditure_items_all.transaction_source%type;

2983: l_denom_cur_code VARCHAR2(30);
2984: l_acct_cur_code VARCHAR2(30);
2985: l_sys_link_func VARCHAR2(3);
2986: l_denom_raw_cost NUMBER := NULL;
2987: l_transaction_source pa_expenditure_items_all.transaction_source%type;
2988: l_expenditure_id pa_expenditure_items_all.expenditure_id%type;
2989: l_person_id pa_expenditures_all.incurred_by_person_id%type;
2990: l_expenditure_item_date Date;
2991:

Line 2988: l_expenditure_id pa_expenditure_items_all.expenditure_id%type;

2984: l_acct_cur_code VARCHAR2(30);
2985: l_sys_link_func VARCHAR2(3);
2986: l_denom_raw_cost NUMBER := NULL;
2987: l_transaction_source pa_expenditure_items_all.transaction_source%type;
2988: l_expenditure_id pa_expenditure_items_all.expenditure_id%type;
2989: l_person_id pa_expenditures_all.incurred_by_person_id%type;
2990: l_expenditure_item_date Date;
2991:
2992: /* Commented the following code as part of Bug#2291180 -- Start */

Line 3131: pa_expenditure_items_all

3127: l_denom_raw_cost,
3128: l_expenditure_id,
3129: l_expenditure_item_date
3130: from
3131: pa_expenditure_items_all
3132: where
3133: expenditure_item_id = X_exp_item_id;
3134:
3135: /* bug fix: 2798742 */

Line 3196: INSERT INTO pa_expenditure_items_all(

3192: IF P_DEBUG_MODE THEN
3193: print_message('get_denom_curr_code: ' || 'calling insert into EI');
3194: END IF;
3195:
3196: INSERT INTO pa_expenditure_items_all(
3197: expenditure_item_id
3198: , task_id
3199: , expenditure_type
3200: , system_linkage_function

Line 3443: pa_expenditure_items_all ei

3439: , ei.interface_run_id -- bug 12541898
3440: /* 12.2 changes for payroll intg .. end */
3441: , ei.cbs_element_id -- Added for CBS Enhancement Bug 16220146
3442: FROM
3443: pa_expenditure_items_all ei
3444: WHERE
3445: ei.expenditure_item_id = X_exp_item_id;
3446:
3447: IF P_DEBUG_MODE THEN

Line 3710: , pa_expenditure_items_all ei

3706: , ei.payroll_accrual_flag -- bug 12541898
3707: , ei.interface_run_id -- bug 12541898
3708: FROM
3709: pa_expenditures_all e
3710: , pa_expenditure_items_all ei
3711: , pa_expenditure_items_all ei2
3712: , pa_transaction_sources ts
3713: , pa_expenditure_comments ec
3714: /* R12 changes - Removed table pa_cost_distribution_lines */

Line 3711: , pa_expenditure_items_all ei2

3707: , ei.interface_run_id -- bug 12541898
3708: FROM
3709: pa_expenditures_all e
3710: , pa_expenditure_items_all ei
3711: , pa_expenditure_items_all ei2
3712: , pa_transaction_sources ts
3713: , pa_expenditure_comments ec
3714: /* R12 changes - Removed table pa_cost_distribution_lines */
3715: WHERE

Line 4286: , pa_expenditure_items_all ei

4282: ei.expenditure_item_id
4283: , eia.expenditure_item_id adj_expenditure_item_id
4284: FROM
4285: pa_expenditures_all e
4286: , pa_expenditure_items_all ei
4287: , pa_expenditure_items_all eia
4288: WHERE
4289: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4290: AND ei.expenditure_id = e.expenditure_id

Line 4287: , pa_expenditure_items_all eia

4283: , eia.expenditure_item_id adj_expenditure_item_id
4284: FROM
4285: pa_expenditures_all e
4286: , pa_expenditure_items_all ei
4287: , pa_expenditure_items_all eia
4288: WHERE
4289: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4290: AND ei.expenditure_id = e.expenditure_id
4291: AND ei.task_id IN

Line 4460: , pa_expenditure_items_all ei

4456: ei.expenditure_item_id
4457: , eia.expenditure_item_id adj_expenditure_item_id
4458: FROM
4459: pa_expenditures_all e
4460: , pa_expenditure_items_all ei
4461: , pa_expenditure_items_all eia
4462: WHERE
4463: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4464: AND ei.expenditure_id = e.expenditure_id

Line 4461: , pa_expenditure_items_all eia

4457: , eia.expenditure_item_id adj_expenditure_item_id
4458: FROM
4459: pa_expenditures_all e
4460: , pa_expenditure_items_all ei
4461: , pa_expenditure_items_all eia
4462: WHERE
4463: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4464: AND ei.expenditure_id = e.expenditure_id
4465: AND ei.expenditure_item_id = X_expenditure_item_id

Line 4558: , pa_expenditure_items_all ei

4554: ei.expenditure_item_id
4555: , eia.expenditure_item_id adj_expenditure_item_id
4556: FROM
4557: pa_cust_rev_dist_lines r
4558: , pa_expenditure_items_all ei
4559: , pa_expenditure_items_all eia
4560: WHERE
4561: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4562: AND ei.adjusted_expenditure_item_id IS NULL

Line 4559: , pa_expenditure_items_all eia

4555: , eia.expenditure_item_id adj_expenditure_item_id
4556: FROM
4557: pa_cust_rev_dist_lines r
4558: , pa_expenditure_items_all ei
4559: , pa_expenditure_items_all eia
4560: WHERE
4561: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4562: AND ei.adjusted_expenditure_item_id IS NULL
4563: AND r.project_id = X_project_id

Line 4624: , pa_expenditure_items_all ei

4620: ei.expenditure_item_id
4621: , eia.expenditure_item_id adj_expenditure_item_id
4622: FROM
4623: pa_draft_invoice_items ii
4624: , pa_expenditure_items_all ei
4625: , pa_expenditure_items_all eia
4626: WHERE
4627: /* Bug # 3457873
4628: ei.task_id IN (

Line 4625: , pa_expenditure_items_all eia

4621: , eia.expenditure_item_id adj_expenditure_item_id
4622: FROM
4623: pa_draft_invoice_items ii
4624: , pa_expenditure_items_all ei
4625: , pa_expenditure_items_all eia
4626: WHERE
4627: /* Bug # 3457873
4628: ei.task_id IN (
4629: SELECT task_id

Line 4695: pa_expenditure_items_all ei

4691: SELECT
4692: ei.expenditure_item_id
4693: , eia.expenditure_item_id adj_expenditure_item_id
4694: FROM
4695: pa_expenditure_items_all ei
4696: , pa_expenditure_items_all eia
4697: WHERE
4698: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4699: AND ei.expenditure_item_id = X_expenditure_item_id

Line 4696: , pa_expenditure_items_all eia

4692: ei.expenditure_item_id
4693: , eia.expenditure_item_id adj_expenditure_item_id
4694: FROM
4695: pa_expenditure_items_all ei
4696: , pa_expenditure_items_all eia
4697: WHERE
4698: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
4699: AND ei.expenditure_item_id = X_expenditure_item_id
4700: AND ( 1 = 2

Line 4808: FROM pa_expenditure_items_all

4804: BEGIN
4805: -- get the adjusted ei also
4806: SELECT expenditure_item_id adj
4807: INTO adj_ei
4808: FROM pa_expenditure_items_all
4809: WHERE adjusted_expenditure_item_id = X_expenditure_item_id;
4810:
4811: AdjustsIdTab(i) := adj_ei;
4812: EXCEPTION

Line 4874: FROM pa_expenditure_items_all

4870: BEGIN
4871: -- get the adjusted ei also
4872: SELECT expenditure_item_id adj
4873: INTO adj_ei
4874: FROM pa_expenditure_items_all
4875: WHERE adjusted_expenditure_item_id = X_expenditure_item_id;
4876:
4877: AdjustsIdTab(i) := adj_ei;
4878: EXCEPTION

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

5548: l_document_distribution_id number;
5549: l_document_type varchar2(30);
5550: l_vendor_id number;
5551: l_gl_accounted varchar2(1);
5552: l_document_payment_id PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_PAYMENT_ID%TYPE; /* Bug 5006835 */
5553: l_encoded_error_message varchar2(2000);
5554: l_error_message_name varchar2(30);
5555: l_application_short_name varchar2(30);
5556: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;

Line 5556: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;

5552: l_document_payment_id PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_PAYMENT_ID%TYPE; /* Bug 5006835 */
5553: l_encoded_error_message varchar2(2000);
5554: l_error_message_name varchar2(30);
5555: l_application_short_name varchar2(30);
5556: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;
5557: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;
5558: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5559: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5560: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;

Line 5557: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;

5553: l_encoded_error_message varchar2(2000);
5554: l_error_message_name varchar2(30);
5555: l_application_short_name varchar2(30);
5556: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;
5557: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;
5558: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5559: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5560: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5561: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;

Line 5560: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;

5556: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;
5557: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;
5558: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5559: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5560: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5561: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5562: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5563: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;
5564: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;

Line 5561: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;

5557: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;
5558: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5559: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5560: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5561: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5562: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5563: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;
5564: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
5565: l_orig_transaction_reference PA_EXPENDITURE_ITEMS_ALL.ORIG_TRANSACTION_REFERENCE%TYPE;

Line 5562: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;

5558: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5559: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5560: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5561: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5562: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5563: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;
5564: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
5565: l_orig_transaction_reference PA_EXPENDITURE_ITEMS_ALL.ORIG_TRANSACTION_REFERENCE%TYPE;
5566: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;

Line 5563: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;

5559: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5560: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5561: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5562: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5563: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;
5564: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
5565: l_orig_transaction_reference PA_EXPENDITURE_ITEMS_ALL.ORIG_TRANSACTION_REFERENCE%TYPE;
5566: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
5567: l_adjust_allowed BOOLEAN := TRUE;

Line 5564: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;

5560: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5561: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5562: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5563: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;
5564: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
5565: l_orig_transaction_reference PA_EXPENDITURE_ITEMS_ALL.ORIG_TRANSACTION_REFERENCE%TYPE;
5566: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
5567: l_adjust_allowed BOOLEAN := TRUE;
5568: l_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE; /* Bug 5436420 */

Line 5565: l_orig_transaction_reference PA_EXPENDITURE_ITEMS_ALL.ORIG_TRANSACTION_REFERENCE%TYPE;

5561: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5562: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5563: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;
5564: l_adjusted_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
5565: l_orig_transaction_reference PA_EXPENDITURE_ITEMS_ALL.ORIG_TRANSACTION_REFERENCE%TYPE;
5566: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
5567: l_adjust_allowed BOOLEAN := TRUE;
5568: l_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE; /* Bug 5436420 */
5569: l_project_id_cache PA_PROJECTS_ALL.PROJECT_ID%TYPE := -1; /* Bug 5441891 */

Line 5648: || ' pa_expenditure_items_all ei'

5644: || ',ei.payroll_accrual_flag'
5645: || ',ei.cbs_element_id'; -- Added for CBS Enhancement Bug 16220146
5646:
5647: from_clause := ' FROM'
5648: || ' pa_expenditure_items_all ei'
5649: || ',pa_expenditures_all e';
5650:
5651: where_clause := ' WHERE ei.expenditure_id = e.expenditure_id';
5652:

Line 6447: FROM pa_expenditure_items_all

6443: PRAGMA EXCEPTION_INIT(row_locked, -54);
6444: BEGIN
6445: SELECT NULL
6446: INTO l_dummy
6447: FROM pa_expenditure_items_all
6448: WHERE expenditure_item_id = v_expenditure_item_id
6449: FOR UPDATE OF expenditure_item_id NOWAIT;
6450: EXCEPTION
6451: WHEN row_locked THEN

Line 7934: pa_expenditure_items_all

7930: CURSOR GetRelatedItems IS
7931: SELECT
7932: expenditure_item_id
7933: FROM
7934: pa_expenditure_items_all
7935: WHERE
7936: source_expenditure_item_id = X_expenditure_item_id;
7937: BEGIN
7938:

Line 7941: UPDATE pa_expenditure_items_all

7937: BEGIN
7938:
7939: FOR eachRec IN GetRelatedItems LOOP
7940:
7941: UPDATE pa_expenditure_items_all
7942: SET
7943: cost_distributed_flag = 'N'
7944: , revenue_distributed_flag = 'N'
7945: , rev_dist_rejection_code = NULL /*Added for bug:9367103 */

Line 8068: UPDATE pa_expenditure_items_all ei

8064: /* R12 Changes End */
8065:
8066: ELSE
8067:
8068: UPDATE pa_expenditure_items_all ei
8069: SET
8070: ei.cost_distributed_flag = 'N'
8071: , ei.revenue_distributed_flag = 'N'
8072: , ei.rev_dist_rejection_code = NULL /*Added for bug:9367103 */

Line 8197: pa_expenditure_items_all

8193: CURSOR GetRelatedItems IS
8194: SELECT
8195: expenditure_item_id
8196: FROM
8197: pa_expenditure_items_all
8198: WHERE
8199: source_expenditure_item_id = X_expenditure_item_id;
8200: BEGIN
8201: FOR eachRec IN GetRelatedItems LOOP

Line 8203: UPDATE pa_expenditure_items_all

8199: source_expenditure_item_id = X_expenditure_item_id;
8200: BEGIN
8201: FOR eachRec IN GetRelatedItems LOOP
8202:
8203: UPDATE pa_expenditure_items_all
8204: SET
8205: cost_distributed_flag = 'N'
8206: , revenue_distributed_flag = 'N'
8207: , rev_dist_rejection_code = NULL /*Added for bug:9367103 */

Line 8323: UPDATE pa_expenditure_items_all ei

8319: CheckStatus(temp_status);
8320: /* R12 Changes End */
8321:
8322: ELSE
8323: UPDATE pa_expenditure_items_all ei
8324: SET
8325: ei.cost_distributed_flag = 'N'
8326: , ei.revenue_distributed_flag = 'N'
8327: , ei.rev_dist_rejection_code = NULL /*Added for bug:9367103 */

Line 8457: pa_expenditure_items_all

8453: CURSOR GetRelatedItems IS
8454: SELECT
8455: expenditure_item_id
8456: FROM
8457: pa_expenditure_items_all
8458: WHERE
8459: source_expenditure_item_id = X_expenditure_item_id;
8460: BEGIN
8461:

Line 8464: UPDATE pa_expenditure_items_all

8460: BEGIN
8461:
8462: FOR eachRec IN GetRelatedItems LOOP
8463:
8464: UPDATE pa_expenditure_items_all
8465: SET
8466: cost_distributed_flag = 'N'
8467: , revenue_distributed_flag = 'N'
8468: , rev_dist_rejection_code = NULL /*Added for bug:9367103 */

Line 8559: UPDATE pa_expenditure_items_all ei

8555: CheckStatus(temp_status);
8556: /* R12 Changes End */
8557: ELSE
8558:
8559: UPDATE pa_expenditure_items_all ei
8560: SET
8561: ei.cost_distributed_flag = 'N'
8562: , ei.revenue_distributed_flag = 'N'
8563: , ei.rev_dist_rejection_code = NULL /*Added for bug:9367103 */

Line 8669: l_parent_cdf pa_expenditure_items_all.cost_distributed_flag%TYPE;

8665: l_RecvrOrgId NUMBER;
8666: l_Error_Stage VARCHAR2(10);
8667: l_Error_Code NUMBER;
8668: /*bug12983087 */
8669: l_parent_cdf pa_expenditure_items_all.cost_distributed_flag%TYPE;
8670: l_parent_Cc_Code pa_expenditure_items_all.CC_CROSS_CHARGE_CODE%TYPE;
8671: l_parent_CCharge_Type pa_expenditure_items_all.Cc_Cross_Charge_Type%TYPE;
8672: l_parent_Cc_Prvdr_Org_Id pa_expenditure_items_all.Cc_Prvdr_Organization_Id%TYPE;
8673: l_parent_Cc_Recvr_Org_Id pa_expenditure_items_all.Cc_Recvr_Organization_Id%TYPE;

Line 8670: l_parent_Cc_Code pa_expenditure_items_all.CC_CROSS_CHARGE_CODE%TYPE;

8666: l_Error_Stage VARCHAR2(10);
8667: l_Error_Code NUMBER;
8668: /*bug12983087 */
8669: l_parent_cdf pa_expenditure_items_all.cost_distributed_flag%TYPE;
8670: l_parent_Cc_Code pa_expenditure_items_all.CC_CROSS_CHARGE_CODE%TYPE;
8671: l_parent_CCharge_Type pa_expenditure_items_all.Cc_Cross_Charge_Type%TYPE;
8672: l_parent_Cc_Prvdr_Org_Id pa_expenditure_items_all.Cc_Prvdr_Organization_Id%TYPE;
8673: l_parent_Cc_Recvr_Org_Id pa_expenditure_items_all.Cc_Recvr_Organization_Id%TYPE;
8674: /*bug12983087 */

Line 8671: l_parent_CCharge_Type pa_expenditure_items_all.Cc_Cross_Charge_Type%TYPE;

8667: l_Error_Code NUMBER;
8668: /*bug12983087 */
8669: l_parent_cdf pa_expenditure_items_all.cost_distributed_flag%TYPE;
8670: l_parent_Cc_Code pa_expenditure_items_all.CC_CROSS_CHARGE_CODE%TYPE;
8671: l_parent_CCharge_Type pa_expenditure_items_all.Cc_Cross_Charge_Type%TYPE;
8672: l_parent_Cc_Prvdr_Org_Id pa_expenditure_items_all.Cc_Prvdr_Organization_Id%TYPE;
8673: l_parent_Cc_Recvr_Org_Id pa_expenditure_items_all.Cc_Recvr_Organization_Id%TYPE;
8674: /*bug12983087 */
8675: PROCEDURE RecalcRelatedItems( X_expenditure_item_id IN NUMBER

Line 8672: l_parent_Cc_Prvdr_Org_Id pa_expenditure_items_all.Cc_Prvdr_Organization_Id%TYPE;

8668: /*bug12983087 */
8669: l_parent_cdf pa_expenditure_items_all.cost_distributed_flag%TYPE;
8670: l_parent_Cc_Code pa_expenditure_items_all.CC_CROSS_CHARGE_CODE%TYPE;
8671: l_parent_CCharge_Type pa_expenditure_items_all.Cc_Cross_Charge_Type%TYPE;
8672: l_parent_Cc_Prvdr_Org_Id pa_expenditure_items_all.Cc_Prvdr_Organization_Id%TYPE;
8673: l_parent_Cc_Recvr_Org_Id pa_expenditure_items_all.Cc_Recvr_Organization_Id%TYPE;
8674: /*bug12983087 */
8675: PROCEDURE RecalcRelatedItems( X_expenditure_item_id IN NUMBER
8676: , X_user IN NUMBER

Line 8673: l_parent_Cc_Recvr_Org_Id pa_expenditure_items_all.Cc_Recvr_Organization_Id%TYPE;

8669: l_parent_cdf pa_expenditure_items_all.cost_distributed_flag%TYPE;
8670: l_parent_Cc_Code pa_expenditure_items_all.CC_CROSS_CHARGE_CODE%TYPE;
8671: l_parent_CCharge_Type pa_expenditure_items_all.Cc_Cross_Charge_Type%TYPE;
8672: l_parent_Cc_Prvdr_Org_Id pa_expenditure_items_all.Cc_Prvdr_Organization_Id%TYPE;
8673: l_parent_Cc_Recvr_Org_Id pa_expenditure_items_all.Cc_Recvr_Organization_Id%TYPE;
8674: /*bug12983087 */
8675: PROCEDURE RecalcRelatedItems( X_expenditure_item_id IN NUMBER
8676: , X_user IN NUMBER
8677: , X_login IN NUMBER

Line 8681: l_parent_cdf pa_expenditure_items_all.cost_distributed_flag%TYPE;

8677: , X_login IN NUMBER
8678: , X_module IN VARCHAR2
8679: , X_status OUT NOCOPY NUMBER )
8680: IS
8681: l_parent_cdf pa_expenditure_items_all.cost_distributed_flag%TYPE;
8682:
8683: CURSOR GetRelatedItems IS
8684: SELECT
8685: expenditure_item_id

Line 8687: pa_expenditure_items_all

8683: CURSOR GetRelatedItems IS
8684: SELECT
8685: expenditure_item_id
8686: FROM
8687: pa_expenditure_items_all
8688: WHERE
8689: source_expenditure_item_id = X_expenditure_item_id;
8690: /* Modified the update statement not to derive cc_* fields if parent Ei is cost distributed bug 12983087 */
8691: BEGIN

Line 8704: pa_expenditure_items_all ei1,pa_expenditure_items_all ei2

8700: l_parent_cdf,l_parent_CCharge_Type,
8701: l_parent_Cc_Prvdr_Org_Id,l_parent_Cc_Recvr_Org_Id,
8702: l_parent_Cc_Recvr_Org_Id,l_parent_Cc_Code
8703: from
8704: pa_expenditure_items_all ei1,pa_expenditure_items_all ei2
8705: where ei1.expenditure_item_id = ei2.adjusted_expenditure_item_id and
8706: ei2.expenditure_item_id = eachRec.expenditure_item_id;
8707: EXCEPTION
8708: WHEN NO_DATA_FOUND THEN

Line 8714: UPDATE pa_expenditure_items_all

8710: WHEN OTHERS THEN
8711: l_parent_cdf := 'N';
8712: end;
8713:
8714: UPDATE pa_expenditure_items_all
8715: SET
8716: cc_cross_charge_code =DECODE(l_parent_cdf,'Y',l_parent_Cc_Code,DECODE(X_adjust_level,'I', X_cc_code, l_cc_code))
8717: , cc_cross_charge_type = DECODE(l_parent_cdf,'Y',l_parent_CCharge_Type,DECODE(X_adjust_level,'I',X_cc_type, l_cc_type))
8718: , cc_bl_distributed_code = DECODE(l_parent_cdf,'Y','N',DECODE(X_adjust_level,'I',X_bl_dist_code,l_bl_dist_code))

Line 8903: pa_expenditure_items_all ei1,pa_expenditure_items_all ei2

8899: l_parent_cdf,l_parent_CCharge_Type,
8900: l_parent_Cc_Prvdr_Org_Id,l_parent_Cc_Recvr_Org_Id,
8901: l_parent_Cc_Code
8902: from
8903: pa_expenditure_items_all ei1,pa_expenditure_items_all ei2
8904: where ei1.expenditure_item_id = ei2.adjusted_expenditure_item_id and
8905: ei2.expenditure_item_id = ItemsIdTab(i);
8906: EXCEPTION
8907: WHEN NO_DATA_FOUND THEN

Line 8913: UPDATE pa_expenditure_items_all

8909: WHEN OTHERS THEN
8910: l_parent_cdf := 'N';
8911: end;
8912:
8913: UPDATE pa_expenditure_items_all
8914: SET
8915: cc_cross_charge_code =DECODE(l_parent_cdf,'Y',l_parent_Cc_Code,DECODE(X_adjust_level,'I', X_cc_code, l_cc_code))
8916: , cc_cross_charge_type = DECODE(l_parent_cdf,'Y',l_parent_CCharge_Type,DECODE(X_adjust_level,'I',X_cc_type, l_cc_type))
8917: , cc_bl_distributed_code = DECODE(l_parent_cdf,'Y','N',DECODE(X_adjust_level,'I',X_bl_dist_code,l_bl_dist_code))

Line 9015: pa_expenditure_items_all

9011: CURSOR GetRelatedItems IS
9012: SELECT
9013: expenditure_item_id
9014: FROM
9015: pa_expenditure_items_all
9016: WHERE
9017: source_expenditure_item_id = X_expenditure_item_id;
9018: BEGIN
9019: --print_message('in related ei');

Line 9022: UPDATE pa_expenditure_items_all

9018: BEGIN
9019: --print_message('in related ei');
9020: FOR eachRec IN GetRelatedItems LOOP
9021: --print_message('in related ei loop');
9022: UPDATE pa_expenditure_items_all
9023: SET
9024: cc_cross_charge_code = 'N'
9025: , cc_bl_distributed_code = DECODE(X_adjust_level,'I',X_bl_dist_code, l_bl_dist_code)
9026: , cc_ic_processed_code = DECODE(X_adjust_level,'I',X_ic_proc_code, l_ic_proc_code)

Line 9098: UPDATE pa_expenditure_items_all

9094: end if;
9095: END IF;
9096:
9097:
9098: UPDATE pa_expenditure_items_all
9099: SET
9100: cc_cross_charge_code = 'N'
9101: , cc_bl_distributed_code = DECODE(X_adjust_level,'I',X_bl_dist_code, l_bl_dist_code)
9102: , cc_ic_processed_code = DECODE(X_adjust_level,'I',X_ic_proc_code, l_ic_proc_code)

Line 9219: pa_expenditure_items_all

9215: CURSOR GetRelatedItems IS
9216: SELECT
9217: expenditure_item_id
9218: FROM
9219: pa_expenditure_items_all
9220: WHERE
9221: source_expenditure_item_id = X_expenditure_item_id;
9222: BEGIN
9223:

Line 9226: UPDATE pa_expenditure_items_all

9222: BEGIN
9223:
9224: FOR eachRec IN GetRelatedItems LOOP
9225:
9226: UPDATE pa_expenditure_items_all
9227:
9228: SET
9229: cc_bl_distributed_code = DECODE(X_adjust_level,'I',X_bl_dist_code, l_bl_dist_code)
9230: , cc_ic_processed_code = DECODE(X_adjust_level,'I',X_ic_proc_code, l_ic_proc_code)

Line 9328: UPDATE pa_expenditure_items_all ei

9324: CheckStatus(temp_status);
9325: /* R12 Changes End */
9326: ELSE
9327:
9328: UPDATE pa_expenditure_items_all ei
9329: SET
9330: cc_bl_distributed_code = DECODE(X_adjust_level, 'I', X_bl_dist_code, l_bl_dist_code)
9331: , cc_ic_processed_code = DECODE(X_adjust_level, 'I',X_ic_proc_code, l_ic_proc_code)
9332: , acct_tp_rate_type = X_acct_tp_rate_type

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

9427:
9428: IS
9429:
9430: TYPE net_zero_ei_date_rec_type IS RECORD (
9431: net_zero_adjustment_flag_1 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9432: expenditure_item_date_1 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9433: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9434: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9435: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

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

9428: IS
9429:
9430: TYPE net_zero_ei_date_rec_type IS RECORD (
9431: net_zero_adjustment_flag_1 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9432: expenditure_item_date_1 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9433: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9434: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9435: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9436: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

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

9429:
9430: TYPE net_zero_ei_date_rec_type IS RECORD (
9431: net_zero_adjustment_flag_1 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9432: expenditure_item_date_1 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9433: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9434: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9435: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9436: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9437: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

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

9430: TYPE net_zero_ei_date_rec_type IS RECORD (
9431: net_zero_adjustment_flag_1 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9432: expenditure_item_date_1 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9433: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9434: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9435: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9436: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9437: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9438: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

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

9431: net_zero_adjustment_flag_1 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9432: expenditure_item_date_1 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9433: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9434: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9435: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9436: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9437: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9438: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9439: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

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

9432: expenditure_item_date_1 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9433: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9434: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9435: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9436: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9437: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9438: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9439: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9440: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

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

9433: net_zero_adjustment_flag_2 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9434: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9435: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9436: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9437: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9438: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9439: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9440: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9441: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

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

9434: expenditure_item_date_2 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9435: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9436: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9437: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9438: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9439: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9440: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9441: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9442: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,

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

9435: net_zero_adjustment_flag_3 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9436: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9437: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9438: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9439: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9440: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9441: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9442: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9443: net_zero_adjustment_flag_7 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,

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

9436: expenditure_item_date_3 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9437: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9438: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9439: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9440: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9441: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9442: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9443: net_zero_adjustment_flag_7 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9444: expenditure_item_date_7 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL);

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

9437: net_zero_adjustment_flag_4 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9438: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9439: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9440: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9441: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9442: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9443: net_zero_adjustment_flag_7 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9444: expenditure_item_date_7 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL);
9445:

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

9438: expenditure_item_date_4 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9439: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9440: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9441: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9442: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9443: net_zero_adjustment_flag_7 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9444: expenditure_item_date_7 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL);
9445:
9446: l_net_zero_ei_date net_zero_ei_date_rec_type;

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

9439: net_zero_adjustment_flag_5 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9440: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9441: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9442: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9443: net_zero_adjustment_flag_7 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9444: expenditure_item_date_7 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL);
9445:
9446: l_net_zero_ei_date net_zero_ei_date_rec_type;
9447: l_allow_adjustment_flag VARCHAR2(1);

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

9440: expenditure_item_date_5 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9441: net_zero_adjustment_flag_6 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9442: expenditure_item_date_6 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL,
9443: net_zero_adjustment_flag_7 pa_expenditure_items_all.net_zero_adjustment_flag%TYPE DEFAULT NULL,
9444: expenditure_item_date_7 pa_expenditure_items_all.expenditure_item_date%TYPE DEFAULT NULL);
9445:
9446: l_net_zero_ei_date net_zero_ei_date_rec_type;
9447: l_allow_adjustment_flag VARCHAR2(1);
9448: l_predefined_flag VARCHAR2(1);

Line 9649: l_return_currency_code pa_expenditure_items_all.denom_currency_code%type;

9645: , p_person_id IN NUMBER default NULL /*Bugfix:2798742 */
9646: , p_ei_date IN DATE default NULL /*Bugfix:2798742 */
9647: ) RETURN VARCHAR2 IS
9648:
9649: l_return_currency_code pa_expenditure_items_all.denom_currency_code%type;
9650: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;
9651: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */
9652: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;
9653: l_job_id pa_expenditure_items_all.job_id%TYPE;

Line 9653: l_job_id pa_expenditure_items_all.job_id%TYPE;

9649: l_return_currency_code pa_expenditure_items_all.denom_currency_code%type;
9650: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;
9651: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */
9652: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;
9653: l_job_id pa_expenditure_items_all.job_id%TYPE;
9654: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
9655: l_cost_rate pa_bill_rates_all.rate%TYPE;
9656: l_start_date Date;
9657: l_end_date Date;

Line 9661: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;

9657: l_end_date Date;
9658: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
9659: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
9660: l_rate_sch_id pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE;
9661: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
9662: l_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
9663: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
9664: l_ot_project_id pa_projects_all.project_id%TYPE;
9665: l_ot_task_id pa_tasks.task_id%TYPE;

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

10180: l_billable_flag VARCHAR2(1);
10181: l_return BOOLEAN := TRUE;
10182: l_pooled_flag VARCHAR(1); /* Bug 5006835 */
10183: l_encoded_error_message VARCHAR2(2000); /* Bug 4997739 */
10184: l_historical_flag PA_EXPENDITURE_ITEMS_ALL.HISTORICAL_FLAG%TYPE := 'N'; /* Bug 5551933 */
10185:
10186: CURSOR c_get_ap_offset_method IS
10187: SELECT LIABILITY_POST_LOOKUP_CODE
10188: FROM AP_SYSTEM_PARAMETERS;

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

11020: END is_recoverability_affected;
11021: /* R12 Changes End */
11022:
11023: /* Bug 4901129 - Start */
11024: FUNCTION is_orphaned_src_sys_reversal( p_document_distribution_id IN PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_ID%TYPE
11025: , p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE%TYPE)
11026: RETURN VARCHAR2 IS
11027: l_result VARCHAR2(1) := 'N';
11028:

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

11021: /* R12 Changes End */
11022:
11023: /* Bug 4901129 - Start */
11024: FUNCTION is_orphaned_src_sys_reversal( p_document_distribution_id IN PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_ID%TYPE
11025: , p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE%TYPE)
11026: RETURN VARCHAR2 IS
11027: l_result VARCHAR2(1) := 'N';
11028:
11029: CURSOR c_get_count IS

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

11027: l_result VARCHAR2(1) := 'N';
11028:
11029: CURSOR c_get_count IS
11030: SELECT DECODE(count(*),0,'N','Y')
11031: FROM pa_expenditure_items_all ei /* Bug 5561597 */
11032: WHERE ( ei.document_header_id, ei.document_distribution_id) IN
11033: ( SELECT apdist2.invoice_id, apdist2.invoice_distribution_id /* Bug 5561597 */
11034: FROM ap_invoice_distributions_all apdist1, /* Bug 5561597 */
11035: ap_invoice_distributions_all apdist2 /* Bug 5561597 */

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

11075: END is_orphaned_src_sys_reversal;
11076: /* Bug 4901129 - End */
11077:
11078: /* Bug 5235354 - Start */
11079: FUNCTION RepCurrOrSecLedgerDiffCurr(p_org_id PA_EXPENDITURE_ITEMS_ALL.ORG_ID%TYPE)
11080: RETURN BOOLEAN IS
11081:
11082: l_count NUMBER := -1;
11083: l_return BOOLEAN := FALSE;

Line 11188: p_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE DEFAULT NULL /Bug 13906739: Added NULL as default parameter Value/

11184:
11185: /* Bug 5501250 - Start */
11186: FUNCTION IsRelatedToPrepayApp(
11187: p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE,
11188: p_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE DEFAULT NULL /*Bug 13906739: Added NULL as default parameter Value*/
11189: ) RETURN BOOLEAN IS
11190: l_dummy varchar2(1);
11191: BEGIN
11192: