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 500: -- Bug 5379210 : Deleting pa_bc_packets for draft version

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

Line 501: Delete pa_bc_packets

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

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

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

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

1355:
1356: log_message('Reserve Baseline Mode');
1357:
1358: -- --------------------------------------------------------------+
1359: -- 6.A: Delete data from pa_bc_packets for the draft version ..
1360: -- Basically, data will exist if prev. baseline failed
1361: -- --------------------------------------------------------------+
1362: If (p_calling_mode = 'RESERVE_BASELINE' and g_cost_rebaseline_flag ='Y') then
1363: log_message('Calling Delete draft bc pkt');

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

1413: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1414: RAISE l_budget_processing_failure ;
1415: Else
1416:
1417: -- Update pa_bc_packets.status_code = 'A'
1418: Update_bc_packets_pass(p_bud_ver_id => p_budget_version_id);
1419: -- Bug 5206537 : Procedure to stamp latest budget version id and budget line id on CDL
1420: PA_FUNDS_CONTROL_UTILS.Update_bvid_blid_on_cdl_bccom ( p_bud_ver_id => p_budget_version_id,
1421: p_calling_mode => p_calling_mode);

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

1600: l_msg_data := g_msg_data;
1601: RAISE l_top_down_bdgt_failed;
1602: END IF;
1603:
1604: -- Update pa_bc_packets.status_code = 'A' .. as the last step ..
1605: Update_bc_packets_pass(p_bud_ver_id => p_budget_version_id);
1606: -- Bug 5206537 : Procedure to stamp latest budget version id and budget line id on CDL
1607: PA_FUNDS_CONTROL_UTILS.Update_bvid_blid_on_cdl_bccom ( p_bud_ver_id => p_budget_version_id,
1608: p_calling_mode => p_calling_mode);

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

2085: x_return_status => x_return_status,
2086: x_msg_count => x_msg_count,
2087: x_msg_data => x_msg_data);
2088:
2089: -- Fail pa_bc_packets for Cost and Commitment budget ..
2090: -- Fail pa_bc_packets for Cost budget ..
2091: Update_bc_packets_fail(p_bud_ver_id => l_draft_budget_version_id,
2092: p_status_code => 'R');
2093: Update_bc_packets_fail(p_bud_ver_id =>l_cc_budget_version_id,

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

2086: x_msg_count => x_msg_count,
2087: x_msg_data => x_msg_data);
2088:
2089: -- Fail pa_bc_packets for Cost and Commitment budget ..
2090: -- Fail pa_bc_packets for Cost budget ..
2091: Update_bc_packets_fail(p_bud_ver_id => l_draft_budget_version_id,
2092: p_status_code => 'R');
2093: Update_bc_packets_fail(p_bud_ver_id =>l_cc_budget_version_id,
2094: p_status_code=>'R');

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

2704: -- ------------------------------------------------------------------------------+
2705:
2706: -- ---------------------------------------------------------------------------------------------------+
2707: -- This procedure will be called during a recosting scenario to clean up date
2708: -- from pa_bc_packets for the "draft version" (meaning if re-baseline had earlier failed)
2709: -- bug reference for this fix: 5253834
2710: -- ---------------------------------------------------------------------------------------------------+
2711: PROCEDURE Delete_draft_bc_packets(p_draft_bud_ver_id IN NUMBER)
2712: IS

Line 2720: Delete from pa_bc_packets where budget_version_id = p_draft_bud_ver_id;

2716:
2717: log_message('Inside Delete_draft_bc_packets');
2718: log_message( 'Before delete');
2719:
2720: Delete from pa_bc_packets where budget_version_id = p_draft_bud_ver_id;
2721:
2722: log_message( 'After delete');
2723:
2724: COMMIT;

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

2724: COMMIT;
2725: END;
2726:
2727: -- ----------------------------------------------------------------+
2728: -- ## Following procedure will update pa_bc_packets status
2729: -- ----------------------------------------------------------------+
2730: PROCEDURE Update_bc_packets_pass(p_bud_ver_id IN NUMBER)
2731: IS
2732: BEGIN

Line 2737: Update pa_bc_packets

2733: log_message('Inside Update_bc_packets_pass');
2734: g_procedure_name := 'Update_bc_packets_pass';
2735: log_message( 'Before bcpkt update');
2736:
2737: Update pa_bc_packets
2738: set status_code = 'A'
2739: where budget_version_id = p_bud_ver_id;
2740:
2741: log_message(SQL%ROWCOUNT||' records updated');

Line 2758: Update pa_bc_packets

2754: log_message('Inside Update_bc_packets_fail');
2755: g_procedure_name := 'Update_bc_packets_fail';
2756: log_message( 'Before bcpkt update');
2757:
2758: Update pa_bc_packets
2759: set status_code = decode(status_code,'R',status_code,p_status_code)
2760: where budget_version_id = p_bud_ver_id;
2761:
2762: log_message(SQL%ROWCOUNT||' records updated');