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_FUNDS_CONTROL_UTILS dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 374: FROM pa_cost_distribution_lines_all cdl,

370:
371: SELECT NVL(cdl.burdened_cost,cdl.amount)
372: + NVL(PROJFUNC_BURDENED_CHANGE,0) /* added for Burdening Enhanceents */
373: INTO l_burdened_cost
374: FROM pa_cost_distribution_lines_all cdl,
375: pa_expenditure_items_all ei,
376: pa_transaction_sources pts
377: WHERE
378: cdl.expenditure_item_id = p_exp_item_id

Line 2115: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all ');

2111:
2112: END IF; -- IF l_closed_prd_exists = 'Y' THEN
2113:
2114: IF P_DEBUG_MODE = 'Y' THEN
2115: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all ');
2116: END IF;
2117:
2118: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2119: UPDATE pa_cost_distribution_lines_all cdl

Line 2119: UPDATE pa_cost_distribution_lines_all cdl

2115: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all ');
2116: END IF;
2117:
2118: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2119: UPDATE pa_cost_distribution_lines_all cdl
2120: SET cdl.budget_version_id = NVL(l_bvidTab(i),cdl.budget_version_id),
2121: cdl.budget_line_id = NVL(l_blidTab(i),cdl.budget_line_id)
2122: WHERE cdl.expenditure_item_id = l_DocHdrTab(i)
2123: AND ( cdl.line_num = l_DocDistTab(i) OR (l_burcodeTab(i) = 'S' AND cdl.line_type ='D'))

Line 2134: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);

2130: AND xev.process_status_code <> 'P' )
2131: );
2132:
2133: IF P_DEBUG_MODE = 'Y' THEN
2134: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2135: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_bc_commitments_all ');
2136: END IF;
2137:
2138: -- Bug 5206341 : Logic to stamp new budget_line_id for transactions which are falling with in

Line 2243: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for EXP');

2239:
2240: END LOOP;
2241:
2242: IF P_DEBUG_MODE = 'Y' THEN
2243: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for EXP');
2244: END IF;
2245:
2246: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2247: UPDATE pa_cost_distribution_lines_all cdl

Line 2247: UPDATE pa_cost_distribution_lines_all cdl

2243: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for EXP');
2244: END IF;
2245:
2246: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2247: UPDATE pa_cost_distribution_lines_all cdl
2248: SET cdl.budget_version_id = NVL(l_bvidTab(i),cdl.budget_version_id),
2249: cdl.budget_line_id = NVL(l_blidTab(i),cdl.budget_line_id)
2250: WHERE cdl.expenditure_item_id = l_DocHdrTab(i)
2251: -- All the pending EXP lines associated with commitment should get updated ,hence no doc_dist_id join

Line 2264: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);

2260: AND xev.process_status_code <> 'P' )
2261: );
2262:
2263: IF P_DEBUG_MODE = 'Y' THEN
2264: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2265: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for BTC');
2266: END IF;
2267:
2268: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last

Line 2265: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for BTC');

2261: );
2262:
2263: IF P_DEBUG_MODE = 'Y' THEN
2264: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2265: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for BTC');
2266: END IF;
2267:
2268: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2269: UPDATE pa_cost_distribution_lines_all cdl

Line 2269: UPDATE pa_cost_distribution_lines_all cdl

2265: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for BTC');
2266: END IF;
2267:
2268: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2269: UPDATE pa_cost_distribution_lines_all cdl
2270: SET cdl.budget_version_id = NVL(l_bvidTab(i),cdl.budget_version_id),
2271: cdl.budget_line_id = NVL(l_blidTab(i),cdl.budget_line_id)
2272: WHERE cdl.expenditure_item_id IN (SELECT exp2.expenditure_item_id
2273: FROM pa_cost_distribution_lines_all cdl1,

Line 2273: FROM pa_cost_distribution_lines_all cdl1,

2269: UPDATE pa_cost_distribution_lines_all cdl
2270: SET cdl.budget_version_id = NVL(l_bvidTab(i),cdl.budget_version_id),
2271: cdl.budget_line_id = NVL(l_blidTab(i),cdl.budget_line_id)
2272: WHERE cdl.expenditure_item_id IN (SELECT exp2.expenditure_item_id
2273: FROM pa_cost_distribution_lines_all cdl1,
2274: pa_expenditure_items_all exp2 -- BTC
2275: WHERE cdl1.expenditure_item_id = l_DocHdrTab(i)
2276: AND cdl1.burden_sum_source_run_id = exp2.burden_sum_dest_run_id
2277: AND exp2.system_linkage_function = 'BTC')

Line 2290: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);

2286: AND xev.process_status_code <> 'P' )
2287: );
2288:
2289: IF P_DEBUG_MODE = 'Y' THEN
2290: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2291: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_bc_commitments_all ');
2292: END IF;
2293:
2294: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last