eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_SSC_UTIL dependencies on QP_SSC_UTIL

Line 1: PACKAGE BODY QP_Ssc_Util AS

1: PACKAGE BODY QP_Ssc_Util AS
2: /* $Header: QPXUSSCB.pls 120.1 2005/06/14 00:16:11 appldev $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Ssc_Util';

2: /* $Header: QPXUSSCB.pls 120.1 2005/06/14 00:16:11 appldev $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Ssc_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr

Line 35: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_APPLICATION_SHORT_NAME;

31:
32: IF NOT QP_GLOBALS.Equal(p_SSC_rec.application_short_name,p_old_SSC_rec.application_short_name)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_APPLICATION_SHORT_NAME;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute1,p_old_SSC_rec.attribute1)
39: THEN

Line 41: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE1;

37:
38: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute1,p_old_SSC_rec.attribute1)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE1;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute10,p_old_SSC_rec.attribute10)
45: THEN

Line 47: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE10;

43:
44: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute10,p_old_SSC_rec.attribute10)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE10;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute11,p_old_SSC_rec.attribute11)
51: THEN

Line 53: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE11;

49:
50: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute11,p_old_SSC_rec.attribute11)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE11;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute12,p_old_SSC_rec.attribute12)
57: THEN

Line 59: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE12;

55:
56: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute12,p_old_SSC_rec.attribute12)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE12;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute13,p_old_SSC_rec.attribute13)
63: THEN

Line 65: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE13;

61:
62: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute13,p_old_SSC_rec.attribute13)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE13;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute14,p_old_SSC_rec.attribute14)
69: THEN

Line 71: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE14;

67:
68: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute14,p_old_SSC_rec.attribute14)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE14;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute15,p_old_SSC_rec.attribute15)
75: THEN

Line 77: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE15;

73:
74: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute15,p_old_SSC_rec.attribute15)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE15;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute2,p_old_SSC_rec.attribute2)
81: THEN

Line 83: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE2;

79:
80: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute2,p_old_SSC_rec.attribute2)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE2;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute3,p_old_SSC_rec.attribute3)
87: THEN

Line 89: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE3;

85:
86: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute3,p_old_SSC_rec.attribute3)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE3;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute4,p_old_SSC_rec.attribute4)
93: THEN

Line 95: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE4;

91:
92: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute4,p_old_SSC_rec.attribute4)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE4;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute5,p_old_SSC_rec.attribute5)
99: THEN

Line 101: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE5;

97:
98: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute5,p_old_SSC_rec.attribute5)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE5;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute6,p_old_SSC_rec.attribute6)
105: THEN

Line 107: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE6;

103:
104: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute6,p_old_SSC_rec.attribute6)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE6;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute7,p_old_SSC_rec.attribute7)
111: THEN

Line 113: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE7;

109:
110: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute7,p_old_SSC_rec.attribute7)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE7;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute8,p_old_SSC_rec.attribute8)
117: THEN

Line 119: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE8;

115:
116: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute8,p_old_SSC_rec.attribute8)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE8;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute9,p_old_SSC_rec.attribute9)
123: THEN

Line 125: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE9;

121:
122: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute9,p_old_SSC_rec.attribute9)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE9;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_SSC_rec.context,p_old_SSC_rec.context)
129: THEN

Line 131: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CONTEXT;

127:
128: IF NOT QP_GLOBALS.Equal(p_SSC_rec.context,p_old_SSC_rec.context)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CONTEXT;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_SSC_rec.created_by,p_old_SSC_rec.created_by)
135: THEN

Line 137: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATED_BY;

133:
134: IF NOT QP_GLOBALS.Equal(p_SSC_rec.created_by,p_old_SSC_rec.created_by)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATED_BY;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_SSC_rec.creation_date,p_old_SSC_rec.creation_date)
141: THEN

Line 143: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATION_DATE;

139:
140: IF NOT QP_GLOBALS.Equal(p_SSC_rec.creation_date,p_old_SSC_rec.creation_date)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATION_DATE;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,p_old_SSC_rec.enabled_flag)
147: THEN

Line 149: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ENABLED;

145:
146: IF NOT QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,p_old_SSC_rec.enabled_flag)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ENABLED;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,p_old_SSC_rec.last_updated_by)
153: THEN

Line 155: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATED_BY;

151:
152: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,p_old_SSC_rec.last_updated_by)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATED_BY;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_update_date,p_old_SSC_rec.last_update_date)
159: THEN

Line 161: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_DATE;

157:
158: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_update_date,p_old_SSC_rec.last_update_date)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_DATE;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_update_login,p_old_SSC_rec.last_update_login)
165: THEN

Line 167: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_LOGIN;

163:
164: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_update_login,p_old_SSC_rec.last_update_login)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_LOGIN;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_application_id,p_old_SSC_rec.program_application_id)
171: THEN

Line 173: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_APPLICATION;

169:
170: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_application_id,p_old_SSC_rec.program_application_id)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_APPLICATION;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_id,p_old_SSC_rec.program_id)
177: THEN

Line 179: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM;

175:
176: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_id,p_old_SSC_rec.program_id)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_update_date,p_old_SSC_rec.program_update_date)
183: THEN

Line 185: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_UPDATE_DATE;

181:
182: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_update_date,p_old_SSC_rec.program_update_date)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_UPDATE_DATE;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_SSC_rec.pte_code,p_old_SSC_rec.pte_code)
189: THEN

Line 191: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE;

187:
188: IF NOT QP_GLOBALS.Equal(p_SSC_rec.pte_code,p_old_SSC_rec.pte_code)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_SSC_rec.pte_source_system_id,p_old_SSC_rec.pte_source_system_id)
195: THEN

Line 197: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE_SOURCE_SYSTEM;

193:
194: IF NOT QP_GLOBALS.Equal(p_SSC_rec.pte_source_system_id,p_old_SSC_rec.pte_source_system_id)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE_SOURCE_SYSTEM;
198: END IF;
199:
200: ELSIF p_attr_id = G_APPLICATION_SHORT_NAME THEN
201: l_index := l_index + 1;

Line 202: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_APPLICATION_SHORT_NAME;

198: END IF;
199:
200: ELSIF p_attr_id = G_APPLICATION_SHORT_NAME THEN
201: l_index := l_index + 1;
202: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_APPLICATION_SHORT_NAME;
203: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE1;
206: ELSIF p_attr_id = G_ATTRIBUTE10 THEN

Line 205: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE1;

201: l_index := l_index + 1;
202: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_APPLICATION_SHORT_NAME;
203: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE1;
206: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
207: l_index := l_index + 1;
208: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE10;
209: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 208: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE10;

204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE1;
206: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
207: l_index := l_index + 1;
208: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE10;
209: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE11;
212: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 211: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE11;

207: l_index := l_index + 1;
208: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE10;
209: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE11;
212: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE12;
215: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 214: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE12;

210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE11;
212: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE12;
215: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE13;
218: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 217: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE13;

213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE12;
215: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE13;
218: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
219: l_index := l_index + 1;
220: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE14;
221: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 220: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE14;

216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE13;
218: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
219: l_index := l_index + 1;
220: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE14;
221: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE15;
224: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 223: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE15;

219: l_index := l_index + 1;
220: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE14;
221: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE15;
224: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
225: l_index := l_index + 1;
226: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE2;
227: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 226: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE2;

222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE15;
224: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
225: l_index := l_index + 1;
226: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE2;
227: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE3;
230: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 229: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE3;

225: l_index := l_index + 1;
226: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE2;
227: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE3;
230: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
231: l_index := l_index + 1;
232: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE4;
233: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 232: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE4;

228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE3;
230: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
231: l_index := l_index + 1;
232: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE4;
233: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE5;
236: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 235: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE5;

231: l_index := l_index + 1;
232: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE4;
233: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE5;
236: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
237: l_index := l_index + 1;
238: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE6;
239: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 238: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE6;

234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE5;
236: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
237: l_index := l_index + 1;
238: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE6;
239: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE7;
242: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 241: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE7;

237: l_index := l_index + 1;
238: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE6;
239: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE7;
242: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
243: l_index := l_index + 1;
244: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE8;
245: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 244: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE8;

240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE7;
242: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
243: l_index := l_index + 1;
244: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE8;
245: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE9;
248: ELSIF p_attr_id = G_CONTEXT THEN

Line 247: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE9;

243: l_index := l_index + 1;
244: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE8;
245: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE9;
248: ELSIF p_attr_id = G_CONTEXT THEN
249: l_index := l_index + 1;
250: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CONTEXT;
251: ELSIF p_attr_id = G_CREATED_BY THEN

Line 250: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CONTEXT;

246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE9;
248: ELSIF p_attr_id = G_CONTEXT THEN
249: l_index := l_index + 1;
250: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CONTEXT;
251: ELSIF p_attr_id = G_CREATED_BY THEN
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATED_BY;
254: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 253: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATED_BY;

249: l_index := l_index + 1;
250: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CONTEXT;
251: ELSIF p_attr_id = G_CREATED_BY THEN
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATED_BY;
254: ELSIF p_attr_id = G_CREATION_DATE THEN
255: l_index := l_index + 1;
256: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATION_DATE;
257: ELSIF p_attr_id = G_ENABLED THEN

Line 256: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATION_DATE;

252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATED_BY;
254: ELSIF p_attr_id = G_CREATION_DATE THEN
255: l_index := l_index + 1;
256: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATION_DATE;
257: ELSIF p_attr_id = G_ENABLED THEN
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ENABLED;
260: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 259: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ENABLED;

255: l_index := l_index + 1;
256: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATION_DATE;
257: ELSIF p_attr_id = G_ENABLED THEN
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ENABLED;
260: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
261: l_index := l_index + 1;
262: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATED_BY;
263: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 262: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATED_BY;

258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ENABLED;
260: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
261: l_index := l_index + 1;
262: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATED_BY;
263: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_DATE;
266: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 265: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_DATE;

261: l_index := l_index + 1;
262: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATED_BY;
263: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_DATE;
266: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
267: l_index := l_index + 1;
268: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_LOGIN;
269: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN

Line 268: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_LOGIN;

264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_DATE;
266: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
267: l_index := l_index + 1;
268: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_LOGIN;
269: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_APPLICATION;
272: ELSIF p_attr_id = G_PROGRAM THEN

Line 271: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_APPLICATION;

267: l_index := l_index + 1;
268: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_LOGIN;
269: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_APPLICATION;
272: ELSIF p_attr_id = G_PROGRAM THEN
273: l_index := l_index + 1;
274: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM;
275: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN

Line 274: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM;

270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_APPLICATION;
272: ELSIF p_attr_id = G_PROGRAM THEN
273: l_index := l_index + 1;
274: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM;
275: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_UPDATE_DATE;
278: ELSIF p_attr_id = G_PTE THEN

Line 277: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_UPDATE_DATE;

273: l_index := l_index + 1;
274: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM;
275: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_UPDATE_DATE;
278: ELSIF p_attr_id = G_PTE THEN
279: l_index := l_index + 1;
280: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE;
281: ELSIF p_attr_id = G_PTE_SOURCE_SYSTEM THEN

Line 280: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE;

276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_UPDATE_DATE;
278: ELSIF p_attr_id = G_PTE THEN
279: l_index := l_index + 1;
280: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE;
281: ELSIF p_attr_id = G_PTE_SOURCE_SYSTEM THEN
282: l_index := l_index + 1;
283: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE_SOURCE_SYSTEM;
284: END IF;

Line 283: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE_SOURCE_SYSTEM;

279: l_index := l_index + 1;
280: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE;
281: ELSIF p_attr_id = G_PTE_SOURCE_SYSTEM THEN
282: l_index := l_index + 1;
283: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE_SOURCE_SYSTEM;
284: END IF;
285:
286: END Clear_Dependent_Attr;
287:

Line 1386: END QP_Ssc_Util;

1382: RETURN l_SSC_rec;
1383:
1384: END Get_Ids;
1385:
1386: END QP_Ssc_Util;