APPS.PA_TRANSACTIONS dependencies on PA_EXPENDITURE_ITEMS

Line 577: INSERT INTO pa_expenditure_items_all (

573: IF P_DEBUG_MODE THEN
574: pa_cc_utils.log_message('InsItems: ' || 'Start of bulk insert for EI insertion');
575: END IF;
576: FORALL i IN 1..Rows ---{
577: INSERT INTO pa_expenditure_items_all (
578: expenditure_item_id
579: , expenditure_id
580: , expenditure_item_date
581: , task_id

Line 853: **INSERT INTO pa_expenditure_items_all (

849:
850: --PA-K Changes: Commented the following as bulk insert for EIs is being done now
851: /*IF nvl(X_gl_flag,'N') <> 'Y' THEN
852: **
853: **INSERT INTO pa_expenditure_items_all (
854: ** )
855: ** VALUES (
856: ** );
857: **ELSE

Line 858: ** INSERT INTO pa_expenditure_items_all (

854: ** )
855: ** VALUES (
856: ** );
857: **ELSE
858: ** INSERT INTO pa_expenditure_items_all (
859: ** )
860: ** VALUES (
861: ** );
862: */

Line 1145: INSERT INTO pa_expenditure_items_all(

1141: END LOOP;
1142:
1143: /* Insert the Reversing expenditure Items */
1144: FORALL i IN 1..Rows
1145: INSERT INTO pa_expenditure_items_all(
1146: expenditure_item_id
1147: , task_id
1148: , expenditure_type
1149: , system_linkage_function

Line 1378: pa_expenditure_items_all ei

1374: , ei.vendor_id ei_vendor_id
1375: , ei.document_type
1376: , ei.document_distribution_type
1377: FROM
1378: pa_expenditure_items_all ei
1379: WHERE
1380: ei.expenditure_item_id = TfrEiTab(i);
1381:
1382: FOR i IN 1..Rows LOOP

Line 1847: from pa_expenditure_items

1843: pa_cc_utils.log_message('CreateRelatedItem: ' || 'Work Type ID defaults from source EI');
1844: END IF;
1845: select work_type_id
1846: into l_work_type_id
1847: from pa_expenditure_items
1848: where expenditure_item_id = X_source_exp_item_id;
1849: end if;
1850: /* changes for bug2482593 ends */
1851:

Line 1854: pa_expenditure_items_s.nextval

1850: /* changes for bug2482593 ends */
1851:
1852: -- Need to select new MC columns here to pass to LoadEi and PATC
1853: SELECT
1854: pa_expenditure_items_s.nextval
1855: , ei.expenditure_id
1856: , ei.expenditure_item_date
1857: , e.incurred_by_person_id
1858: , e.incurred_by_organization_id

Line 1910: pa_expenditure_items ei

1906: , l_PROJECT_BURDENED_COST
1907: , l_ASSIGNMENT_ID
1908: /* , l_WORK_TYPE_ID bug2482593*/
1909: FROM
1910: pa_expenditure_items ei
1911: , pa_expenditures e
1912: , pa_tasks t
1913: WHERE
1914: e.expenditure_id = ei.expenditure_id

Line 2311: from pa_expenditure_items

2307: {
2308: pa_cc_utils.log_message("Work Type ID defaults from source EI");
2309: select work_type_id
2310: into l_work_type_id
2311: from pa_expenditure_items
2312: where expenditure_item_id = X_Expenditure_item_id;
2313: }
2314: */
2315: end if;

Line 2318: UPDATE pa_expenditure_items ei

2314: */
2315: end if;
2316: /* changes for bug 2482593 end */
2317:
2318: UPDATE pa_expenditure_items ei
2319: SET ei.denom_raw_cost = pa_currency.round_trans_currency_amt(X_denom_raw_cost,
2320: ei.denom_currency_code)
2321: ,ei.RAW_COST = NULL /* Added for bug#5067217 */
2322: ,ei.ACCT_RAW_COST = NULL /* Added for bug#5067217*/

Line 2331: UPDATE pa_expenditure_items ei

2327: AND (ei.adjusted_expenditure_item_id is NULL or ei.denom_raw_cost is NULL); /*bug 5617096*/
2328:
2329: /*
2330: * Commented for Bug 5617096
2331: UPDATE pa_expenditure_items ei
2332: SET
2333: ei.denom_raw_cost = pa_currency.round_trans_currency_amt(X_denom_raw_cost,
2334: ei.denom_currency_code)
2335: , ei.raw_cost_rate = X_denom_raw_cost_rate

Line 2364: UPDATE pa_expenditure_items ei

2360: )
2361: IS
2362: BEGIN
2363:
2364: UPDATE pa_expenditure_items ei
2365: SET ei.system_linkage_function = X_sys_link_func
2366: WHERE ei.source_expenditure_item_id = X_expend_item_id;
2367:
2368: