52: X_LAST_UPDATE_LOGIN in NUMBER ,
53: X_MIGRATED_FRM_BDGT_TYP_CODE in VARCHAR2 default null,
54: /* dbora --- FP M --13-NOV-03 :Introduced the following additional parameters to check for different set up options
55: */
56: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
57: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
58: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
59: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
60: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE) ;
53: X_MIGRATED_FRM_BDGT_TYP_CODE in VARCHAR2 default null,
54: /* dbora --- FP M --13-NOV-03 :Introduced the following additional parameters to check for different set up options
55: */
56: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
57: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
58: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
59: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
60: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE) ;
61:
54: /* dbora --- FP M --13-NOV-03 :Introduced the following additional parameters to check for different set up options
55: */
56: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
57: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
58: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
59: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
60: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE) ;
61:
62: procedure LOCK_ROW (
55: */
56: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
57: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
58: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
59: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
60: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE) ;
61:
62: procedure LOCK_ROW (
63: X_FIN_PLAN_TYPE_ID in NUMBER,
56: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
57: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
58: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
59: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
60: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE) ;
61:
62: procedure LOCK_ROW (
63: X_FIN_PLAN_TYPE_ID in NUMBER,
64: X_FIN_PLAN_TYPE_CODE in VARCHAR2 default null,
105: X_ATTRIBUTE15 in VARCHAR2 default null,
106: X_MIGRATED_FRM_BDGT_TYP_CODE in VARCHAR2 default null,
107: /* dbora --- FP M --13-NOV-03 :Introduced the following additional parameters to check for different set up options
108: */
109: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE default null,
110: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE default null,
111: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE default null,
112: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE default null,
113: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE default null);
106: X_MIGRATED_FRM_BDGT_TYP_CODE in VARCHAR2 default null,
107: /* dbora --- FP M --13-NOV-03 :Introduced the following additional parameters to check for different set up options
108: */
109: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE default null,
110: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE default null,
111: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE default null,
112: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE default null,
113: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE default null);
114:
107: /* dbora --- FP M --13-NOV-03 :Introduced the following additional parameters to check for different set up options
108: */
109: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE default null,
110: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE default null,
111: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE default null,
112: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE default null,
113: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE default null);
114:
115:
108: */
109: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE default null,
110: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE default null,
111: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE default null,
112: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE default null,
113: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE default null);
114:
115:
116: procedure UPDATE_ROW (
109: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE default null,
110: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE default null,
111: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE default null,
112: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE default null,
113: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE default null);
114:
115:
116: procedure UPDATE_ROW (
117: X_FIN_PLAN_TYPE_ID in NUMBER,
162: X_LAST_UPDATE_LOGIN in NUMBER ,
163: X_MIGRATED_FRM_BDGT_TYP_CODE in VARCHAR2 default null,
164: /* dbora --- FP M --13-NOV-03 :Introduced the following additional parameters to check for different set up options
165: */
166: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
167: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
168: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
169: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
170: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE);
163: X_MIGRATED_FRM_BDGT_TYP_CODE in VARCHAR2 default null,
164: /* dbora --- FP M --13-NOV-03 :Introduced the following additional parameters to check for different set up options
165: */
166: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
167: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
168: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
169: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
170: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE);
171:
164: /* dbora --- FP M --13-NOV-03 :Introduced the following additional parameters to check for different set up options
165: */
166: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
167: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
168: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
169: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
170: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE);
171:
172:
165: */
166: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
167: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
168: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
169: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
170: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE);
171:
172:
173: procedure DELETE_ROW (
166: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
167: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
168: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
169: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
170: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE);
171:
172:
173: procedure DELETE_ROW (
174: X_FIN_PLAN_TYPE_ID in NUMBER
230: X_MIGRATED_FRM_BDGT_TYP_CODE in VARCHAR2 default null ,
231: X_OWNER in VARCHAR2,
232: /* dbora --- FP M --13-NOV-03 :Introduced the following additional parameters to check for different set up options
233: */
234: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
235: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
236: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
237: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
238: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE);
231: X_OWNER in VARCHAR2,
232: /* dbora --- FP M --13-NOV-03 :Introduced the following additional parameters to check for different set up options
233: */
234: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
235: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
236: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
237: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
238: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE);
239:
232: /* dbora --- FP M --13-NOV-03 :Introduced the following additional parameters to check for different set up options
233: */
234: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
235: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
236: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
237: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
238: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE);
239:
240: end PA_FIN_PLAN_TYPES_PKG;
233: */
234: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
235: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
236: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
237: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
238: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE);
239:
240: end PA_FIN_PLAN_TYPES_PKG;
234: X_ENABLE_PARTIAL_IMPL_FLAG IN PA_FIN_PLAN_TYPES_B.ENABLE_PARTIAL_IMPL_FLAG%TYPE,
235: X_PRIMARY_COST_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_COST_FORECAST_FLAG%TYPE,
236: X_PRIMARY_REV_FORECAST_FLAG IN PA_FIN_PLAN_TYPES_B.PRIMARY_REV_FORECAST_FLAG%TYPE,
237: X_EDIT_AFTER_BASELINE_FLAG IN PA_FIN_PLAN_TYPES_B.EDIT_AFTER_BASELINE_FLAG%TYPE,
238: X_USE_FOR_WORKPLAN_FLAG IN PA_FIN_PLAN_TYPES_B.USE_FOR_WORKPLAN_FLAG%TYPE);
239:
240: end PA_FIN_PLAN_TYPES_PKG;