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

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

Line 1086: from pa_bc_packets pbb

1082: select 'Y'
1083: into g_txn_exists_for_bvid
1084: from dual
1085: where exists (select 1
1086: from pa_bc_packets pbb
1087: where pbb.project_id = g_api_project_id
1088: and pbb.status_code in ('A','P','I','Z') );
1089: Exception
1090: When no_data_found then

Line 1256: Begin -- 'L' : pa_bc_packets

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

Line 1264: from pa_bc_packets pbc

1260: from pa_resource_assignments pra
1261: where pra.budget_version_id = p_budget_version_id
1262: and pra.resource_assignment_id = p_resource_assignment_id
1263: and exists(select 1
1264: from pa_bc_packets pbc
1265: where pbc.project_id = pra.project_id
1266: and pbc.resource_list_member_id = pra.resource_list_member_id
1267: and pbc.period_name = p_period_name
1268: and pbc.task_id = pra.task_id);

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

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

Line 1314: Begin -- 'L' : pa_bc_packets

1310:
1311: Exception
1312: When no_data_found then
1313:
1314: Begin -- 'L' : pa_bc_packets
1315:
1316: Select 'N'
1317: into l_return_status
1318: from pa_resource_assignments pra

Line 1322: from pa_bc_packets pbc

1318: from pa_resource_assignments pra
1319: where pra.budget_version_id = p_budget_version_id
1320: and pra.resource_assignment_id = p_resource_assignment_id
1321: and exists(select 1
1322: from pa_bc_packets pbc
1323: where pbc.budget_version_id = pra.budget_version_id
1324: and pbc.project_id = pra.project_id
1325: and pbc.task_id = pra.task_id
1326: and pbc.resource_list_member_id = pra.resource_list_member_id

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

1328: and pbc.status_code in ('A','P') );
1329: Exception
1330: When no_data_found then
1331: return 'Y';
1332: End; -- 'L' : pa_bc_packets
1333: End; -- 'L' : pa_bc_balances
1334:
1335: End if; --Check funds or regular mode
1336:

Line 1343: Begin -- 'T' : pa_bc_packets

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

Line 1351: from pa_bc_packets pbc

1347: from pa_resource_assignments pra
1348: where pra.budget_version_id = p_budget_version_id
1349: and pra.resource_assignment_id = p_resource_assignment_id
1350: and exists(select 1
1351: from pa_bc_packets pbc
1352: where pbc.project_id = pra.project_id
1353: and pbc.resource_list_member_id = pra.resource_list_member_id
1354: and pbc.period_name = p_period_name
1355: and pbc.top_task_id = pra.task_id);

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

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
1378:
1379: Begin -- 'T' : pa_bc_balances

Line 1401: Begin -- 'T' : pa_bc_packets

1397: and pbb.balance_type <> 'BGT');
1398: Exception
1399: When no_data_found then
1400:
1401: Begin -- 'T' : pa_bc_packets
1402:
1403: Select 'N'
1404: into l_return_status
1405: from pa_resource_assignments pra

Line 1409: from pa_bc_packets pbc

1405: from pa_resource_assignments pra
1406: where pra.budget_version_id = p_budget_version_id
1407: and pra.resource_assignment_id = p_resource_assignment_id
1408: and exists(select 1
1409: from pa_bc_packets pbc
1410: where pbc.budget_version_id = pra.budget_version_id
1411: and pbc.project_id = pra.project_id
1412: and pbc.top_task_id = pra.task_id
1413: and pbc.resource_list_member_id = pra.resource_list_member_id

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

1415: and pbc.status_code in ('A','P') );
1416: Exception
1417: When no_data_found then
1418: return 'Y';
1419: End; -- 'T' : pa_bc_packets
1420: End; -- 'T' : pa_bc_balances
1421:
1422: End If; -- checkfunds or regular mode
1423:

Line 1430: Begin -- 'P' : pa_bc_packets

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

Line 1438: from pa_bc_packets pbc

1434: from pa_resource_assignments pra
1435: where pra.budget_version_id = p_budget_version_id
1436: and pra.resource_assignment_id = p_resource_assignment_id
1437: and exists(select 1
1438: from pa_bc_packets pbc
1439: where pbc.project_id = pra.project_id
1440: and pbc.resource_list_member_id = pra.resource_list_member_id
1441: and pbc.period_name = p_period_name);
1442: Exception

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

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
1463:
1464: Begin -- 'P' : pa_bc_balances

Line 1486: Begin -- 'P' : pa_bc_packets

1482:
1483: Exception
1484: When no_data_found then
1485:
1486: Begin -- 'P' : pa_bc_packets
1487:
1488: Select 'N'
1489: into l_return_status
1490: from pa_resource_assignments pra

Line 1494: from pa_bc_packets pbc

1490: from pa_resource_assignments pra
1491: where pra.budget_version_id = p_budget_version_id
1492: and pra.resource_assignment_id = p_resource_assignment_id
1493: and exists(select 1
1494: from pa_bc_packets pbc
1495: where pbc.budget_version_id = pra.budget_version_id
1496: and pbc.project_id = pra.project_id
1497: and pbc.resource_list_member_id = pra.resource_list_member_id
1498: and pbc.period_name = p_period_name

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

1499: and pbc.status_code in ('A','P') );
1500: Exception
1501: When no_data_found then
1502: return 'Y';
1503: End; -- 'P' : pa_bc_packets
1504: End; -- 'P' : pa_bc_balances
1505:
1506: End if; -- checkfunds or normal mode
1507:

Line 1585: from pa_bc_packets pbc

1581: Select 'N'
1582: into l_allowed_flag
1583: from dual
1584: where exists(select 1
1585: from pa_bc_packets pbc
1586: where pbc.budget_version_id = p_budget_version_id
1587: and pbc.bud_task_id = p_task_id
1588: and pbc.bud_resource_list_member_id = p_resource_list_member_id
1589: and pbc.period_name = p_period_name

Line 1617: from pa_bc_packets pbc

1613: Select 'N'
1614: into l_allowed_flag
1615: from dual
1616: where exists(select 1
1617: from pa_bc_packets pbc
1618: where pbc.budget_version_id = p_budget_version_id
1619: and pbc.bud_task_id = p_top_task_id
1620: and pbc.bud_resource_list_member_id = p_resource_list_member_id
1621: and pbc.period_name = p_period_name

Line 1648: from pa_bc_packets pbc

1644: Select 'N'
1645: into l_allowed_flag
1646: from dual
1647: where exists(select 1
1648: from pa_bc_packets pbc
1649: where pbc.budget_version_id = p_budget_version_id
1650: and pbc.bud_resource_list_member_id = p_resource_list_member_id
1651: and pbc.period_name = p_period_name
1652: and pbc.status_code in ('A','P','I','Z') );

Line 1672: from pa_bc_packets pbc

1668: Select 'N'
1669: into l_allowed_flag
1670: from dual
1671: where exists(select 1
1672: from pa_bc_packets pbc
1673: where pbc.budget_version_id = p_budget_version_id
1674: and pbc.bud_task_id = p_task_id
1675: and pbc.bud_resource_list_member_id = p_resource_list_member_id
1676: and pbc.period_name = p_period_name

Line 1704: from pa_bc_packets pbc

1700: Select 'N'
1701: into l_allowed_flag
1702: from dual
1703: where exists(select 1
1704: from pa_bc_packets pbc
1705: where pbc.budget_version_id = p_budget_version_id
1706: and pbc.bud_task_id = p_top_task_id
1707: and pbc.bud_resource_list_member_id = p_resource_list_member_id
1708: and pbc.period_name = p_period_name

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_resource_list_member_id = p_resource_list_member_id
1739: and pbc.period_name = p_period_name
1740: and pbc.status_code = 'A');

Line 1912: from pa_bc_packets bc

1908: NULL entry_level_code, -- Required only for closed period transactions
1909: bc.budget_version_id,
1910: bc.budget_line_id,
1911: NULL gl_period_status -- Required only for closed period transactions
1912: from pa_bc_packets bc
1913: WHERE bc.budget_version_id = p_bud_ver_id -- current baselined version id
1914: AND bc.status_code ='A'
1915: -- Parent bc packet id will be -99 for BTC and CWK lines --check logic in PA_BGT_BASELINE_PKG
1916: AND NVL(bc.parent_bc_packet_id,-99) = -99

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

1979: FROM dual
1980: WHERE l_closed_prd_exists = 'Y');
1981:
1982:
1983: l_ccid pa_bc_packets.budget_ccid%type := null;
1984: l_error_message_code varchar2(200) := null;
1985: l_return_status varchar2(10) := 'S';
1986:
1987: PROCEDURE Intialize_plsql_tables IS

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

2049: l_glprdstatustab
2050: LIMIT 500;
2051:
2052: IF P_DEBUG_MODE = 'Y' THEN
2053: pa_fck_util.debug_msg('Number of records fetched from pa_bc_packets ='||l_DocHdrTab.count);
2054: END IF;
2055:
2056: FOR i in 1..l_DocHdrTab.count LOOP
2057: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));

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

2188: l_glprdstatustab
2189: LIMIT 500;
2190:
2191: IF P_DEBUG_MODE = 'Y' THEN
2192: pa_fck_util.debug_msg('Number of records fetched from pa_bc_packets ='||l_DocHdrTab.count);
2193: END IF;
2194:
2195: FOR i in 1..l_DocHdrTab.count LOOP
2196: pa_fck_util.debug_msg('Value of l_DocHdrTab ('||i||')='||l_DocHdrTab(i));