[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row (
x_rowid IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
x_org_id IN NUMBER,
/* Bug 4576715 begin */
/* x_include_admin_proj_flag IN VARCHAR2,
x_gl_period_flag IN VARCHAR2,
x_pa_period_flag IN VARCHAR2, */
x_forecast_thru_date IN DATE,
x_actuals_thru_date IN DATE,
/* x_max_historical_versions IN NUMBER,
x_util_calc_method IN VARCHAR2, */
x_default_assign_exp_typ_class IN VARCHAR2,
x_default_assign_exp_type IN VARCHAR2,
x_default_tp_amount_type IN VARCHAR2,
x_bill_unassign_time_flag IN VARCHAR2,
x_nonbill_unassign_time_flag IN VARCHAR2,
x_bill_unassign_proj_id IN NUMBER,
x_bill_unassign_exp_type_class IN VARCHAR2,
x_bill_unassign_exp_type IN VARCHAR2,
x_nonbill_unassign_proj_id IN NUMBER,
x_nonbill_unassign_exp_typ_cls IN VARCHAR2,
x_nonbill_unassign_exp_type IN VARCHAR2,
X_CREATION_DATE in DATE,
X_CREATED_BY in NUMBER,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER,
/* x_key_member_role_id in NUMBER, */
x_job_cost_rate_schedule_id in NUMBER,
/* x_forecast_class_category in VARCHAR2, */
/* Bug 4576715 ends */
x_org_fcst_period_type in VARCHAR2,
x_start_period_name in VARCHAR2,
x_number_of_periods in NUMBER,
x_org_fcst_project_template_id in NUMBER,
x_weighted_or_full_code in VARCHAR2
) AS
/*|| Change History :
|| Who When What
|| NAVEEN 12-MAR-2001 Passing 3 more parameters namely x_key_member_role_id, x_job_cost_rate_schedule_id
|| and x_forecast_class_category to the procedure in order to add data for
|| fields key_member_role_id,job_cost_rate_schedule_id,forecast_class_category
|| in the table
|| (reverse chronological order - newest change first)
*/
CURSOR c IS
SELECT rowid
FROM pa_forecasting_options_all
WHERE nvl(org_id,-99) = nvl(x_org_id,-99);
INSERT INTO pa_forecasting_options_all (
org_id,
/* Bug 4576715 begin */
/* include_admin_proj_flag,
gl_period_flag,
pa_period_flag, */
forecast_thru_date,
actuals_thru_date,
/* max_historical_versions,
util_calc_method, */
default_assign_exp_type_class,
default_assign_exp_type,
default_tp_amount_type,
bill_unassign_time_flag,
nonbill_unassign_time_flag,
bill_unassign_proj_id,
bill_unassign_exp_type_class,
bill_unassign_exp_type,
nonbill_unassign_proj_id,
nonbill_unassign_exp_typ_cls,
nonbill_unassign_exp_type,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
/* key_member_role_id, */
job_cost_rate_schedule_id,
/* forecast_class_category, */
/* Bug 4576715 ends */
org_fcst_period_type,
start_period_name,
number_of_periods,
org_fcst_project_template_id,
weighted_or_Full_code
) VALUES (
x_org_id,
/* Bug 4576715 begins */
/* x_include_admin_proj_flag,
x_gl_period_flag,
x_pa_period_flag, */
x_forecast_thru_date,
x_actuals_thru_date,
/* x_max_historical_versions,
x_util_calc_method,*/
x_default_assign_exp_typ_class,
x_default_assign_exp_type,
x_default_tp_amount_type,
x_bill_unassign_time_flag,
x_nonbill_unassign_time_flag,
x_bill_unassign_proj_id,
x_bill_unassign_exp_type_class,
x_bill_unassign_exp_type,
x_nonbill_unassign_proj_id,
x_nonbill_unassign_exp_typ_cls,
x_nonbill_unassign_exp_type,
x_last_update_date,
x_last_updated_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
/* x_key_member_role_id, */
x_job_cost_rate_schedule_id,
/* x_forecast_class_category, */
/* Bug 4576715 ends */
x_org_fcst_period_type,
x_start_period_name,
x_number_of_periods,
x_org_fcst_project_template_id,
x_weighted_or_full_code
);
END insert_row;
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER,
/* x_key_member_role_id in NUMBER, */
x_job_cost_rate_schedule_id in NUMBER,
/* x_forecast_class_category in VARCHAR2, */
/* Bug 4576715 ends */
x_org_fcst_period_type in VARCHAR2,
x_start_period_name in VARCHAR2,
x_number_of_periods in NUMBER,
x_org_fcst_project_template_id in NUMBER,
x_weighted_or_full_code in VARCHAR2
) AS
/*
|| Created By :
|| Created On : 16-OCT-2000
|| Purpose : Handles the LOCK mechanism for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| NAVEEN 12-MAR-2001 Passing 3 more parameters namely x_key_member_role_id, x_job_cost_rate_schedule_id
|| and x_forecast_class_category to the procedure in order to pass values for
|| fields key_member_role_id,job_cost_rate_schedule_id,forecast_class_category
|| (reverse chronological order - newest change first)
*/
CURSOR c1 IS
SELECT
org_id,
/* Bug 4576715 begin */
/* include_admin_proj_flag,
gl_period_flag,
pa_period_flag, */
forecast_thru_date,
actuals_thru_date,
/* max_historical_versions,
util_calc_method, */
default_assign_exp_type_class,
default_assign_exp_type,
default_tp_amount_type,
bill_unassign_time_flag,
nonbill_unassign_time_flag,
bill_unassign_proj_id,
bill_unassign_exp_type_class,
bill_unassign_exp_type,
nonbill_unassign_proj_id,
nonbill_unassign_exp_typ_cls,
nonbill_unassign_exp_type,
/* key_member_role_id, */
job_cost_rate_schedule_id,
/* forecast_class_category, */
/* Bug 4576715 ends */
org_fcst_period_type,
start_period_name,
number_of_periods,
org_fcst_project_template_id,
weighted_or_full_code
FROM pa_forecasting_options_all
WHERE rowid = x_rowid
FOR UPDATE NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_org_id IN NUMBER,
/* Bug 4576715 begin */
/* x_include_admin_proj_flag IN VARCHAR2,
x_gl_period_flag IN VARCHAR2,
x_pa_period_flag IN VARCHAR2, */
x_forecast_thru_date IN DATE,
x_actuals_thru_date IN DATE,
/* x_max_historical_versions IN NUMBER,
x_util_calc_method IN VARCHAR2, */
x_default_assign_exp_typ_class IN VARCHAR2,
x_default_assign_exp_type IN VARCHAR2,
x_default_tp_amount_type IN VARCHAR2,
x_bill_unassign_time_flag IN VARCHAR2,
x_nonbill_unassign_time_flag IN VARCHAR2,
x_bill_unassign_proj_id IN NUMBER,
x_bill_unassign_exp_type_class IN VARCHAR2,
x_bill_unassign_exp_type IN VARCHAR2,
x_nonbill_unassign_proj_id IN NUMBER,
x_nonbill_unassign_exp_typ_cls IN VARCHAR2,
x_nonbill_unassign_exp_type IN VARCHAR2,
X_CREATION_DATE in DATE,
X_CREATED_BY in NUMBER,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER,
/* x_key_member_role_id in NUMBER, */
x_job_cost_rate_schedule_id in NUMBER,
/* x_forecast_class_category in VARCHAR2, */
/* Bug 4576715 ends */
x_org_fcst_period_type in VARCHAR2,
x_start_period_name in VARCHAR2,
x_number_of_periods in NUMBER,
x_org_fcst_project_template_id in NUMBER,
x_weighted_or_full_code in VARCHAR2
) AS
/*
|| Created By :
|| Created On : 16-OCT-2000
|| Purpose : Handles the UPDATE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| NAVEEN 12-MAR-2001 Passing 3 more parameters namely x_key_member_role_id, x_job_cost_rate_schedule_id
|| and x_forecast_class_category to the procedure in order to update
|| fields key_member_role_id,job_cost_rate_schedule_id,forecast_class_category
|| in the table
|| (reverse chronological order - newest change first)
*/
BEGIN
UPDATE pa_forecasting_options_all
SET
org_id = x_org_id,
/* Bug 4576715 begin */
/* include_admin_proj_flag = x_include_admin_proj_flag,
gl_period_flag = x_gl_period_flag,
pa_period_flag = x_pa_period_flag, */
forecast_thru_date = x_forecast_thru_date,
actuals_thru_date = x_actuals_thru_date,
/* max_historical_versions = x_max_historical_versions,
util_calc_method = x_util_calc_method, */
default_assign_exp_type_class = x_default_assign_exp_typ_class,
default_assign_exp_type = x_default_assign_exp_type,
default_tp_amount_type = x_default_tp_amount_type,
bill_unassign_time_flag = x_bill_unassign_time_flag,
nonbill_unassign_time_flag = x_nonbill_unassign_time_flag,
bill_unassign_proj_id = x_bill_unassign_proj_id,
bill_unassign_exp_type_class = x_bill_unassign_exp_type_class,
bill_unassign_exp_type = x_bill_unassign_exp_type,
nonbill_unassign_proj_id = x_nonbill_unassign_proj_id,
nonbill_unassign_exp_typ_cls = x_nonbill_unassign_exp_typ_cls,
nonbill_unassign_exp_type = x_nonbill_unassign_exp_type,
last_update_date = x_last_update_date,
last_updated_by = x_last_updated_by,
last_update_login = x_last_update_login,
/* key_member_role_id = x_key_member_role_id, */
job_cost_rate_schedule_id = x_job_cost_rate_schedule_id,
/* forecast_class_category = x_forecast_class_category, */
/* Bug 4576715 ends */
org_fcst_period_type = x_org_fcst_period_type,
start_period_name = x_start_period_name,
number_of_periods = x_number_of_periods,
org_fcst_project_template_id = x_org_fcst_project_template_id,
weighted_or_full_code = x_weighted_or_full_code
WHERE rowid = x_rowid;
END update_row;
PROCEDURE delete_row ( x_rowid IN VARCHAR2 ) AS
/*
|| Created By :
|| Created On : 16-OCT-2000
|| Purpose : Handles the DELETE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
BEGIN
DELETE FROM pa_forecasting_options_all
WHERE rowid = x_rowid;
END delete_row;