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_PACKETS

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

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: -- -----------------------------------------------------------------------------------------+
1150: FUNCTION Is_account_change_allowed (P_budget_version_id IN Number,
1151: P_resource_assignment_id IN Number,

Line 1237: from pa_bc_packets pbb

1233: select 'Y'
1234: into g_txn_exists_for_bvid
1235: from dual
1236: where exists (select 1
1237: from pa_bc_packets pbb
1238: where pbb.project_id = g_api_project_id
1239: and pbb.status_code in ('A','P','I','Z') );
1240: Exception
1241: When no_data_found then

Line 1407: Begin -- 'L' : pa_bc_packets

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
1411: from pa_resource_assignments pra

Line 1415: from pa_bc_packets pbc

1411: from pa_resource_assignments pra
1412: where pra.budget_version_id = p_budget_version_id
1413: and pra.resource_assignment_id = p_resource_assignment_id
1414: and exists(select 1
1415: from pa_bc_packets pbc
1416: where pbc.project_id = pra.project_id
1417: and pbc.resource_list_member_id = pra.resource_list_member_id
1418: and pbc.period_name = p_period_name
1419: and pbc.task_id = pra.task_id);

Line 1438: End; -- 'L' : pa_bc_packets

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:
1442: Begin -- 'L' : pa_bc_balances

Line 1465: Begin -- 'L' : pa_bc_packets

1461:
1462: Exception
1463: When no_data_found then
1464:
1465: Begin -- 'L' : pa_bc_packets
1466:
1467: Select 'N'
1468: into l_return_status
1469: from pa_resource_assignments pra

Line 1473: from pa_bc_packets pbc

1469: from pa_resource_assignments pra
1470: where pra.budget_version_id = p_budget_version_id
1471: and pra.resource_assignment_id = p_resource_assignment_id
1472: and exists(select 1
1473: from pa_bc_packets pbc
1474: where pbc.budget_version_id = pra.budget_version_id
1475: and pbc.project_id = pra.project_id
1476: and pbc.task_id = pra.task_id
1477: and pbc.resource_list_member_id = pra.resource_list_member_id

Line 1483: End; -- 'L' : pa_bc_packets

1479: and pbc.status_code in ('A','P') );
1480: Exception
1481: When no_data_found then
1482: return 'Y';
1483: End; -- 'L' : pa_bc_packets
1484: End; -- 'L' : pa_bc_balances
1485:
1486: End if; --Check funds or regular mode
1487:

Line 1494: Begin -- 'T' : pa_bc_packets

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
1498: from pa_resource_assignments pra

Line 1502: from pa_bc_packets pbc

1498: from pa_resource_assignments pra
1499: where pra.budget_version_id = p_budget_version_id
1500: and pra.resource_assignment_id = p_resource_assignment_id
1501: and exists(select 1
1502: from pa_bc_packets pbc
1503: where pbc.project_id = pra.project_id
1504: and pbc.resource_list_member_id = pra.resource_list_member_id
1505: and pbc.period_name = p_period_name
1506: and pbc.top_task_id = pra.task_id);

Line 1526: End; -- 'T' : pa_bc_packets

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
1529:
1530: Begin -- 'T' : pa_bc_balances

Line 1552: Begin -- 'T' : pa_bc_packets

1548: and pbb.balance_type <> 'BGT');
1549: Exception
1550: When no_data_found then
1551:
1552: Begin -- 'T' : pa_bc_packets
1553:
1554: Select 'N'
1555: into l_return_status
1556: from pa_resource_assignments pra

Line 1560: from pa_bc_packets pbc

1556: from pa_resource_assignments pra
1557: where pra.budget_version_id = p_budget_version_id
1558: and pra.resource_assignment_id = p_resource_assignment_id
1559: and exists(select 1
1560: from pa_bc_packets pbc
1561: where pbc.budget_version_id = pra.budget_version_id
1562: and pbc.project_id = pra.project_id
1563: and pbc.top_task_id = pra.task_id
1564: and pbc.resource_list_member_id = pra.resource_list_member_id

Line 1570: End; -- 'T' : pa_bc_packets

1566: and pbc.status_code in ('A','P') );
1567: Exception
1568: When no_data_found then
1569: return 'Y';
1570: End; -- 'T' : pa_bc_packets
1571: End; -- 'T' : pa_bc_balances
1572:
1573: End If; -- checkfunds or regular mode
1574:

Line 1581: Begin -- 'P' : pa_bc_packets

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
1585: from pa_resource_assignments pra

Line 1589: from pa_bc_packets pbc

1585: from pa_resource_assignments pra
1586: where pra.budget_version_id = p_budget_version_id
1587: and pra.resource_assignment_id = p_resource_assignment_id
1588: and exists(select 1
1589: from pa_bc_packets pbc
1590: where pbc.project_id = pra.project_id
1591: and pbc.resource_list_member_id = pra.resource_list_member_id
1592: and pbc.period_name = p_period_name);
1593: Exception

Line 1611: End; -- 'P' : pa_bc_packets

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
1614:
1615: Begin -- 'P' : pa_bc_balances

Line 1637: Begin -- 'P' : pa_bc_packets

1633:
1634: Exception
1635: When no_data_found then
1636:
1637: Begin -- 'P' : pa_bc_packets
1638:
1639: Select 'N'
1640: into l_return_status
1641: from pa_resource_assignments pra

Line 1645: from pa_bc_packets pbc

