PACKAGE: APPS.CN_DIMENSIONS_PKG

Source

1 PACKAGE CN_DIMENSIONS_PKG AUTHID CURRENT_USER as
2 -- $Header: cndidims.pls 120.3 2005/12/13 01:48:38 hanaraya noship $
3 
4 
5   --+
6   -- Procedure Name
7   --   insert_row
8   -- Purpose
9   --   Procedure determining whether an event is valid based upon the current
10   --   status of an object and whether a
11   --   states.
12   -- History
13   --   12/28/93		Paul Mitchell		Created
14 --
15 --  old insert_row before MLS change
16 --  PROCEDURE insert_row(
17 --	X_rowid			IN OUT	varchar2,
18 --        X_dimension_id          IN OUT  number,
19 --        X_name				varchar2,
20 --        X_description			varchar2	default	NULL);
21 
22   procedure INSERT_ROW (
23   X_DIMENSION_ID in NUMBER,
24   X_DESCRIPTION in VARCHAR2,
25   X_SOURCE_TABLE_ID in NUMBER,
26   X_NAME in VARCHAR2,
27   X_CREATION_DATE in DATE,
28   X_CREATED_BY in NUMBER,
29   X_LAST_UPDATE_DATE in DATE,
30   X_LAST_UPDATED_BY in NUMBER,
31   X_LAST_UPDATE_LOGIN in NUMBER,
32   --R12 MOAC Changes--Start
33   X_ORG_ID	in NUMBER
34 --R12 MOAC Changes--End
35 );
36 
37   --+
38   -- Procedure Name
39   --   update_row
40   -- History
41   --   12/28/93		Paul Mitchell		Created
42   --+
43 --  PROCEDURE update_row(
44 --	X_rowid                         varchar2,
45 --        X_dimension_id                  number,
46 --        X_name                          varchar2,
47 --        X_Description                   varchar2	default NULL);
48 
49   procedure UPDATE_ROW (
50   X_DIMENSION_ID in NUMBER,
51   X_DESCRIPTION in VARCHAR2,
52   X_SOURCE_TABLE_ID in NUMBER,
53   X_NAME in VARCHAR2,
54   X_LAST_UPDATE_DATE in DATE,
55   X_LAST_UPDATED_BY in NUMBER,
56   X_LAST_UPDATE_LOGIN in NUMBER,
57   --R12 MOAC Changes--Start
58   X_ORG_ID	in NUMBER,
59   X_OBJECT_VERSION_NUMBER in out NOCOPY  CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE);
60 --R12 MOAC Changes--End
61 
62 
63   --+
64   -- Procedure Name
65   --   delete_row
66   -- History
67   --   12/28/93		Paul Mitchell		Created
68   --+
69 -- old delete_row before MLS change
70   --  PROCEDURE delete_row(X_rowid		 varchar2);
71 
72 procedure DELETE_ROW (X_DIMENSION_ID in NUMBER,X_ORG_ID in NUMBER);
73 
74 
75 procedure add_language;
76 
77 -- --------------------------------------------------------------------+
78 -- Procedure : LOAD_ROW
79 -- Description : Called by FNDLOAD to upload seed datas, this procedure
80 --    only handle seed datas. ORG_ID = -3113
81 -- --------------------------------------------------------------------+
82 PROCEDURE LOAD_ROW
83   ( x_dimension_id IN NUMBER,
84     x_org_id in NUMBER, -- R12 change
85     x_description IN VARCHAR2,
86     x_source_table_id IN NUMBER,
87     x_name IN VARCHAR2,
88     x_owner IN VARCHAR2);
89 
90 -- --------------------------------------------------------------------+
91 -- Procedure : TRANSLATE_ROW
92 -- Description : Called by FNDLOAD to translate seed datas, this procedure
93 --    only handle seed datas. ORG_ID = -3113
94 -- --------------------------------------------------------------------+
95 PROCEDURE TRANSLATE_ROW
96   ( x_dimension_id IN NUMBER,
97     x_name IN VARCHAR2,
98     x_owner IN VARCHAR2);
99 
100 FUNCTION New_Dimension RETURN NUMBER;
101 
102 END CN_DIMENSIONS_PKG;