[Home] [Help]
PACKAGE: APPS.XTR_FORECAST_PERIODS_PKG
Source
1 PACKAGE XTR_FORECAST_PERIODS_PKG AUTHID CURRENT_USER as
2 /* $Header: xtrfprds.pls 115.0 99/07/17 00:30:52 porting ship $ */
3 --
4 -- Package
5 -- XTR_FORECAST_PERIODS_PKG
6 -- Purpose
7 -- To group all the procedures/functions for table handling of the
8 -- xtr_forecast_PERIODs table.
9 -- History
10 -- 12/24/98 BHCHUNG Created
11 --
12
13
14 --
15 -- Procedure
16 -- Check_Unique
17 -- Purpose
18 -- Checks the uniqueness of the forecast PERIOD inserted.
19 -- History
20 -- 12/24/98 BHCHUNG Created
21 -- Example
22 -- XTR_FORECAST_PERIODS_PKG.Check_Unique(...);
23 -- Notes
24 --
25 PROCEDURE Check_Unique(
26 X_rowid VARCHAR2,
27 X_forecast_header_id NUMBER,
28 X_period_number NUMBER);
29
30 --
31 -- Procedure
32 -- insert_row
33 -- Purpose
34 -- To insert new row to xtr_forecast_periods.
35 -- History
36 -- 12/24/98 BHCHUNG Created
37 -- Example
38 -- XTR_FORECAST_PERIODS_PKG.Insert_Row(...)
39 -- Notes
40 --
41
42 PROCEDURE Insert_Row(
43 X_rowid IN OUT VARCHAR2,
44 X_forecast_period_id IN OUT NUMBER,
45 X_forecast_header_id NUMBER,
46 X_period_number NUMBER,
47 X_level_of_summary VARCHAR2,
48 X_length_of_period NUMBER,
49 X_length_type VARCHAR2,
50 X_created_by NUMBER,
51 X_creation_date DATE,
52 X_last_updated_by NUMBER,
53 X_last_update_date DATE,
54 X_last_update_login NUMBER);
55
56 --
57 -- Procedure
58 -- lock_row
59 -- Purpose
60 -- To lock a row from xtr_forecast_periods.
61 -- History
62 -- 12/24/98 BHCHUNG Created
63 -- Example
64 -- XTR_FORECAST_PERIODS_PKG.Lock_Row(...)
65 -- Notes
66 --
67
68
69 PROCEDURE Lock_Row(
70 X_rowid VARCHAR2,
71 X_forecast_period_id NUMBER,
72 X_forecast_header_id NUMBER,
73 X_period_number NUMBER,
74 X_level_of_summary VARCHAR2,
75 X_length_of_period NUMBER,
76 X_length_type VARCHAR2,
77 X_created_by NUMBER,
78 X_creation_date DATE,
79 X_last_updated_by NUMBER,
80 X_last_update_date DATE,
81 X_last_update_login NUMBER);
82
83 --
84 -- Procedure
85 -- Update_Row
86 -- Purpose
87 -- To update xtr_forecast_periods with changes made.
88 -- History
89 -- 12/24/98 BHCHUNG Created
90 -- Example
91 -- XTR_FORECAST_PERIODS_PKG.Update_Row(...);
92 -- Notes
93 --
94 PROCEDURE Update_Row(
95 X_rowid VARCHAR2,
96 X_forecast_period_id NUMBER,
97 X_forecast_header_id NUMBER,
98 X_period_number NUMBER,
99 X_level_of_summary VARCHAR2,
100 X_length_of_period NUMBER,
101 X_length_type VARCHAR2,
102 X_created_by NUMBER,
103 X_creation_date DATE,
104 X_last_updated_by NUMBER,
105 X_last_update_date DATE,
106 X_last_update_login NUMBER);
107
108 --
109 -- Procedure
110 -- Delete_Row
111 -- Purpose
112 -- To delete a row from xtr_forecast_periods.
113 -- History
114 -- 12/24/98 BHCHUNG Created
115 -- Example
116 -- XTR_FORECAST_PERIODS_PKG.Delete_Row(...);
117 -- Notes
118 --
119 PROCEDURE Delete_Row(X_rowid VARCHAR2);
120
121 /*
122 --
123 -- Procedure
124 -- Delete_Forecast_Cells
125 -- Purpose
126 -- To delete all forecast cells belonging the forecast template period
127 -- History
128 -- 12/24/98 BHCHUNG Created
129 -- Example
130 -- XTR_FORECAST_PERIODS_PKG.Delete_Forecast_Cells(...)
131 -- Notes
132 --
133 PROCEDURE Delete_Forecast_Cells(X_rowid VARCHAR2);
134 */
135
136 END XTR_FORECAST_PERIODS_PKG;
137