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_BC_COMMITMENTS_ALL

Line 994: -- Check if txn exists in pa_bc_packets or in pa_bc_commitments_all

990: -- #against a budget line, else it will return 'Y'.
991:
992: -- # Code flow is as follows for each of the BEM: Lowest Task/Top Task/Project Level
993: -- # If API called through Check funds or form
994: -- Check if txn exists in pa_bc_packets or in pa_bc_commitments_all
995: -- Elsif API called during Baseline/YearEnd
996: -- Check if txn exists in pa_bc_balances or pa_bc_packets
997: -- # For baseline/yearend , we're using bc_balances to increase performance ..
998: -- -----------------------------------------------------------------------------------------+

Line 1255: -- If its Check funds, then we need to look at data from pa_bc_commitments_all

1251: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then
1252: -- CHECK_FUNDS/THROUGH FORM ..this if condition ..
1253: -- BASELINE/YEAR_END ..else part ..
1254:
1255: -- If its Check funds, then we need to look at data from pa_bc_commitments_all
1256: Begin -- 'L' : pa_bc_packets
1257:
1258: Select 'N'
1259: into l_return_status

Line 1271: Begin -- 'L' : pa_bc_commitments_all

1267: and pbc.period_name = p_period_name
1268: and pbc.task_id = pra.task_id);
1269: Exception
1270: When no_data_found then
1271: Begin -- 'L' : pa_bc_commitments_all
1272: Select 'N'
1273: into l_return_status
1274: from pa_resource_assignments pra
1275: where pra.budget_version_id = p_budget_version_id

Line 1278: from pa_bc_commitments_all pbc

1274: from pa_resource_assignments pra
1275: where pra.budget_version_id = p_budget_version_id
1276: and pra.resource_assignment_id = p_resource_assignment_id
1277: and exists(select 1
1278: from pa_bc_commitments_all pbc
1279: where pbc.project_id = pra.project_id
1280: and pbc.resource_list_member_id = pra.resource_list_member_id
1281: and pbc.period_name = p_period_name
1282: and pbc.task_id = pra.task_id);

Line 1286: End; -- 'L' : pa_bc_commitments_all

1282: and pbc.task_id = pra.task_id);
1283: Exception
1284: When no_data_found then
1285: return 'Y';
1286: End; -- 'L' : pa_bc_commitments_all
1287: End; -- 'L' : pa_bc_packets
1288:
1289: Else
1290:

Line 1342: -- If its Check funds, then we need to look at data from pa_bc_commitments_all

1338: ElsIf l_budget_entry_level_code = 'T' then
1339:
1340: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then
1341:
1342: -- If its Check funds, then we need to look at data from pa_bc_commitments_all
1343: Begin -- 'T' : pa_bc_packets
1344:
1345: Select 'N'
1346: into l_return_status

Line 1358: Begin -- 'T' : pa_bc_commitments_all

1354: and pbc.period_name = p_period_name
1355: and pbc.top_task_id = pra.task_id);
1356: Exception
1357: When no_data_found then
1358: Begin -- 'T' : pa_bc_commitments_all
1359: Select 'N'
1360: into l_return_status
1361: from pa_resource_assignments pra
1362: where pra.budget_version_id = p_budget_version_id

Line 1365: from pa_bc_commitments_all pbc

1361: from pa_resource_assignments pra
1362: where pra.budget_version_id = p_budget_version_id
1363: and pra.resource_assignment_id = p_resource_assignment_id
1364: and exists(select 1
1365: from pa_bc_commitments_all pbc
1366: where pbc.project_id = pra.project_id
1367: and pbc.resource_list_member_id = pra.resource_list_member_id
1368: and pbc.period_name = p_period_name
1369: and pbc.top_task_id = pra.task_id);

Line 1373: End; -- 'T' : pa_bc_commitments_all

1369: and pbc.top_task_id = pra.task_id);
1370: Exception
1371: When no_data_found then
1372: return 'Y';
1373: End; -- 'T' : pa_bc_commitments_all
1374:
1375: End; -- 'T' : pa_bc_packets
1376:
1377: Else

Line 1429: -- If its Check funds, then we need to look at data from pa_bc_commitments_all

1425: ElsIf l_budget_entry_level_code = 'P' then
1426:
1427: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then
1428:
1429: -- If its Check funds, then we need to look at data from pa_bc_commitments_all
1430: Begin -- 'P' : pa_bc_packets
1431:
1432: Select 'N'
1433: into l_return_status

Line 1444: Begin -- 'P' : pa_bc_commitments_all

1440: and pbc.resource_list_member_id = pra.resource_list_member_id
1441: and pbc.period_name = p_period_name);
1442: Exception
1443: When no_data_found then
1444: Begin -- 'P' : pa_bc_commitments_all
1445: Select 'N'
1446: into l_return_status
1447: from pa_resource_assignments pra
1448: where pra.budget_version_id = p_budget_version_id

Line 1451: from pa_bc_commitments_all pbc

1447: from pa_resource_assignments pra
1448: where pra.budget_version_id = p_budget_version_id
1449: and pra.resource_assignment_id = p_resource_assignment_id
1450: and exists(select 1
1451: from pa_bc_commitments_all pbc
1452: where pbc.project_id = pra.project_id
1453: and pbc.resource_list_member_id = pra.resource_list_member_id
1454: and pbc.period_name = p_period_name);
1455: Exception

Line 1458: End; -- 'P' : pa_bc_commitments_all

1454: and pbc.period_name = p_period_name);
1455: Exception
1456: When no_data_found then
1457: return 'Y';
1458: End; -- 'P' : pa_bc_commitments_all
1459:
1460: End; -- 'P' : pa_bc_packets
1461:
1462: Else

Line 2135: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_bc_commitments_all ');

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
2139: -- closed periods.For transactions falling in open/future periods ,sweeper process will be updating

Line 2145: UPDATE pa_bc_commitments_all bccom

2141:
2142: IF l_closed_prd_exists = 'Y' THEN
2143:
2144: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2145: UPDATE pa_bc_commitments_all bccom
2146: SET bccom.budget_version_id = NVL(l_bvidTab(i), bccom.budget_version_id),
2147: bccom.budget_line_id = NVL(l_blidTab(i),bccom.budget_line_id)
2148: WHERE bccom.bc_commitment_id = l_bccomidTab(i)
2149: AND l_glprdstatustab(i) = 'C'

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

2149: AND l_glprdstatustab(i) = 'C'
2150: AND bccom.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid;
2151:
2152: IF P_DEBUG_MODE = 'Y' THEN
2153: pa_fck_util.debug_msg( 'Number of pa_bc_commitments_all updated'||SQL%ROWCOUNT);
2154: END IF;
2155:
2156: END IF; -- IF l_closed_prd_exists = 'Y' THEN
2157:

Line 2291: pa_fck_util.debug_msg( 'Updating budget_version_id and budget_line_id on pa_bc_commitments_all ');

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
2295: UPDATE pa_bc_commitments_all bccom

Line 2295: UPDATE pa_bc_commitments_all bccom

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
2295: UPDATE pa_bc_commitments_all bccom
2296: SET bccom.budget_version_id = NVL(l_bvidTab(i), bccom.budget_version_id),
2297: bccom.budget_line_id = NVL(l_blidTab(i),bccom.budget_line_id)
2298: WHERE bccom.bc_commitment_id = l_bccomidTab(i);
2299: