[Home] [Help]
PACKAGE: APPS.CSC_PROF_TABLE_COLUMNS_PKG
Source
1 PACKAGE CSC_PROF_TABLE_COLUMNS_PKG 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;