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_BGT_BASELINE_PKG dependencies on PA_BC_PACKETS

Line 39: --then we have to delete from pa_bc_packets all the transactions that were created

35: where project_id = p_project_id
36: for update nowait;
37:
38: --When baselining errors with oracle error, insufficient funds and if user rebaselines
39: --then we have to delete from pa_bc_packets all the transactions that were created
40: --during the first baseline. The cursor below is for this purpose
41: -- R12 Funds Management Uptake : Obsolete logic with new architecture
42:
43: --Cursor to update status code from C to A for packets that have been funds checked

Line 48: -- procedure to create pa_bc_balances records from PA_BUDGET_LINES and to clean up PA_BC_PACKETS

44: --before the budget baselining notification was approved
45: -- R12 Funds Management Uptake : Obsolete cursor c_updsts with new architecture
46:
47: ---------------------------------------------------------------------------------------------
48: -- procedure to create pa_bc_balances records from PA_BUDGET_LINES and to clean up PA_BC_PACKETS
49: /* ========================================================================================== +
50: FOLLOWING CODE MOVED TO PA_BUDGET_FUND_PKG (PABBFNDB.pls)
51:
52: PROCEDURE INSERT_BGT_BALANCES(

Line 668: -- into pa_bc_packets for funds check

664: END is_fc_required;
665: -------------------------------------------------------------------------------
666:
667: -- procedure to load all the vendor invoices, expense reports and BTC transactions
668: -- into pa_bc_packets for funds check
669: PROCEDURE INSERT_VI_ER_BTC_TXNS(
670: p_packet_id IN NUMBER,
671: p_sob_id IN NUMBER,
672: p_project_id IN NUMBER,

Line 1202: insert into pa_bc_packets (

1198: IF P_DEBUG_MODE = 'Y' THEN
1199: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'Before inserting VIERBTC');
1200: END IF;
1201: FORALL m in l_ExpProjTab.FIRST..l_ExpProjTab.LAST
1202: insert into pa_bc_packets (
1203: PACKET_ID,
1204: PROJECT_ID,
1205: TASK_ID,
1206: EXPENDITURE_TYPE,

Line 1274: pa_bc_packets_s.nextval,

1270: l_ExpEntCrTab(m),
1271: l_ExpAcctDrTab(m),
1272: l_ExpAcctCrTab(m),
1273: p_budget_version_id,
1274: pa_bc_packets_s.nextval,
1275: 'B',
1276: --PA.M insert parent bc pkt as -99 for CWK BTC EIs
1277: --null,
1278: l_ExpParBcPktIdTab(m),

Line 1325: -- procedure to load all commitment transactions in pa_bc_packets for funds check

1321: RAISE;
1322: END INSERT_VI_ER_BTC_TXNS;
1323: ---------------------------------------------------------------------------------------------
1324:
1325: -- procedure to load all commitment transactions in pa_bc_packets for funds check
1326: PROCEDURE INSERT_COMMITMENT_TXNS(
1327: p_packet_id IN NUMBER,
1328: p_sob_id IN NUMBER,
1329: p_project_id IN NUMBER,

Line 1533: --pa_bc_packets. Also if budget is linked then consider only open period

1529: exit;
1530: END IF;
1531:
1532: --If budgetary control type is CC, then load only contract commitment transactions into
1533: --pa_bc_packets. Also if budget is linked then consider only open period
1534: --transactions else consider all transactions.
1535: IF P_DEBUG_MODE = 'Y' THEN
1536: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'No. of rec in c_bc_comm = '|| l_ProjTab.count);
1537: END IF;

Line 1554: insert into pa_bc_packets (

1550: IF P_DEBUG_MODE = 'Y' THEN
1551: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'Bdgt Intg Flag = Y');
1552: END IF;
1553: FORALL i in l_ProjTab.FIRST..l_ProjTab.LAST
1554: insert into pa_bc_packets (
1555: PACKET_ID,
1556: PROJECT_ID,
1557: TASK_ID,
1558: EXPENDITURE_TYPE,

Line 1675: insert into pa_bc_packets (

1671: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'Bdgt Intg Flag = N');
1672: END IF;
1673:
1674: FORALL j in l_ProjTab.FIRST..l_ProjTab.LAST
1675: insert into pa_bc_packets (
1676: PACKET_ID,
1677: PROJECT_ID,
1678: TASK_ID,
1679: EXPENDITURE_TYPE,

Line 1786: --(AP, PO, REQ, Contract Payments) into pa_bc_packets.

1782: END IF;
1783: PA_DEBUG.Reset_Err_Stack; --3912094
1784:
1785: --If budgetary control type is GL, then load all commitment transactions
1786: --(AP, PO, REQ, Contract Payments) into pa_bc_packets.
1787: --Also check if budget is linked then consider only open period
1788: --transactions else consider all transactions.
1789: ELSIF (p_bdgt_ctrl_type = ('GL')) THEN
1790:

Line 1806: insert into pa_bc_packets (

1802:
1803: --For Other commitment transactions (AP,PO,REQ,CC_P_PAY,CC_C_PAY)
1804: --when there is a link
1805: FORALL k in l_ProjTab.FIRST..l_ProjTab.LAST
1806: insert into pa_bc_packets (
1807: PACKET_ID,
1808: PROJECT_ID,
1809: TASK_ID,
1810: EXPENDITURE_TYPE,

Line 1928: insert into pa_bc_packets (

1924:
1925: --For Other commitment transactions (AP,PO,REQ,CC_C_PAY,CC_P_PAY)
1926: --when there is a link
1927: FORALL l in l_ProjTab.FIRST..l_ProjTab.LAST
1928: insert into pa_bc_packets (
1929: PACKET_ID,
1930: PROJECT_ID,
1931: TASK_ID,
1932: EXPENDITURE_TYPE,

Line 2110: --pa_bc_packets

2106: /* =============================================================================================== +
2107: FOLLOWING CODE MOVED TO PA_BUDGET_FUND_PKG (PABBFNDB.pls)
2108:
2109: --Before start of baselining call sweeper to sweep approved packets sitting in
2110: --pa_bc_packets
2111: --Bug 2779986: Run sweeper irrespective of the p_bdgt_ctrl_type
2112: --Revert Bug 2779986 fix: Sweeper process is to be run only the first time this API is
2113: --called from PA_BUDGET_FUNDS_PKG. There are 2 calls to this API, first for
2114: --for p_bdgt_ctrl_type = GL and then for p_bdgt_ctrl_type = CC, hence running the

Line 2168: -- lying in pa_bc_packets and sweeper will clean the 'R' and 'T' status records.

2164: -- if user rebaselines.
2165: -- With new architecture baselining is performed before fundscheck and fundscheck
2166: -- is fired only during baselining for the newly baselined version.If fundscheck fails
2167: -- then baselining will be rolled back and hence there wont be any 'B' status data
2168: -- lying in pa_bc_packets and sweeper will clean the 'R' and 'T' status records.
2169:
2170: -- R12 Funds Management Uptake : Removed check of 'IF fc required'
2171:
2172: -- Get a new packet id

Line 2181: -- Insert commitments into PA_BC_PACKETS

2177: END IF;
2178:
2179: PA_DEBUG.set_err_stack('M:Create Dir Cost');
2180:
2181: -- Insert commitments into PA_BC_PACKETS
2182: IF P_DEBUG_MODE = 'Y' THEN
2183: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'Calling Insert Commitment Txns');
2184: END IF;
2185:

Line 2288: -- R12 Funds Management Uptake : Added below update for updating pa_bc_packets with

2284:
2285: -- R12 Funds Management Uptake : Deleted call to PA_FUNDS_CONTROL_PKG.upd_bdgt_encum_bal
2286: -- as it will be fired during tieback .
2287:
2288: -- R12 Funds Management Uptake : Added below update for updating pa_bc_packets with
2289: -- uncommited newly created budget version id.
2290:
2291: If l_return_status not in ('F','T') then
2292:

Line 2293: UPDATE pa_bc_packets

2289: -- uncommited newly created budget version id.
2290:
2291: If l_return_status not in ('F','T') then
2292:
2293: UPDATE pa_bc_packets
2294: SET budget_version_id = p_baselined_budget_version_id
2295: WHERE packet_id = l_packet_id
2296: AND budget_version_id = p_budget_version_id;
2297: