DBA Data[Home] [Help]

APPS.PA_BURDEN_COSTING dependencies on PA_TRANSACTIONS

Line 1355: pa_transactions.FlushEiTabs();

1351:
1352: IF P_DEBUG_MODE THEN
1353: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '850:call Flusheitabs');
1354: END IF;
1355: pa_transactions.FlushEiTabs();
1356: i := 0;
1357: /*=========================================================+
1358: | CWK - See if the project has Budgetory control enabled. |
1359: +=========================================================*/

Line 1439: pa_transactions.InsertExpGroup(exp_group,'APPROVED',sysdate,'BTC',0,NULL,NULL,G_MOAC_ORG_ID);

1435: if (create_exp_grp_flag ) then
1436: IF P_DEBUG_MODE THEN
1437: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '950:call to insertexpgroup');
1438: END IF;
1439: pa_transactions.InsertExpGroup(exp_group,'APPROVED',sysdate,'BTC',0,NULL,NULL,G_MOAC_ORG_ID);
1440: IF P_DEBUG_MODE THEN
1441: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1000:back from insertexpgroup');
1442: END IF;
1443: -- Handle error

Line 1541: pa_transactions.InsertExp(

1537: */
1538: IF P_DEBUG_MODE THEN
1539: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1200:Call InsertExp');
1540: END IF;
1541: pa_transactions.InsertExp(
1542: x_expenditure_id =>exp_id,
1543: x_expend_status =>'APPROVED',
1544: x_expend_ending => pa_utils.NewGetWeekEnding((bcc_rec.source_exp_item_date)), --Bug 2236707,3551106
1545: -- x_expend_ending =>pa_utils.NewGetWeekEnding(pa_utils2.get_pa_period_end_date_OU(bcc_rec.source_pa_date)-6), -- Bug 2933915,3551106

Line 1679: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */

1675: over_project_id := proj_rec.dest_project_id;
1676: end if;
1677: end if;
1678:
1679: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */
1680: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
1681: THEN
1682: IF P_DEBUG_MODE THEN
1683: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1510:Calling Get_work_type_id with Project_id [' ||

Line 1710: pa_transactions_pub.validate_transaction. Also passing null's for rate

1706: (nvl(c_project_id, -999999) <> over_project_id) or
1707: (nvl(c_expenditure_type, '') <> prev_bcc_rec.source_ind_expenditure_type)) then
1708: /*
1709: Multi-Curr Changes. Chnaged patc.get_status to
1710: pa_transactions_pub.validate_transaction. Also passing null's for rate
1711: attributes, the raw cost for BTC transactions is 0. The burdened costs are
1712: calculated using existing CDL's which are already converted.
1713: */
1714:

Line 1719: pa_transactions_pub.validate_transaction(

1715: IF P_DEBUG_MODE THEN
1716: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1550:Call PATC for project,task or exp type change');
1717: END IF;
1718: /* modified for the Bug#1825827 */
1719: pa_transactions_pub.validate_transaction(
1720: x_project_id =>over_project_id,
1721: x_task_id =>over_task_id,
1722: x_ei_date =>prev_bcc_rec.source_exp_item_date,
1723: x_expenditure_type =>prev_bcc_rec.source_ind_expenditure_type,

Line 1803: /* Commenting this for bug 2607781 as work type id needs to be derived before the call to pa_transactions_pub.validate_transaction

1799: /*
1800: * AddEi Attributes - related change.
1801: * Deriving work_type_id.
1802: */
1803: /* Commenting this for bug 2607781 as work type id needs to be derived before the call to pa_transactions_pub.validate_transaction
1804: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
1805: THEN
1806: IF P_DEBUG_MODE THEN
1807: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1645:Calling Get_work_type_id with Project_id [' ||

Line 1838: pa_transactions.LoadEi(

1834: IF P_DEBUG_MODE THEN
1835: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1650:Call Loadei');
1836: END IF;
1837:
1838: pa_transactions.LoadEi(
1839: x_expenditure_item_id =>exp_item_id,
1840: x_expenditure_id =>x_exp_id,
1841: x_expenditure_item_date
1842: =>prev_bcc_rec.source_exp_item_date ,

Line 1930: pa_transactions.InsItems(1,0,'BTC','BTC',i, status,'N');

1926: if ( i >= 500) then
1927: IF P_DEBUG_MODE THEN
1928: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1750:Call Insitems for i>=500');
1929: END IF;
1930: pa_transactions.InsItems(1,0,'BTC','BTC',i, status,'N');
1931:
1932: -- -----------------------------------------------------------------------
1933: -- OGM_0.0 - Interface for creating new ADLS for each expenditure Item
1934: -- created. This will create award distribution lines only when OGM is

Line 1937: -- pa_transactions.InsItemsis is in error.

1933: -- OGM_0.0 - Interface for creating new ADLS for each expenditure Item
1934: -- created. This will create award distribution lines only when OGM is
1935: -- installed for the ORG in process.
1936: -- The folowing procedure returns doing nothing if status returned from
1937: -- pa_transactions.InsItemsis is in error.
1938: -- ------------------------------------------------------------------------
1939: IF P_DEBUG_MODE THEN
1940: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500');
1941: END IF;

Line 1947: pa_transactions.FlushEiTabs();

1943: IF P_DEBUG_MODE THEN
1944: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');
1945: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1800:Call FlushEiTabs');
1946: END IF;
1947: pa_transactions.FlushEiTabs();
1948: IF P_DEBUG_MODE THEN
1949: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1850:Back from FlushEiTabs');
1950: END IF;
1951: i := 0;

Line 2201: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */

2197: END IF;
2198: select pa_expenditure_items_s.nextval
2199: into exp_item_id from dual;
2200:
2201: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */
2202: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
2203: THEN
2204: IF P_DEBUG_MODE THEN
2205: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2110:Calling Get_work_type_id with Project_id [' ||

Line 2229: pa_transactions_pub.validate_transaction. Also passing null's for rate

2225: -- Ref Bug # : 609978
2226: --
2227: /*
2228: Multi-Curr Changes. Changed patc.get_status to
2229: pa_transactions_pub.validate_transaction. Also passing null's for rate
2230: attributes, the raw cost for BTC transactions is 0. The burdened costs are
2231: calculated using existing CDL's which are already converted.
2232: */
2233:

Line 2238: pa_transactions_pub.validate_transaction(

2234: IF P_DEBUG_MODE THEN
2235: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2150:Process Last Set .. call PATC');
2236: END IF;
2237: /* modified for the Bug#1825827 */
2238: pa_transactions_pub.validate_transaction(
2239: x_project_id =>over_project_id,
2240: x_task_id =>over_task_id,
2241: x_ei_date =>prev_bcc_rec.source_exp_item_date,
2242: x_expenditure_type =>prev_bcc_rec.source_ind_expenditure_type,

Line 2304: /* Commenting this for bug 2607781 as work type id needs to be derived before the call to pa_transactions_pub.validate_transaction

2300: /*
2301: * AddEi Attributes - related change.
2302: * Deriving work_type_id.
2303: */
2304: /* Commenting this for bug 2607781 as work type id needs to be derived before the call to pa_transactions_pub.validate_transaction
2305: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
2306: THEN
2307: IF P_DEBUG_MODE THEN
2308: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2245:Calling Get_work_type_id with Project_id [' ||

Line 2337: pa_transactions.LoadEi(

2333: -- BTC txns should not be cross charged, so setting cross charge code to X.
2334: IF P_DEBUG_MODE THEN
2335: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2250:Process Last Set ..Call Loadei');
2336: END IF;
2337: pa_transactions.LoadEi(
2338: x_expenditure_item_id =>exp_item_id,
2339: x_expenditure_id =>x_exp_id,
2340: x_expenditure_item_date
2341: =>prev_bcc_rec.source_exp_item_date ,

Line 2425: pa_transactions.InsItems(1,0,'BTC','BTC',i, status,'N');

2421: if i > 0 then
2422: IF P_DEBUG_MODE THEN
2423: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2300:Process Last Set ..Call Insitems');
2424: END IF;
2425: pa_transactions.InsItems(1,0,'BTC','BTC',i, status,'N');
2426:
2427: -- -----------------------------------------------------------------------
2428: -- OGM_0.0 - Interface for creating new ADLS for each expenditure Item
2429: -- created. This will create award distribution lines only when OGM is

Line 2432: -- pa_transactions.InsItems.

2428: -- OGM_0.0 - Interface for creating new ADLS for each expenditure Item
2429: -- created. This will create award distribution lines only when OGM is
2430: -- installed for the ORG in process.
2431: -- The folowing procedure returns doing nothing if status is in ERROR for
2432: -- pa_transactions.InsItems.
2433: -- ------------------------------------------------------------------------
2434: IF P_DEBUG_MODE THEN
2435: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500');
2436: END IF;

Line 2444: pa_transactions.FlushEiTabs();

2440: IF P_DEBUG_MODE THEN
2441: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');
2442: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2350:Process Last Set ..Call Flusheitabs');
2443: END IF;
2444: pa_transactions.FlushEiTabs();
2445: i := 0;
2446: end if;
2447:
2448: /*<>.....bug# 2255068*/