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

Line 32: g_packet_id pa_bc_packets.packet_id%TYPE;

28: AND PBA.budget_version_id = c_budget_version_id) ;
29:
30:
31: -- For R12 Start ------------------------------------------------+
32: g_packet_id pa_bc_packets.packet_id%TYPE;
33: g_msg_data VARCHAR2(1000);
34: g_procedure_name VARCHAR2(30);
35: g_debug_mode VARCHAR2(10);
36: g_draft_bvid pa_budget_versions.budget_version_id%type;

Line 104: l_result_code pa_bc_packets.result_code%TYPE;

100: l_last_update_login NUMBER(15);
101: l_call_mode VARCHAR2(1) ;
102: l_ret_code boolean ;
103: --l_result_code IGC_CC_INTERFACE.cbc_result_code%TYPE;
104: l_result_code pa_bc_packets.result_code%TYPE;
105: l_return_status VARCHAR2(100) ;
106: l_msg_index_out NUMBER ;
107: l_chk_res_unres_multi NUMBER ;
108:

Line 496: -- Bug 5379210 : Deleting pa_bc_packets for draft version

492:
493: -- -------------------------------------------------------------------------------------------------+
494: IF (g_processing_mode = 'BASELINE' and g_cost_rebaseline_flag = 'Y') then -- II
495:
496: -- Bug 5379210 : Deleting pa_bc_packets for draft version
497: Delete pa_bc_packets
498: where budget_version_id = p_draft_budget_version_id;
499:
500: log_message('Create_txn_lines_in_bc_balance:'||SQL%ROWCOUNT||' records deleted from pa_bc_packets');

Line 497: Delete pa_bc_packets

493: -- -------------------------------------------------------------------------------------------------+
494: IF (g_processing_mode = 'BASELINE' and g_cost_rebaseline_flag = 'Y') then -- II
495:
496: -- Bug 5379210 : Deleting pa_bc_packets for draft version
497: Delete pa_bc_packets
498: where budget_version_id = p_draft_budget_version_id;
499:
500: log_message('Create_txn_lines_in_bc_balance:'||SQL%ROWCOUNT||' records deleted from pa_bc_packets');
501:

Line 500: log_message('Create_txn_lines_in_bc_balance:'||SQL%ROWCOUNT||' records deleted from pa_bc_packets');

496: -- Bug 5379210 : Deleting pa_bc_packets for draft version
497: Delete pa_bc_packets
498: where budget_version_id = p_draft_budget_version_id;
499:
500: log_message('Create_txn_lines_in_bc_balance:'||SQL%ROWCOUNT||' records deleted from pa_bc_packets');
501:
502: log_message('Create_txn_lines_in_bc_balance: Last baselined version:'||g_cost_prev_bvid);
503:
504: --If there is a baselined version then we delete balance records for versions prior to this version

Line 1300: -- 6.A: Delete data from pa_bc_packets for the draft version ..

1296:
1297: log_message('Reserve Baseline Mode');
1298:
1299: -- --------------------------------------------------------------+
1300: -- 6.A: Delete data from pa_bc_packets for the draft version ..
1301: -- Basically, data will exist if prev. baseline failed
1302: -- --------------------------------------------------------------+
1303: If (p_calling_mode = 'RESERVE_BASELINE' and g_cost_rebaseline_flag ='Y') then
1304: log_message('Calling Delete draft bc pkt');

Line 1358: -- Update pa_bc_packets.status_code = 'A'

1354: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1355: RAISE l_budget_processing_failure ;
1356: Else
1357:
1358: -- Update pa_bc_packets.status_code = 'A'
1359: Update_bc_packets_pass(p_bud_ver_id => p_budget_version_id);
1360: -- Bug 5206537 : Procedure to stamp latest budget version id and budget line id on CDL
1361: PA_FUNDS_CONTROL_UTILS.Update_bvid_blid_on_cdl_bccom ( p_bud_ver_id => p_budget_version_id,
1362: p_calling_mode => p_calling_mode);

Line 1541: -- Update pa_bc_packets.status_code = 'A' .. as the last step ..

1537: l_msg_data := g_msg_data;
1538: RAISE l_top_down_bdgt_failed;
1539: END IF;
1540:
1541: -- Update pa_bc_packets.status_code = 'A' .. as the last step ..
1542: Update_bc_packets_pass(p_bud_ver_id => p_budget_version_id);
1543: -- Bug 5206537 : Procedure to stamp latest budget version id and budget line id on CDL
1544: PA_FUNDS_CONTROL_UTILS.Update_bvid_blid_on_cdl_bccom ( p_bud_ver_id => p_budget_version_id,
1545: p_calling_mode => p_calling_mode);

Line 2005: -- Fail pa_bc_packets for Cost and Commitment budget ..

2001: x_return_status => x_return_status,
2002: x_msg_count => x_msg_count,
2003: x_msg_data => x_msg_data);
2004:
2005: -- Fail pa_bc_packets for Cost and Commitment budget ..
2006: -- Fail pa_bc_packets for Cost budget ..
2007: Update_bc_packets_fail(p_bud_ver_id => l_draft_budget_version_id,
2008: p_status_code => 'R');
2009: Update_bc_packets_fail(p_bud_ver_id =>l_cc_budget_version_id,

Line 2006: -- Fail pa_bc_packets for Cost budget ..

2002: x_msg_count => x_msg_count,
2003: x_msg_data => x_msg_data);
2004:
2005: -- Fail pa_bc_packets for Cost and Commitment budget ..
2006: -- Fail pa_bc_packets for Cost budget ..
2007: Update_bc_packets_fail(p_bud_ver_id => l_draft_budget_version_id,
2008: p_status_code => 'R');
2009: Update_bc_packets_fail(p_bud_ver_id =>l_cc_budget_version_id,
2010: p_status_code=>'R');

Line 2603: -- from pa_bc_packets for the "draft version" (meaning if re-baseline had earlier failed)

2599: -- ------------------------------------------------------------------------------+
2600:
2601: -- ---------------------------------------------------------------------------------------------------+
2602: -- This procedure will be called during a recosting scenario to clean up date
2603: -- from pa_bc_packets for the "draft version" (meaning if re-baseline had earlier failed)
2604: -- bug reference for this fix: 5253834
2605: -- ---------------------------------------------------------------------------------------------------+
2606: PROCEDURE Delete_draft_bc_packets(p_draft_bud_ver_id IN NUMBER)
2607: IS

Line 2613: Delete from pa_bc_packets where budget_version_id = p_draft_bud_ver_id;

2609: BEGIN
2610: g_procedure_name := 'Delete_draft_bc_packets';
2611: log_message( 'Before delete');
2612:
2613: Delete from pa_bc_packets where budget_version_id = p_draft_bud_ver_id;
2614:
2615: log_message( 'After delete');
2616:
2617: COMMIT;

Line 2621: -- ## Following procedure will update pa_bc_packets status

2617: COMMIT;
2618: END;
2619:
2620: -- ----------------------------------------------------------------+
2621: -- ## Following procedure will update pa_bc_packets status
2622: -- ----------------------------------------------------------------+
2623: PROCEDURE Update_bc_packets_pass(p_bud_ver_id IN NUMBER)
2624: IS
2625: BEGIN

Line 2630: Update pa_bc_packets

2626:
2627: g_procedure_name := 'Update_bc_packets_pass';
2628: log_message( 'Before bcpkt update');
2629:
2630: Update pa_bc_packets
2631: set status_code = 'A'
2632: where budget_version_id = p_bud_ver_id;
2633:
2634: log_message(SQL%ROWCOUNT||' records updated');

Line 2651: Update pa_bc_packets

2647:
2648: g_procedure_name := 'Update_bc_packets_fail';
2649: log_message( 'Before bcpkt update');
2650:
2651: Update pa_bc_packets
2652: set status_code = decode(status_code,'R',status_code,p_status_code)
2653: where budget_version_id = p_bud_ver_id;
2654:
2655: log_message(SQL%ROWCOUNT||' records updated');