1 PACKAGE pa_forecasting_options_all_pkg AS
2 /* $Header: PARUTFRS.pls 120.2 2005/10/27 06:13:28 nkumbi noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6 x_org_id IN NUMBER,
7 /* Bug 4576715 begin */
8 /* x_include_admin_proj_flag IN VARCHAR2,
9 x_gl_period_flag IN VARCHAR2,
10 x_pa_period_flag IN VARCHAR2, */
11 x_forecast_thru_date IN DATE,
12 x_actuals_thru_date IN DATE,
13 /* x_max_historical_versions IN NUMBER,
14 x_util_calc_method IN VARCHAR2, */
15 x_default_assign_exp_typ_class IN VARCHAR2,
16 x_default_assign_exp_type IN VARCHAR2,
17 x_default_tp_amount_type IN VARCHAR2,
18 x_bill_unassign_time_flag IN VARCHAR2,
19 x_nonbill_unassign_time_flag IN VARCHAR2,
20 x_bill_unassign_proj_id IN NUMBER,
21 x_bill_unassign_exp_type_class IN VARCHAR2,
22 x_bill_unassign_exp_type IN VARCHAR2,
23 x_nonbill_unassign_proj_id IN NUMBER,
24 x_nonbill_unassign_exp_typ_cls IN VARCHAR2,
25 x_nonbill_unassign_exp_type IN VARCHAR2,
26 X_CREATION_DATE in DATE,
27 X_CREATED_BY in NUMBER,
28 X_LAST_UPDATE_DATE in DATE,
29 X_LAST_UPDATED_BY in NUMBER,
30 X_LAST_UPDATE_LOGIN in NUMBER,
31 /*FOLLOWING 3 NEW PARAMETERS ADDED MARCH 12,2001 BY NAVEEN GUPTA
32 IN ORDER TO INSERT DATA FOR FIELDS KEY_MEMBER_ROLE_ID,JOB_COST_RATE_SCHEDULE_ID AND FORECAST_CLASS_CATEGORY
33 RESPECTIVELY IN TABLE PA_FORECASTING_OPTIONS_ALL*/
34 /* x_key_member_role_id in NUMBER, */
35 x_job_cost_rate_schedule_id in NUMBER,
36 /* x_forecast_class_category in VARCHAR2, */
37 /* Bug 4576715 ends */
38 x_org_fcst_period_type in VARCHAR2,
39 x_start_period_name in VARCHAR2,
40 x_number_of_periods in NUMBER,
41 x_org_fcst_project_template_id in NUMBER,
42 x_weighted_or_full_code in VARCHAR2
43 );
44
45 PROCEDURE lock_row (
46 x_rowid IN VARCHAR2,
47 x_org_id IN NUMBER,
48 /* Bug 4576715 begin */
49 /* x_include_admin_proj_flag IN VARCHAR2,
50 x_gl_period_flag IN VARCHAR2,
51 x_pa_period_flag IN VARCHAR2, */
52 x_forecast_thru_date IN DATE,
53 x_actuals_thru_date IN DATE,
54 /* x_max_historical_versions IN NUMBER,
55 x_util_calc_method IN VARCHAR2, */
56 x_default_assign_exp_typ_class IN VARCHAR2,
57 x_default_assign_exp_type IN VARCHAR2,
58 x_default_tp_amount_type IN VARCHAR2,
59 x_bill_unassign_time_flag IN VARCHAR2,
60 x_nonbill_unassign_time_flag IN VARCHAR2,
61 x_bill_unassign_proj_id IN NUMBER,
62 x_bill_unassign_exp_type_class IN VARCHAR2,
63 x_bill_unassign_exp_type IN VARCHAR2,
64 x_nonbill_unassign_proj_id IN NUMBER,
65 x_nonbill_unassign_exp_typ_cls IN VARCHAR2,
66 x_nonbill_unassign_exp_type IN VARCHAR2,
67 X_CREATION_DATE in DATE,
68 X_CREATED_BY in NUMBER,
69 X_LAST_UPDATE_DATE in DATE,
70 X_LAST_UPDATED_BY in NUMBER,
71 X_LAST_UPDATE_LOGIN in NUMBER,
72 /*FOLLOWING 3 NEW PARAMETERS ADDED MARCH 12,2001 BY NAVEEN GUPTA
73 IN ORDER TO INSERT DATA FOR FIELDS KEY_MEMBER_ROLE_ID,JOB_COST_RATE_SCHEDULE_ID AND FORECAST_CLASS_CATEGORY
74 RESPECTIVELY IN TABLE PA_FORECASTING_OPTIONS_ALL*/
75 /* x_key_member_role_id in NUMBER, */
76 x_job_cost_rate_schedule_id in NUMBER,
77 /* x_forecast_class_category in VARCHAR2, */
78 /* Bug 4576715 ends */
79 x_org_fcst_period_type in VARCHAR2,
80 x_start_period_name in VARCHAR2,
81 x_number_of_periods in NUMBER,
82 x_org_fcst_project_template_id in NUMBER,
83 x_weighted_or_full_code in VARCHAR2
84 );
85
86 PROCEDURE update_row (
87 x_rowid IN VARCHAR2,
88 x_org_id IN NUMBER,
89 /* Bug 4576715 begin */
90 /* x_include_admin_proj_flag IN VARCHAR2,
91 x_gl_period_flag IN VARCHAR2,
92 x_pa_period_flag IN VARCHAR2, */
93 x_forecast_thru_date IN DATE,
94 x_actuals_thru_date IN DATE,
95 /* x_max_historical_versions IN NUMBER,
96 x_util_calc_method IN VARCHAR2, */
97 x_default_assign_exp_typ_class IN VARCHAR2,
98 x_default_assign_exp_type IN VARCHAR2,
99 x_default_tp_amount_type IN VARCHAR2,
100 x_bill_unassign_time_flag IN VARCHAR2,
101 x_nonbill_unassign_time_flag IN VARCHAR2,
102 x_bill_unassign_proj_id IN NUMBER,
103 x_bill_unassign_exp_type_class IN VARCHAR2,
104 x_bill_unassign_exp_type IN VARCHAR2,
105 x_nonbill_unassign_proj_id IN NUMBER,
106 x_nonbill_unassign_exp_typ_cls IN VARCHAR2,
107 x_nonbill_unassign_exp_type IN VARCHAR2,
108 X_CREATION_DATE in DATE,
109 X_CREATED_BY in NUMBER,
110 X_LAST_UPDATE_DATE in DATE,
111 X_LAST_UPDATED_BY in NUMBER,
112 X_LAST_UPDATE_LOGIN in NUMBER,
113 /*FOLLOWING 3 NEW PARAMETERS ADDED MARCH 12,2001 BY NAVEEN GUPTA
114 IN ORDER TO INSERT DATA FOR FIELDS KEY_MEMBER_ROLE_ID,JOB_COST_RATE_SCHEDULE_ID AND FORECAST_CLASS_CATEGORY
115 RESPECTIVELY IN TABLE PA_FORECASTING_OPTIONS_ALL*/
116 /* x_key_member_role_id in NUMBER, */
117 x_job_cost_rate_schedule_id in NUMBER,
118 /* x_forecast_class_category in VARCHAR2, */
119 /* Bug 4576715 ends */
120 x_org_fcst_period_type in VARCHAR2,
121 x_start_period_name in VARCHAR2,
122 x_number_of_periods in NUMBER,
123 x_org_fcst_project_template_id in NUMBER,
127
124 x_weighted_or_full_code in VARCHAR2
125 );
126
128 PROCEDURE delete_row ( x_rowid IN VARCHAR2) ;
129
130 END pa_forecasting_options_all_pkg;