1641: from pa_resource_assignments pra
1642: where pra.budget_version_id = p_budget_version_id
1643: and pra.resource_assignment_id = p_resource_assignment_id
1644: and exists(select 1
1645: from pa_bc_packets pbc
1646: where pbc.budget_version_id = pra.budget_version_id
1647: and pbc.project_id = pra.project_id
1648: and pbc.resource_list_member_id = pra.resource_list_member_id
1649: and pbc.period_name = p_period_name

Line 1654: End; -- 'P' : pa_bc_packets

1650: and pbc.status_code in ('A','P') );
1651: Exception
1652: When no_data_found then
1653: return 'Y';
1654: End; -- 'P' : pa_bc_packets
1655: End; -- 'P' : pa_bc_balances
1656:
1657: End if; -- checkfunds or normal mode
1658:

Line 1736: from pa_bc_packets pbc

1732: Select 'N'
1733: into l_allowed_flag
1734: from dual
1735: where exists(select 1
1736: from pa_bc_packets pbc
1737: where pbc.budget_version_id = p_budget_version_id
1738: and pbc.bud_task_id = p_task_id
1739: and pbc.bud_resource_list_member_id = p_resource_list_member_id
1740: and pbc.period_name = p_period_name

Line 1768: from pa_bc_packets pbc

1764: Select 'N'
1765: into l_allowed_flag
1766: from dual
1767: where exists(select 1
1768: from pa_bc_packets pbc
1769: where pbc.budget_version_id = p_budget_version_id
1770: and pbc.bud_task_id = p_top_task_id
1771: and pbc.bud_resource_list_member_id = p_resource_list_member_id
1772: and pbc.period_name = p_period_name

Line 1799: from pa_bc_packets pbc

1795: Select 'N'
1796: into l_allowed_flag
1797: from dual
1798: where exists(select 1
1799: from pa_bc_packets pbc
1800: where pbc.budget_version_id = p_budget_version_id
1801: and pbc.bud_resource_list_member_id = p_resource_list_member_id
1802: and pbc.period_name = p_period_name
1803: and pbc.status_code in ('A','P','I','Z') );

Line 1823: from pa_bc_packets pbc

1819: Select 'N'
1820: into l_allowed_flag
1821: from dual
1822: where exists(select 1
1823: from pa_bc_packets pbc
1824: where pbc.budget_version_id = p_budget_version_id
1825: and pbc.bud_task_id = p_task_id
1826: and pbc.bud_resource_list_member_id = p_resource_list_member_id
1827: and pbc.period_name = p_period_name

Line 1855: from pa_bc_packets pbc

1851: Select 'N'
1852: into l_allowed_flag
1853: from dual
1854: where exists(select 1
1855: from pa_bc_packets pbc
1856: where pbc.budget_version_id = p_budget_version_id
1857: and pbc.bud_task_id = p_top_task_id
1858: and pbc.bud_resource_list_member_id = p_resource_list_member_id
1859: and pbc.period_name = p_period_name

Line 1887: from pa_bc_packets pbc

1883: Select 'N'
1884: into l_allowed_flag
1885: from dual
1886: where exists(select 1
1887: from pa_bc_packets pbc
1888: where pbc.budget_version_id = p_budget_version_id
1889: and pbc.bud_resource_list_member_id = p_resource_list_member_id
1890: and pbc.period_name = p_period_name
1891: and pbc.status_code = 'A');

Line 2063: from pa_bc_packets bc

2059: NULL entry_level_code, -- Required only for closed period transactions
2060: bc.budget_version_id,
2061: bc.budget_line_id,
2062: NULL gl_period_status -- Required only for closed period transactions
2063: from pa_bc_packets bc
2064: WHERE bc.budget_version_id = p_bud_ver_id -- current baselined version id
2065: AND bc.status_code ='A'
2066: -- Parent bc packet id will be -99 for BTC and CWK lines --check logic in PA_BGT_BASELINE_PKG
2067: AND NVL(bc.parent_bc_packet_id,-99) = -99

Line 2134: l_ccid pa_bc_packets.budget_ccid%type := null;

2130: FROM dual
2131: WHERE l_closed_prd_exists = 'Y');
2132:
2133:
2134: l_ccid pa_bc_packets.budget_ccid%type := null;
2135: l_error_message_code varchar2(200) := null;
2136: l_return_status varchar2(10) := 'S';
2137:
2138: PROCEDURE Intialize_plsql_tables IS

Line 2204: pa_fck_util.debug_msg('Number of records fetched from pa_bc_packets ='||l_DocHdrTab.count);

2200: l_glprdstatustab
2201: LIMIT 500;
2202:
2203: IF P_DEBUG_MODE = 'Y' THEN
2204: pa_fck_util.debug_msg('Number of records fetched from pa_bc_packets ='||l_DocHdrTab.count);
2205: END IF;
2206:
2207: FOR i in 1..l_DocHdrTab.count LOOP
2208: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));

Line 2343: pa_fck_util.debug_msg('Number of records fetched from pa_bc_packets ='||l_DocHdrTab.count);

2339: l_glprdstatustab
2340: LIMIT 500;
2341:
2342: IF P_DEBUG_MODE = 'Y' THEN
2343: pa_fck_util.debug_msg('Number of records fetched from pa_bc_packets ='||l_DocHdrTab.count);
2344: END IF;
2345:
2346: FOR i in 1..l_DocHdrTab.count LOOP
2347: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));