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 443: FROM pa_cost_distribution_lines_all cdl,

439:
440: SELECT NVL(cdl.burdened_cost,cdl.amount)
441: + NVL(PROJFUNC_BURDENED_CHANGE,0) /* added for Burdening Enhanceents */
442: INTO l_burdened_cost
443: FROM pa_cost_distribution_lines_all cdl,
444: pa_expenditure_items_all ei,
445: pa_transaction_sources pts
446: WHERE
447: cdl.expenditure_item_id = p_exp_item_id

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

2262:
2263: END IF; -- IF l_closed_prd_exists = 'Y' THEN
2264:
2265: IF P_DEBUG_MODE = 'Y' THEN
2266: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all ');
2267: END IF;
2268:
2269: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2270: UPDATE pa_cost_distribution_lines_all cdl

Line 2270: UPDATE pa_cost_distribution_lines_all cdl

2266: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all ');
2267: END IF;
2268:
2269: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2270: UPDATE pa_cost_distribution_lines_all cdl
2271: SET cdl.budget_version_id = NVL(l_bvidTab(i),cdl.budget_version_id),
2272: cdl.budget_line_id = NVL(l_blidTab(i),cdl.budget_line_id)
2273: WHERE cdl.expenditure_item_id = l_DocHdrTab(i)
2274: AND ( cdl.line_num = l_DocDistTab(i) OR (l_burcodeTab(i) = 'S' AND cdl.line_type ='D'))

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

2281: AND xev.process_status_code <> 'P' )
2282: );
2283:
2284: IF P_DEBUG_MODE = 'Y' THEN
2285: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2286: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_bc_commitments_all ');
2287: END IF;
2288:
2289: -- Bug 5206341 : Logic to stamp new budget_line_id for transactions which are falling with in

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

2390:
2391: END LOOP;
2392:
2393: IF P_DEBUG_MODE = 'Y' THEN
2394: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for EXP');
2395: END IF;
2396:
2397: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2398: UPDATE pa_cost_distribution_lines_all cdl

Line 2398: UPDATE pa_cost_distribution_lines_all cdl

2394: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for EXP');
2395: END IF;
2396:
2397: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2398: UPDATE pa_cost_distribution_lines_all cdl
2399: SET cdl.budget_version_id = NVL(l_bvidTab(i),cdl.budget_version_id),
2400: cdl.budget_line_id = NVL(l_blidTab(i),cdl.budget_line_id)
2401: WHERE cdl.expenditure_item_id = l_DocHdrTab(i)
2402: -- All the pending EXP lines associated with commitment should get updated ,hence no doc_dist_id join

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

2411: AND xev.process_status_code <> 'P' )
2412: );
2413:
2414: IF P_DEBUG_MODE = 'Y' THEN
2415: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2416: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for BTC');
2417: END IF;
2418:
2419: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last

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

2412: );
2413:
2414: IF P_DEBUG_MODE = 'Y' THEN
2415: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2416: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for BTC');
2417: END IF;
2418:
2419: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2420: UPDATE pa_cost_distribution_lines_all cdl

Line 2420: UPDATE pa_cost_distribution_lines_all cdl

2416: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_cost_distribution_lines_all for BTC');
2417: END IF;
2418:
2419: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2420: UPDATE pa_cost_distribution_lines_all cdl
2421: SET cdl.budget_version_id = NVL(l_bvidTab(i),cdl.budget_version_id),
2422: cdl.budget_line_id = NVL(l_blidTab(i),cdl.budget_line_id)
2423: WHERE cdl.expenditure_item_id IN (SELECT exp2.expenditure_item_id
2424: FROM pa_cost_distribution_lines_all cdl1,

Line 2424: FROM pa_cost_distribution_lines_all cdl1,

2420: UPDATE pa_cost_distribution_lines_all cdl
2421: SET cdl.budget_version_id = NVL(l_bvidTab(i),cdl.budget_version_id),
2422: cdl.budget_line_id = NVL(l_blidTab(i),cdl.budget_line_id)
2423: WHERE cdl.expenditure_item_id IN (SELECT exp2.expenditure_item_id
2424: FROM pa_cost_distribution_lines_all cdl1,
2425: pa_expenditure_items_all exp2 -- BTC
2426: WHERE cdl1.expenditure_item_id = l_DocHdrTab(i)
2427: AND cdl1.burden_sum_source_run_id = exp2.burden_sum_dest_run_id
2428: AND exp2.system_linkage_function = 'BTC')

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

2437: AND xev.process_status_code <> 'P' )
2438: );
2439:
2440: IF P_DEBUG_MODE = 'Y' THEN
2441: pa_fck_util.debug_msg( 'Number of pa_cost_distribution_lines_all updated'||SQL%ROWCOUNT);
2442: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_bc_commitments_all ');
2443: END IF;
2444:
2445: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last