APPS.PA_FORECASTING_OPTIONS_ALL_PKG dependencies on PA_FORECASTING_OPTIONS_ALL

Line 1: PACKAGE BODY pa_forecasting_options_all_pkg AS

1: PACKAGE BODY pa_forecasting_options_all_pkg AS
2: /* $Header: PARUTFRB.pls 120.3 2005/10/27 06:13:47 nkumbi noship $ */
3:
4: PROCEDURE insert_row (
5: x_rowid IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 51: FROM pa_forecasting_options_all

47: || (reverse chronological order - newest change first)
48: */
49: CURSOR c IS
50: SELECT rowid
51: FROM pa_forecasting_options_all
52: WHERE nvl(org_id,-99) = nvl(x_org_id,-99);
53:
54: l_rowid NUMBER; -- used to restore x_row_id for NOCOPY changes
55:

Line 58: INSERT INTO pa_forecasting_options_all (

54: l_rowid NUMBER; -- used to restore x_row_id for NOCOPY changes
55:
56: BEGIN
57: l_rowid := x_rowid;
58: INSERT INTO pa_forecasting_options_all (
59: org_id,
60: /* Bug 4576715 begin */
61: /* include_admin_proj_flag,
62: gl_period_flag,

Line 222: FROM pa_forecasting_options_all

218: start_period_name,
219: number_of_periods,
220: org_fcst_project_template_id,
221: weighted_or_full_code
222: FROM pa_forecasting_options_all
223: WHERE rowid = x_rowid
224: FOR UPDATE NOWAIT;
225: tlinfo c1%ROWTYPE;
226: BEGIN

Line 323: UPDATE pa_forecasting_options_all

319: || in the table
320: || (reverse chronological order - newest change first)
321: */
322: BEGIN
323: UPDATE pa_forecasting_options_all
324: SET
325: org_id = x_org_id,
326: /* Bug 4576715 begin */
327: /* include_admin_proj_flag = x_include_admin_proj_flag,

Line 373: DELETE FROM pa_forecasting_options_all

369: || Who When What
370: || (reverse chronological order - newest change first)
371: */
372: BEGIN
373: DELETE FROM pa_forecasting_options_all
374: WHERE rowid = x_rowid;
375: IF (SQL%NOTFOUND) THEN
376: RAISE NO_DATA_FOUND;
377: END IF;

Line 379: END pa_forecasting_options_all_pkg;

375: IF (SQL%NOTFOUND) THEN
376: RAISE NO_DATA_FOUND;
377: END IF;
378: END delete_row;
379: END pa_forecasting_options_all_pkg;