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 1145: -- Check if txn exists in pa_bc_packets or in pa_bc_commitments_all

1141: -- #against a budget line, else it will return 'Y'.
1142:
1143: -- # Code flow is as follows for each of the BEM: Lowest Task/Top Task/Project Level
1144: -- # If API called through Check funds or form
1145: -- Check if txn exists in pa_bc_packets or in pa_bc_commitments_all
1146: -- Elsif API called during Baseline/YearEnd
1147: -- Check if txn exists in pa_bc_balances or pa_bc_packets
1148: -- # For baseline/yearend , we're using bc_balances to increase performance ..
1149: -- -----------------------------------------------------------------------------------------+

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

1402: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then
1403: -- CHECK_FUNDS/THROUGH FORM ..this if condition ..
1404: -- BASELINE/YEAR_END ..else part ..
1405:
1406: -- If its Check funds, then we need to look at data from pa_bc_commitments_all
1407: Begin -- 'L' : pa_bc_packets
1408:
1409: Select 'N'
1410: into l_return_status

Line 1422: Begin -- 'L' : pa_bc_commitments_all

1418: and pbc.period_name = p_period_name
1419: and pbc.task_id = pra.task_id);
1420: Exception
1421: When no_data_found then
1422: Begin -- 'L' : pa_bc_commitments_all
1423: Select 'N'
1424: into l_return_status
1425: from pa_resource_assignments pra
1426: where pra.budget_version_id = p_budget_version_id

Line 1429: from pa_bc_commitments_all pbc

1425: from pa_resource_assignments pra
1426: where pra.budget_version_id = p_budget_version_id
1427: and pra.resource_assignment_id = p_resource_assignment_id
1428: and exists(select 1
1429: from pa_bc_commitments_all pbc
1430: where pbc.project_id = pra.project_id
1431: and pbc.resource_list_member_id = pra.resource_list_member_id
1432: and pbc.period_name = p_period_name
1433: and pbc.task_id = pra.task_id);

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

1433: and pbc.task_id = pra.task_id);
1434: Exception
1435: When no_data_found then
1436: return 'Y';
1437: End; -- 'L' : pa_bc_commitments_all
1438: End; -- 'L' : pa_bc_packets
1439:
1440: Else
1441:

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

1489: ElsIf l_budget_entry_level_code = 'T' then
1490:
1491: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then
1492:
1493: -- If its Check funds, then we need to look at data from pa_bc_commitments_all
1494: Begin -- 'T' : pa_bc_packets
1495:
1496: Select 'N'
1497: into l_return_status

Line 1509: Begin -- 'T' : pa_bc_commitments_all

1505: and pbc.period_name = p_period_name
1506: and pbc.top_task_id = pra.task_id);
1507: Exception
1508: When no_data_found then
1509: Begin -- 'T' : pa_bc_commitments_all
1510: Select 'N'
1511: into l_return_status
1512: from pa_resource_assignments pra
1513: where pra.budget_version_id = p_budget_version_id

Line 1516: from pa_bc_commitments_all pbc

1512: from pa_resource_assignments pra
1513: where pra.budget_version_id = p_budget_version_id
1514: and pra.resource_assignment_id = p_resource_assignment_id
1515: and exists(select 1
1516: from pa_bc_commitments_all pbc
1517: where pbc.project_id = pra.project_id
1518: and pbc.resource_list_member_id = pra.resource_list_member_id
1519: and pbc.period_name = p_period_name
1520: and pbc.top_task_id = pra.task_id);

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

1520: and pbc.top_task_id = pra.task_id);
1521: Exception
1522: When no_data_found then
1523: return 'Y';
1524: End; -- 'T' : pa_bc_commitments_all
1525:
1526: End; -- 'T' : pa_bc_packets
1527:
1528: Else

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

1576: ElsIf l_budget_entry_level_code = 'P' then
1577:
1578: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then
1579:
1580: -- If its Check funds, then we need to look at data from pa_bc_commitments_all
1581: Begin -- 'P' : pa_bc_packets
1582:
1583: Select 'N'
1584: into l_return_status

Line 1595: Begin -- 'P' : pa_bc_commitments_all

1591: and pbc.resource_list_member_id = pra.resource_list_member_id
1592: and pbc.period_name = p_period_name);
1593: Exception
1594: When no_data_found then
1595: Begin -- 'P' : pa_bc_commitments_all
1596: Select 'N'
1597: into l_return_status
1598: from pa_resource_assignments pra
1599: where pra.budget_version_id = p_budget_version_id

Line 1602: from pa_bc_commitments_all pbc

1598: from pa_resource_assignments pra
1599: where pra.budget_version_id = p_budget_version_id
1600: and pra.resource_assignment_id = p_resource_assignment_id
1601: and exists(select 1
1602: from pa_bc_commitments_all pbc
1603: where pbc.project_id = pra.project_id
1604: and pbc.resource_list_member_id = pra.resource_list_member_id
1605: and pbc.period_name = p_period_name);
1606: Exception

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

1605: and pbc.period_name = p_period_name);
1606: Exception
1607: When no_data_found then
1608: return 'Y';
1609: End; -- 'P' : pa_bc_commitments_all
1610:
1611: End; -- 'P' : pa_bc_packets
1612:
1613: Else

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

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

Line 2296: UPDATE pa_bc_commitments_all bccom

2292:
2293: IF l_closed_prd_exists = 'Y' THEN
2294:
2295: FORALL i in l_DocHdrTab.first..l_DocHdrTab.last
2296: UPDATE pa_bc_commitments_all bccom
2297: SET bccom.budget_version_id = NVL(l_bvidTab(i), bccom.budget_version_id),
2298: bccom.budget_line_id = NVL(l_blidTab(i),bccom.budget_line_id)
2299: WHERE bccom.bc_commitment_id = l_bccomidTab(i)
2300: AND l_glprdstatustab(i) = 'C'

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

2300: AND l_glprdstatustab(i) = 'C'
2301: AND bccom.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid;
2302:
2303: IF P_DEBUG_MODE = 'Y' THEN
2304: pa_fck_util.debug_msg( 'Number of pa_bc_commitments_all updated'||SQL%ROWCOUNT);
2305: END IF;
2306:
2307: END IF; -- IF l_closed_prd_exists = 'Y' THEN
2308:

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

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

Line 2446: UPDATE pa_bc_commitments_all bccom

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
2446: UPDATE pa_bc_commitments_all bccom
2447: SET bccom.budget_version_id = NVL(l_bvidTab(i), bccom.budget_version_id),
2448: bccom.budget_line_id = NVL(l_blidTab(i),bccom.budget_line_id)
2449: WHERE bccom.bc_commitment_id = l_bccomidTab(i);
2450: