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