[Home] [Help]
PACKAGE: APPS.PA_FP_ROLLUP_TMP_PKG
Source
1 PACKAGE PA_FP_ROLLUP_TMP_PKG AS
2 /* $Header: PAFPRLTS.pls 120.1 2005/08/19 16:29:53 mwasowic noship $*/
3 PROCEDURE POPULATE_IN_BULK
4 ( p_res_assignment_id_tbl IN pa_fp_webadi_pkg.l_res_assignment_id_tbl_typ
5 , p_parent_assignment_id_tbl IN pa_fp_webadi_pkg.l_parent_assign_id_tbl_typ
6 , p_start_date_tbl IN pa_fp_webadi_pkg.l_start_date_tbl_typ
7 , p_end_date_tbl IN pa_fp_webadi_pkg.l_end_date_tbl_typ
8 , p_txn_currency_code_tbl IN pa_fp_webadi_pkg.l_txn_currency_code_tbl_typ
9 , p_proj_currency_code_tbl IN pa_fp_webadi_pkg.l_proj_currency_code_tbl_typ
10 , p_pf_currency_code_tbl IN pa_fp_webadi_pkg.l_pf_currency_code_tbl_typ
11 , p_proj_cost_rate_type_tbl IN pa_fp_webadi_pkg.l_proj_cost_rate_type_tbl_typ
12 , p_proj_cost_rt_dt_type_tbl IN pa_fp_webadi_pkg.l_proj_cost_rt_dt_type_tbl_typ
13 , p_proj_cost_exc_rate_tbl IN pa_fp_webadi_pkg.l_proj_cost_exc_rate_tbl_typ
14 , p_proj_cost_rate_date_tbl IN pa_fp_webadi_pkg.l_proj_cost_rate_date_tbl_typ
15 , p_proj_rev_rate_type_tbl IN pa_fp_webadi_pkg.l_proj_rev_rate_type_tbl_typ
16 , p_proj_rev_rt_dt_type_tbl IN pa_fp_webadi_pkg.l_proj_rev_rt_dt_type_tbl_typ
17 , p_proj_rev_exc_rate_tbl IN pa_fp_webadi_pkg.l_proj_rev_exc_rate_tbl_typ
18 , p_proj_rev_rate_date_tbl IN pa_fp_webadi_pkg.l_proj_rev_rate_date_tbl_typ
19 , p_pf_cost_rate_type_tbl IN pa_fp_webadi_pkg.l_pf_cost_rate_type_tbl_typ
20 , p_pf_cost_rt_dt_type_tbl IN pa_fp_webadi_pkg.l_pf_cost_rt_dt_type_tbl_typ
21 , p_pf_cost_exc_rate_tbl IN pa_fp_webadi_pkg.l_pf_cost_exc_rate_tbl_typ
22 , p_pf_cost_rate_date_tbl IN pa_fp_webadi_pkg.l_pf_cost_rate_date_tbl_typ
23 , p_pf_rev_rate_type_tbl IN pa_fp_webadi_pkg.l_pf_rev_rate_type_tbl_typ
24 , p_pf_rev_rt_dt_type_tbl IN pa_fp_webadi_pkg.l_pf_rev_rt_dt_type_tbl_typ
25 , p_pf_rev_exc_rate_tbl IN pa_fp_webadi_pkg.l_pf_rev_exc_rate_tbl_typ
26 , p_pf_rev_rate_date_tbl IN pa_fp_webadi_pkg.l_pf_rev_rate_date_tbl_typ
27 , p_old_proj_raw_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
28 , p_old_proj_burdened_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
29 , p_old_proj_revenue_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
30 , p_old_pf_raw_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
31 , p_old_pf_burdened_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
32 , p_old_pf_revenue_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
33 , p_old_quantity_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
34 , p_old_txn_raw_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
35 , p_old_txn_burdened_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
36 , p_old_txn_revenue_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
37 , p_txn_raw_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
38 , p_txn_burdened_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
39 , p_txn_revenue_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
40 , p_quantity_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
41 , p_delete_flag_tbl IN pa_fp_webadi_pkg.l_delete_flag_tbl_typ
42 , p_period_name_tbl IN pa_fp_webadi_pkg.l_period_name_tbl_typ
43 , p_change_reason_code_tbl IN pa_fp_webadi_pkg.l_change_reason_code_tbl_typ
44 , p_description_tbl IN pa_fp_webadi_pkg.l_description_tbl_typ
45 , p_pm_product_code_tbl IN pa_fp_webadi_pkg.l_pm_product_code_tbl_typ
46 , p_attribute_category_tbl IN pa_fp_webadi_pkg.l_attribute_category_tbl_typ
47 , p_attribute1_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
48 , p_attribute2_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
49 , p_attribute3_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
50 , p_attribute4_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
51 , p_attribute5_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
52 , p_attribute6_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
53 , p_attribute7_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
54 , p_attribute8_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
55 , p_attribute9_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
56 , p_attribute10_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
57 , p_attribute11_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
58 , p_attribute12_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
59 , p_attribute13_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
60 , p_attribute14_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
61 , p_attribute15_tbl IN pa_fp_webadi_pkg.l_attribute_tbl_typ
62 , p_budget_line_id_tbl IN pa_fp_webadi_pkg.l_budget_line_id_tbl_typ
63 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
64 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
65 , x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
66
67 PROCEDURE POPULATE_IN_MATRIX
68 ( p_res_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
69 , p_parent_assignment_id IN pa_resource_assignments.parent_assignment_id%TYPE
70 , p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
71 , p_proj_currency_code IN pa_budget_lines.project_currency_code%TYPE
72 , p_pf_currency_code IN pa_budget_lines.projfunc_currency_code%TYPE
73 , p_proj_cost_rate_type IN pa_budget_lines.project_cost_rate_type%TYPE
74 , p_proj_cost_rt_dt_type IN pa_budget_lines.project_cost_rate_date_type%TYPE
75 , p_proj_cost_exc_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
76 , p_proj_cost_rate_date IN pa_budget_lines.project_cost_rate_date%TYPE
77 , p_proj_rev_rate_type IN pa_budget_lines.project_rev_rate_type%TYPE
78 , p_proj_rev_rt_dt_type IN pa_budget_lines.project_rev_rate_date_type%TYPE
79 , p_proj_rev_exc_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
80 , p_proj_rev_rate_date IN pa_budget_lines.project_rev_rate_date%TYPE
81 , p_pf_cost_rate_type IN pa_budget_lines.projfunc_cost_rate_type%TYPE
82 , p_pf_cost_rt_dt_type IN pa_budget_lines.projfunc_cost_rate_date_type%TYPE
83 , p_pf_cost_exc_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
84 , p_pf_cost_rate_date IN pa_budget_lines.projfunc_cost_rate_date%TYPE
85 , p_pf_rev_rate_type IN pa_budget_lines.projfunc_rev_rate_type%TYPE
86 , p_pf_rev_rt_dt_type IN pa_budget_lines.projfunc_rev_rate_date_type%TYPE
87 , p_pf_rev_exc_rate IN pa_budget_lines.projfunc_rev_exchange_rate%TYPE
88 , p_pf_rev_rate_date IN pa_budget_lines.projfunc_rev_rate_date%TYPE
89 , p_delete_flag IN VARCHAR2
90 , p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
91 , p_description IN pa_budget_lines.description%TYPE
92 , p_attribute_category IN pa_budget_lines.attribute_category%TYPE
93 , p_attribute1 IN pa_budget_lines.attribute1%TYPE
94 , p_attribute2 IN pa_budget_lines.attribute2%TYPE
95 , p_attribute3 IN pa_budget_lines.attribute3%TYPE
96 , p_attribute4 IN pa_budget_lines.attribute4%TYPE
97 , p_attribute5 IN pa_budget_lines.attribute5%TYPE
98 , p_attribute6 IN pa_budget_lines.attribute6%TYPE
99 , p_attribute7 IN pa_budget_lines.attribute7%TYPE
100 , p_attribute8 IN pa_budget_lines.attribute8%TYPE
101 , p_attribute9 IN pa_budget_lines.attribute9%TYPE
102 , p_attribute10 IN pa_budget_lines.attribute10%TYPE
103 , p_attribute11 IN pa_budget_lines.attribute11%TYPE
104 , p_attribute12 IN pa_budget_lines.attribute12%TYPE
105 , p_attribute13 IN pa_budget_lines.attribute13%TYPE
106 , p_attribute14 IN pa_budget_lines.attribute14%TYPE
107 , p_attribute15 IN pa_budget_lines.attribute15%TYPE
108 , p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE
109 , p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE
110 , p_quantity_source IN pa_budget_lines.quantity_source%TYPE
111 , p_revenue_source IN pa_budget_lines.revenue_source%TYPE
112 , p_start_date_tbl IN pa_fp_webadi_pkg.l_start_date_tbl_typ
113 , p_end_date_tbl IN pa_fp_webadi_pkg.l_end_date_tbl_typ
114 , p_period_name_tbl IN pa_fp_webadi_pkg.l_period_name_tbl_typ
115 , p_txn_raw_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
116 , p_txn_burdened_cost_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
117 , p_txn_revenue_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
118 , p_quantity_tbl IN pa_fp_webadi_pkg.l_amount_tbl_typ
119 , p_bucketing_period_code_tbl IN pa_fp_webadi_pkg.l_bucketing_pd_code_tbl_typ
120 , p_pm_product_code_tbl IN pa_fp_webadi_pkg.l_pm_product_code_tbl_typ
121 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
122 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
123 , x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
124
125 END PA_FP_ROLLUP_TMP_PKG;