PACKAGE: APPS.CSC_PROF_TABLE_COLUMNS_PKG

Source

1 PACKAGE CSC_PROF_TABLE_COLUMNS_PKG AUTHID CURRENT_USER as
2 /* $Header: csctptcs.pls 120.1 2005/08/23 23:26:11 vshastry noship $ */
3 -- Start of Comments
4 -- Package name     : CSC_PROF_TABLE_COLUMNS_PKG
5 -- Purpose          :
6 -- History          : 24-Feb-2003, Introduced new procedure delete_existing_row to
7 --                    delete before loading the rows
8 -- NOTE             :
9 -- End of Comments
10 
11 PROCEDURE Insert_Row(
12           px_TABLE_COLUMN_ID   IN OUT NOCOPY NUMBER,
13           p_BLOCK_ID    NUMBER,
14           p_TABLE_NAME    VARCHAR2,
15           p_COLUMN_NAME    VARCHAR2,
16           p_LABEL    VARCHAR2,
17           p_TABLE_ALIAS VARCHAR2,
18           p_COLUMN_SEQUENCE NUMBER,
19 		    p_DRILLDOWN_COLUMN_FLAG VARCHAR2,
20           p_LAST_UPDATE_DATE    DATE,
21           p_LAST_UPDATED_BY    NUMBER,
22           p_CREATION_DATE    DATE,
23           p_CREATED_BY    NUMBER,
24           p_LAST_UPDATE_LOGIN    NUMBER,
25           p_SEEDED_FLAG   VARCHAR2,
26           x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER);
27 
28 PROCEDURE Update_Row(
29           p_TABLE_COLUMN_ID    NUMBER,
30           p_BLOCK_ID    NUMBER,
31           p_TABLE_NAME    VARCHAR2,
32           p_COLUMN_NAME    VARCHAR2,
33           p_LABEL    VARCHAR2,
34           p_TABLE_ALIAS VARCHAR2,
35           p_COLUMN_SEQUENCE NUMBER,
36 		    p_DRILLDOWN_COLUMN_FLAG VARCHAR2,
37           p_LAST_UPDATE_DATE    DATE,
38           p_LAST_UPDATED_BY    NUMBER,
39           p_LAST_UPDATE_LOGIN    NUMBER,
40           p_SEEDED_FLAG   VARCHAR2,
41           px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER);
42 
43 procedure LOCK_ROW (
44   P_TABLE_COLUMN_ID in NUMBER,
45   P_OBJECT_VERSION_NUMBER in NUMBER
46 );
47 
48 procedure DELETE_ROW (
49   P_TABLE_COLUMN_ID in NUMBER,
50   P_OBJECT_VERSION_NUMBER NUMBER
51 );
52 
53 Procedure Add_Language;
54 
55 Procedure TRANSLATE_ROW (
56    p_LABEL              in varchar2,
57    p_TABLE_COLUMN_ID    in number,
58    p_OWNER              in varchar2 );
59 
60 Procedure DELETE_EXISTING_ROW(
61    	p_BLOCK_ID		IN NUMBER,
62    	p_TABLE_NAME   IN VARCHAR2,
63    	p_COLUMN_NAME  IN VARCHAR2);
64 
65 Procedure LOAD_ROW (
66    p_TABLE_COLUMN_ID        in number,
67    p_BLOCK_ID               in number,
68    p_TABLE_NAME             in varchar2,
69    p_COLUMN_NAME            in varchar2,
70    p_LABEL                  in varchar2,
71    p_ALIAS_NAME             in varchar2,
72    p_COLUMN_SEQUENCE        in number,
73    p_DRILLDOWN_COLUMN_FLAG  in varchar2,
74    p_SEEDED_FLAG            in varchar2,
75    p_last_update_date       IN DATE,
76    p_last_updated_by        IN NUMBER,
77    p_last_update_login      IN NUMBER);
78 
79 
80 
81 End CSC_PROF_TABLE_COLUMNS_PKG;