1 PACKAGE JTF_SOURCES_PKG AS
2 /* $Header: jtfvsrcs.pls 120.5 2006/03/28 18:20:36 achanda ship $ */
3 --
4 -- arpatel 06/25/01 - Added related_id columns (1-5) to insert/update/lock procedures
5 --
6
7
8 PROCEDURE Insert_Row(
9 x_Rowid IN OUT NOCOPY VARCHAR2,
10 x_SOURCE_ID IN OUT NOCOPY NUMBER,
11 x_LAST_UPDATE_DATE IN DATE,
12 x_LAST_UPDATED_BY IN NUMBER,
13 x_CREATION_DATE IN DATE,
14 x_CREATED_BY IN NUMBER,
15 x_LAST_UPDATE_LOGIN IN NUMBER,
16 x_LOOKUP_CODE IN VARCHAR2,
17 x_LOOKUP_TYPE IN VARCHAR2,
18 x_MEANING IN VARCHAR2,
19 x_ENABLED_FLAG IN VARCHAR2,
20 x_DESCRIPTION IN VARCHAR2,
21 x_START_DATE_ACTIVE IN DATE,
22 x_END_DATE_ACTIVE IN DATE,
23 x_RELATED_ID1 IN NUMBER,
24 x_RELATED_ID2 IN NUMBER,
25 x_RELATED_ID3 IN NUMBER,
26 x_RELATED_ID4 IN NUMBER,
27 x_RELATED_ID5 IN NUMBER,
28 X_RSC_COL_NAME IN VARCHAR2,
29 X_ROLE_COL_NAME IN VARCHAR2,
30 X_GROUP_COL_NAME IN VARCHAR2,
31 X_RSC_LOV_SQL IN VARCHAR2,
32 X_RSC_ACCESS_LKUP IN VARCHAR2,
33 X_DENORM_VALUE_TABLE_NAME IN VARCHAR2,
34 X_DENORM_DEA_VALUE_TABLE_NAME IN VARCHAR2,
35 x_ORG_ID IN NUMBER);
36
37
38
39 PROCEDURE Lock_Row(
40 x_Rowid IN VARCHAR2,
41 x_SOURCE_ID IN NUMBER,
42 x_LAST_UPDATE_DATE IN DATE,
43 x_LAST_UPDATED_BY IN NUMBER,
44 x_CREATION_DATE IN DATE,
45 x_CREATED_BY IN NUMBER,
46 x_LAST_UPDATE_LOGIN IN NUMBER,
47 x_LOOKUP_CODE IN VARCHAR2,
48 x_LOOKUP_TYPE IN VARCHAR2,
49 x_MEANING IN VARCHAR2,
50 x_ENABLED_FLAG IN VARCHAR2,
51 x_DESCRIPTION IN VARCHAR2,
52 x_START_DATE_ACTIVE IN DATE,
53 x_END_DATE_ACTIVE IN DATE,
54 x_RELATED_ID1 IN NUMBER,
55 x_RELATED_ID2 IN NUMBER,
56 x_RELATED_ID3 IN NUMBER,
57 x_RELATED_ID4 IN NUMBER,
58 x_RELATED_ID5 IN NUMBER,
59 x_ORG_ID IN NUMBER);
60
61
62
63 PROCEDURE Update_Row(
64 x_Rowid IN VARCHAR2,
65 x_SOURCE_ID IN NUMBER,
66 x_LAST_UPDATE_DATE IN DATE,
67 x_LAST_UPDATED_BY IN NUMBER,
68 x_CREATION_DATE IN DATE,
69 x_CREATED_BY IN NUMBER,
70 x_LAST_UPDATE_LOGIN IN NUMBER,
71 x_LOOKUP_CODE IN VARCHAR2,
72 x_LOOKUP_TYPE IN VARCHAR2,
73 x_MEANING IN VARCHAR2,
74 x_ENABLED_FLAG IN VARCHAR2,
75 x_DESCRIPTION IN VARCHAR2,
76 x_START_DATE_ACTIVE IN DATE,
77 x_END_DATE_ACTIVE IN DATE,
78 x_RELATED_ID1 IN NUMBER,
79 x_RELATED_ID2 IN NUMBER,
80 x_RELATED_ID3 IN NUMBER,
81 x_RELATED_ID4 IN NUMBER,
82 x_RELATED_ID5 IN NUMBER,
83 x_ORG_ID IN NUMBER);
84
85
86
87 PROCEDURE Delete_Row( x_SOURCE_ID IN NUMBER);
88
89
90 END JTF_SOURCES_PKG;