DBA Data[Home] [Help]

APPS.PA_GENERATE_FORECAST_PUB dependencies on PA_RATE_PVT_PKG

Line 560: l_prj_revenue_tab PA_RATE_PVT_PKG.ProjAmt_TabTyp;

556: l_tot_prj_bcost NUMBER:=0;
557: l_tot_prj_cost NUMBER:=0;
558:
559:
560: l_prj_revenue_tab PA_RATE_PVT_PKG.ProjAmt_TabTyp;
561: l_prj_cost_tab PA_RATE_PVT_PKG.ProjAmt_TabTyp;
562: l_project_id NUMBER;
563:
564: l_ret_status VARCHAR2(100);

Line 561: l_prj_cost_tab PA_RATE_PVT_PKG.ProjAmt_TabTyp;

557: l_tot_prj_cost NUMBER:=0;
558:
559:
560: l_prj_revenue_tab PA_RATE_PVT_PKG.ProjAmt_TabTyp;
561: l_prj_cost_tab PA_RATE_PVT_PKG.ProjAmt_TabTyp;
562: l_project_id NUMBER;
563:
564: l_ret_status VARCHAR2(100);
565: l_msg_count NUMBER;

Line 759: PA_RATE_PVT_PKG.Get_Revenue_Generation_Method(

755: PA_DEBUG.g_err_stage := '410: before calling for rev gen md';
756: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
757: BEGIN
758:
759: PA_RATE_PVT_PKG.Get_Revenue_Generation_Method(
760: P_PROJECT_ID => p_project_id,
761: P_DISTRIBUTION_RULE => l_distribution_rule,
762: X_REV_GEN_METHOD => l_rev_gen_method,
763: X_ERROR_MSG => l_error_msg );

Line 1097: PA_RATE_PVT_PKG.get_initial_bill_rate(

1093: IF l_role_error_code IS NULL THEN
1094: BEGIN
1095: PA_DEBUG.g_err_stage := '1105: before calling init bill rate';
1096: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1097: PA_RATE_PVT_PKG.get_initial_bill_rate(
1098: p_assignment_type => l_prj_short_assignment_type,
1099: p_asgn_start_date => l_prj_start_date,
1100: p_project_id => p_project_id,
1101: p_quantity => 1,

Line 1240: PA_RATE_PVT_PKG.Calc_Rate_Amount(

1236: dbms_output.put_line(' p_project_rev_rt_type_tab ' || l_rt_proj_rev_rt_type_tab.COUNT);
1237: dbms_output.put_line(' p_project_rev_exch_rt_tab ' || l_rt_proj_rev_ex_rt_tab.COUNT);
1238: dbms_output.put_line(' p_project_cst_rt_date_tab ' || l_rt_proj_cost_rt_date_tab.COUNT);
1239: dbms_output.put_line(' p_project_cst_rt_type_tab ' || l_rt_proj_cost_rt_type_tab.COUNT); */
1240: PA_RATE_PVT_PKG.Calc_Rate_Amount(
1241: P_CALLING_MODE => l_calling_mode,
1242: P_RATE_CALC_DATE_TAB => l_rt_start_date_tab,
1243: P_ITEM_ID => l_prj_assignment_id,
1244: P_ASGN_START_DATE => l_prj_start_date,

Line 1851: PA_DEBUG.g_err_stage := '2400: before calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';

1847: PA_DEBUG.g_err_stage := '2450: no prj value : aft updating err msg in event Based';
1848: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1849: ELSE
1850: l_prj_revenue_tab.delete;
1851: PA_DEBUG.g_err_stage := '2400: before calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';
1852: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1853:
1854: BEGIN
1855: PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE(

Line 1855: PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE(

1851: PA_DEBUG.g_err_stage := '2400: before calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';
1852: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1853:
1854: BEGIN
1855: PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE(
1856: p_project_id => p_project_id,
1857: p_rev_amt => l_project_value,
1858: p_completion_date => l_completion_date,
1859: p_project_currency_code => l_project_currency_code,

Line 1873: PA_DEBUG.g_err_stage := '2450: after calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';

1869: UPDATE_BUDG_VERSION( p_budget_version_id => l_budget_version_id );
1870: RAISE;
1871: END;
1872:
1873: PA_DEBUG.g_err_stage := '2450: after calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';
1874: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1875: IF l_event_error_msg IS NULL THEN
1876: PA_DEBUG.g_err_stage := '2500: before upserting in PA_BUDGET_LINES';
1877: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 1973: PA_DEBUG.g_err_stage := '2800: before calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';

1969:
1970: PA_DEBUG.g_err_stage := '2750: after fetching BUDGET_LINES into PL/SQL table';
1971: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1972:
1973: PA_DEBUG.g_err_stage := '2800: before calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';
1974: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1975: l_cost_based_error_code := NULL;
1976: BEGIN
1977: PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE(

Line 1977: PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE(

1973: PA_DEBUG.g_err_stage := '2800: before calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';
1974: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1975: l_cost_based_error_code := NULL;
1976: BEGIN
1977: PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE(
1978: p_project_id => p_project_id,
1979: p_rev_amt => l_project_value,
1980: p_projfunc_cost_tab => l_prj_cost_tab,
1981: x_projfunc_revenue_tab => l_prj_revenue_tab,

Line 1995: PA_DEBUG.g_err_stage := '2850: after calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';

1991: UPDATE_BUDG_VERSION( p_budget_version_id => l_budget_version_id );
1992: RAISE;
1993: END;
1994:
1995: PA_DEBUG.g_err_stage := '2850: after calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';
1996: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1997: IF l_cost_based_error_code IS NULL THEN
1998: PA_DEBUG.g_err_stage := '2900: bef upd PA_BUDGET_LINES for COST_BASED_REVENUE';
1999: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);