[Home] [Help]
1154:
1155: PROCEDURE Compare_bdgtLine_Values
1156: (p_budget_version_id IN Number
1157: ,p_budget_version_type IN Varchar2
1158: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
1159: ,p_apply_progress_flag IN Varchar2 DEFAULT 'N'
1160: ,x_return_status OUT NOCOPY Varchar2
1161: ,x_msg_data OUT NOCOPY Varchar2
1162: ) IS
2154: */
2155:
2156: PROCEDURE process_NonRtBsRec_forSprd
2157: (p_budget_version_id IN Number
2158: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2159: ,x_return_status OUT NOCOPY VARCHAR2
2160: ) IS
2161:
2162: CURSOR cur_NonRtBsRecs IS
2319: * a mixture of revenue only and cost and revenue lines
2320: */
2321: PROCEDURE pre_process_Revenue_Only_Recs
2322: (p_budget_version_id IN Number
2323: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2324: ,x_return_status OUT NOCOPY VARCHAR2
2325: ) IS
2326:
2327: CURSOR cur_RevOnlyRecs IS
2604: * revert back the Non-rate base to rate base flag
2605: */
2606: PROCEDURE Reset_ratebased_pltrxns(
2607: p_budget_version_id IN Number
2608: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2609: ,x_return_status OUT NOCOPY VARCHAR2
2610: ) IS
2611:
2612: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
3476: * then throw an error:'Enter quantity for rate based planning transaction'
3477: */
3478: PROCEDURE Check_ratebased_pltrxns(
3479: p_budget_version_id IN Number
3480: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
3481: ,x_return_status OUT NOCOPY VARCHAR2
3482: ) IS
3483:
3484: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
7030: */
7031: PROCEDURE cache_rates(
7032: p_budget_verson_id IN Number
7033: ,p_apply_progress_flag IN Varchar2
7034: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
7035: ,x_return_status OUT NOCOPY varchar2
7036: ,x_msg_data OUT NOCOPY varchar2
7037: ) IS
7038: