[Home] [Help]
1161:
1162: PROCEDURE Compare_bdgtLine_Values
1163: (p_budget_version_id IN Number
1164: ,p_budget_version_type IN Varchar2
1165: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
1166: ,p_apply_progress_flag IN Varchar2 DEFAULT 'N'
1167: ,x_return_status OUT NOCOPY Varchar2
1168: ,x_msg_data OUT NOCOPY Varchar2
1169: ) IS
2163: */
2164:
2165: PROCEDURE process_NonRtBsRec_forSprd
2166: (p_budget_version_id IN Number
2167: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2168: ,x_return_status OUT NOCOPY VARCHAR2
2169: ) IS
2170:
2171: CURSOR cur_NonRtBsRecs IS
2328: * a mixture of revenue only and cost and revenue lines
2329: */
2330: PROCEDURE pre_process_Revenue_Only_Recs
2331: (p_budget_version_id IN Number
2332: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2333: ,x_return_status OUT NOCOPY VARCHAR2
2334: ) IS
2335:
2336: CURSOR cur_RevOnlyRecs IS
2613: * revert back the Non-rate base to rate base flag
2614: */
2615: PROCEDURE Reset_ratebased_pltrxns(
2616: p_budget_version_id IN Number
2617: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2618: ,x_return_status OUT NOCOPY VARCHAR2
2619: ) IS
2620:
2621: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
3504: * then throw an error:'Enter quantity for rate based planning transaction'
3505: */
3506: PROCEDURE Check_ratebased_pltrxns(
3507: p_budget_version_id IN Number
3508: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
3509: ,x_return_status OUT NOCOPY VARCHAR2
3510: ) IS
3511:
3512: l_resource_assignment_tab pa_plsql_datatypes.NumTabTyp;
7061: */
7062: PROCEDURE cache_rates(
7063: p_budget_verson_id IN Number
7064: ,p_apply_progress_flag IN Varchar2
7065: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
7066: ,x_return_status OUT NOCOPY varchar2
7067: ,x_msg_data OUT NOCOPY varchar2
7068: ) IS
7069: