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_PSG_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record

Line 20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record
24:

Line 32: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute1,p_old_PSG_rec.attribute1)

28: -- every changed attribute clear its dependent fields.
29:
30: IF p_attr_id = FND_API.G_MISS_NUM THEN
31:
32: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute1,p_old_PSG_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE1;
36: END IF;

Line 38: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute10,p_old_PSG_rec.attribute10)

34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE1;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute10,p_old_PSG_rec.attribute10)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE10;
42: END IF;

Line 44: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute11,p_old_PSG_rec.attribute11)

40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE10;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute11,p_old_PSG_rec.attribute11)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE11;
48: END IF;

Line 50: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute12,p_old_PSG_rec.attribute12)

46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE11;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute12,p_old_PSG_rec.attribute12)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE12;
54: END IF;

Line 56: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute13,p_old_PSG_rec.attribute13)

52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE12;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute13,p_old_PSG_rec.attribute13)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE13;
60: END IF;

Line 62: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute14,p_old_PSG_rec.attribute14)

58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE13;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute14,p_old_PSG_rec.attribute14)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE14;
66: END IF;

Line 68: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute15,p_old_PSG_rec.attribute15)

64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE14;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute15,p_old_PSG_rec.attribute15)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE15;
72: END IF;

Line 74: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute2,p_old_PSG_rec.attribute2)

70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE15;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute2,p_old_PSG_rec.attribute2)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE2;
78: END IF;

Line 80: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute3,p_old_PSG_rec.attribute3)

76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE2;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute3,p_old_PSG_rec.attribute3)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE3;
84: END IF;

Line 86: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute4,p_old_PSG_rec.attribute4)

82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE3;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute4,p_old_PSG_rec.attribute4)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE4;
90: END IF;

Line 92: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute5,p_old_PSG_rec.attribute5)

88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE4;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute5,p_old_PSG_rec.attribute5)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE5;
96: END IF;

Line 98: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute6,p_old_PSG_rec.attribute6)

94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE5;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute6,p_old_PSG_rec.attribute6)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE6;
102: END IF;

Line 104: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute7,p_old_PSG_rec.attribute7)

100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE6;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute7,p_old_PSG_rec.attribute7)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE7;
108: END IF;

Line 110: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute8,p_old_PSG_rec.attribute8)

106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE7;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute8,p_old_PSG_rec.attribute8)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE8;
114: END IF;

Line 116: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute9,p_old_PSG_rec.attribute9)

112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE8;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute9,p_old_PSG_rec.attribute9)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE9;
120: END IF;

Line 122: IF NOT QP_GLOBALS.Equal(p_PSG_rec.context,p_old_PSG_rec.context)

118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_PSG_rec.context,p_old_PSG_rec.context)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_CONTEXT;
126: END IF;

Line 128: IF NOT QP_GLOBALS.Equal(p_PSG_rec.created_by,p_old_PSG_rec.created_by)

124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_CONTEXT;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_PSG_rec.created_by,p_old_PSG_rec.created_by)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_CREATED_BY;
132: END IF;

Line 134: IF NOT QP_GLOBALS.Equal(p_PSG_rec.creation_date,p_old_PSG_rec.creation_date)

130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_CREATED_BY;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_PSG_rec.creation_date,p_old_PSG_rec.creation_date)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_CREATION_DATE;
138: END IF;

Line 140: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,p_old_PSG_rec.last_updated_by)

136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_CREATION_DATE;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,p_old_PSG_rec.last_updated_by)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATED_BY;
144: END IF;

Line 146: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_date,p_old_PSG_rec.last_update_date)

142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATED_BY;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_date,p_old_PSG_rec.last_update_date)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATE_DATE;
150: END IF;

Line 152: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_login,p_old_PSG_rec.last_update_login)

148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATE_DATE;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_login,p_old_PSG_rec.last_update_login)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATE_LOGIN;
156: END IF;

Line 158: IF NOT QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,p_old_PSG_rec.limits_enabled)

154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATE_LOGIN;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,p_old_PSG_rec.limits_enabled)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LIMITS_ENABLED;
162: END IF;

Line 164: IF NOT QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,p_old_PSG_rec.lov_enabled)

160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LIMITS_ENABLED;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,p_old_PSG_rec.lov_enabled)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LOV_ENABLED;
168: END IF;

Line 170: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_application_id,p_old_PSG_rec.program_application_id)

166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LOV_ENABLED;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_application_id,p_old_PSG_rec.program_application_id)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM_APPLICATION;
174: END IF;

Line 176: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_id,p_old_PSG_rec.program_id)

172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM_APPLICATION;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_id,p_old_PSG_rec.program_id)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM;
180: END IF;

Line 182: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_update_date,p_old_PSG_rec.program_update_date)

178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_update_date,p_old_PSG_rec.program_update_date)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM_UPDATE_DATE;
186: END IF;

Line 188: IF NOT QP_GLOBALS.Equal(p_PSG_rec.pte_code,p_old_PSG_rec.pte_code)

184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM_UPDATE_DATE;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_PSG_rec.pte_code,p_old_PSG_rec.pte_code)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PTE;
192: END IF;

Line 194: IF NOT QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,p_old_PSG_rec.seeded_sourcing_method)

190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PTE;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,p_old_PSG_rec.seeded_sourcing_method)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEEDED_SOURCING_METHOD;
198: END IF;

Line 200: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_id,p_old_PSG_rec.segment_id)

196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEEDED_SOURCING_METHOD;
198: END IF;
199:
200: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_id,p_old_PSG_rec.segment_id)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEGMENT;
204: END IF;

Line 206: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_level,p_old_PSG_rec.segment_level)

202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEGMENT;
204: END IF;
205:
206: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_level,p_old_PSG_rec.segment_level)
207: THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEGMENT_LEVEL;
210: END IF;

Line 212: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,p_old_PSG_rec.segment_pte_id)

208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEGMENT_LEVEL;
210: END IF;
211:
212: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,p_old_PSG_rec.segment_pte_id)
213: THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEGMENT_PTE;
216: END IF;

Line 218: IF NOT QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,p_old_PSG_rec.sourcing_enabled)

214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEGMENT_PTE;
216: END IF;
217:
218: IF NOT QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,p_old_PSG_rec.sourcing_enabled)
219: THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SOURCING_ENABLED;
222: END IF;

Line 224: IF NOT QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,p_old_PSG_rec.sourcing_status)

220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SOURCING_ENABLED;
222: END IF;
223:
224: IF NOT QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,p_old_PSG_rec.sourcing_status)
225: THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SOURCING_STATUS;
228: END IF;

Line 230: IF NOT QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,p_old_PSG_rec.user_sourcing_method)

226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SOURCING_STATUS;
228: END IF;
229:
230: IF NOT QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,p_old_PSG_rec.user_sourcing_method)
231: THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_USER_SOURCING_METHOD;
234: END IF;

Line 357: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute1,p_old_PSG_rec.attribute1)

353: -- Load out record
354:
355: x_PSG_rec := p_PSG_rec;
356:
357: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute1,p_old_PSG_rec.attribute1)
358: THEN
359: NULL;
360: END IF;
361:

Line 362: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute10,p_old_PSG_rec.attribute10)

358: THEN
359: NULL;
360: END IF;
361:
362: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute10,p_old_PSG_rec.attribute10)
363: THEN
364: NULL;
365: END IF;
366:

Line 367: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute11,p_old_PSG_rec.attribute11)

363: THEN
364: NULL;
365: END IF;
366:
367: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute11,p_old_PSG_rec.attribute11)
368: THEN
369: NULL;
370: END IF;
371:

Line 372: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute12,p_old_PSG_rec.attribute12)

368: THEN
369: NULL;
370: END IF;
371:
372: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute12,p_old_PSG_rec.attribute12)
373: THEN
374: NULL;
375: END IF;
376:

Line 377: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute13,p_old_PSG_rec.attribute13)

373: THEN
374: NULL;
375: END IF;
376:
377: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute13,p_old_PSG_rec.attribute13)
378: THEN
379: NULL;
380: END IF;
381:

Line 382: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute14,p_old_PSG_rec.attribute14)

378: THEN
379: NULL;
380: END IF;
381:
382: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute14,p_old_PSG_rec.attribute14)
383: THEN
384: NULL;
385: END IF;
386:

Line 387: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute15,p_old_PSG_rec.attribute15)

383: THEN
384: NULL;
385: END IF;
386:
387: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute15,p_old_PSG_rec.attribute15)
388: THEN
389: NULL;
390: END IF;
391:

Line 392: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute2,p_old_PSG_rec.attribute2)

388: THEN
389: NULL;
390: END IF;
391:
392: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute2,p_old_PSG_rec.attribute2)
393: THEN
394: NULL;
395: END IF;
396:

Line 397: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute3,p_old_PSG_rec.attribute3)

393: THEN
394: NULL;
395: END IF;
396:
397: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute3,p_old_PSG_rec.attribute3)
398: THEN
399: NULL;
400: END IF;
401:

Line 402: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute4,p_old_PSG_rec.attribute4)

398: THEN
399: NULL;
400: END IF;
401:
402: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute4,p_old_PSG_rec.attribute4)
403: THEN
404: NULL;
405: END IF;
406:

Line 407: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute5,p_old_PSG_rec.attribute5)

403: THEN
404: NULL;
405: END IF;
406:
407: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute5,p_old_PSG_rec.attribute5)
408: THEN
409: NULL;
410: END IF;
411:

Line 412: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute6,p_old_PSG_rec.attribute6)

408: THEN
409: NULL;
410: END IF;
411:
412: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute6,p_old_PSG_rec.attribute6)
413: THEN
414: NULL;
415: END IF;
416:

Line 417: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute7,p_old_PSG_rec.attribute7)

413: THEN
414: NULL;
415: END IF;
416:
417: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute7,p_old_PSG_rec.attribute7)
418: THEN
419: NULL;
420: END IF;
421:

Line 422: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute8,p_old_PSG_rec.attribute8)

418: THEN
419: NULL;
420: END IF;
421:
422: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute8,p_old_PSG_rec.attribute8)
423: THEN
424: NULL;
425: END IF;
426:

Line 427: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute9,p_old_PSG_rec.attribute9)

423: THEN
424: NULL;
425: END IF;
426:
427: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute9,p_old_PSG_rec.attribute9)
428: THEN
429: NULL;
430: END IF;
431:

Line 432: IF NOT QP_GLOBALS.Equal(p_PSG_rec.context,p_old_PSG_rec.context)

428: THEN
429: NULL;
430: END IF;
431:
432: IF NOT QP_GLOBALS.Equal(p_PSG_rec.context,p_old_PSG_rec.context)
433: THEN
434: NULL;
435: END IF;
436:

Line 437: IF NOT QP_GLOBALS.Equal(p_PSG_rec.created_by,p_old_PSG_rec.created_by)

433: THEN
434: NULL;
435: END IF;
436:
437: IF NOT QP_GLOBALS.Equal(p_PSG_rec.created_by,p_old_PSG_rec.created_by)
438: THEN
439: NULL;
440: END IF;
441:

Line 442: IF NOT QP_GLOBALS.Equal(p_PSG_rec.creation_date,p_old_PSG_rec.creation_date)

438: THEN
439: NULL;
440: END IF;
441:
442: IF NOT QP_GLOBALS.Equal(p_PSG_rec.creation_date,p_old_PSG_rec.creation_date)
443: THEN
444: NULL;
445: END IF;
446:

Line 447: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,p_old_PSG_rec.last_updated_by)

443: THEN
444: NULL;
445: END IF;
446:
447: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,p_old_PSG_rec.last_updated_by)
448: THEN
449: NULL;
450: END IF;
451:

Line 452: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_date,p_old_PSG_rec.last_update_date)

448: THEN
449: NULL;
450: END IF;
451:
452: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_date,p_old_PSG_rec.last_update_date)
453: THEN
454: NULL;
455: END IF;
456:

Line 457: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_login,p_old_PSG_rec.last_update_login)

453: THEN
454: NULL;
455: END IF;
456:
457: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_login,p_old_PSG_rec.last_update_login)
458: THEN
459: NULL;
460: END IF;
461:

Line 462: IF NOT QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,p_old_PSG_rec.limits_enabled)

458: THEN
459: NULL;
460: END IF;
461:
462: IF NOT QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,p_old_PSG_rec.limits_enabled)
463: THEN
464: NULL;
465: END IF;
466:

Line 467: IF NOT QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,p_old_PSG_rec.lov_enabled)

463: THEN
464: NULL;
465: END IF;
466:
467: IF NOT QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,p_old_PSG_rec.lov_enabled)
468: THEN
469: NULL;
470: END IF;
471:

Line 472: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_application_id,p_old_PSG_rec.program_application_id)

468: THEN
469: NULL;
470: END IF;
471:
472: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_application_id,p_old_PSG_rec.program_application_id)
473: THEN
474: NULL;
475: END IF;
476:

Line 477: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_id,p_old_PSG_rec.program_id)

473: THEN
474: NULL;
475: END IF;
476:
477: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_id,p_old_PSG_rec.program_id)
478: THEN
479: NULL;
480: END IF;
481:

Line 482: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_update_date,p_old_PSG_rec.program_update_date)

478: THEN
479: NULL;
480: END IF;
481:
482: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_update_date,p_old_PSG_rec.program_update_date)
483: THEN
484: NULL;
485: END IF;
486:

Line 487: IF NOT QP_GLOBALS.Equal(p_PSG_rec.pte_code,p_old_PSG_rec.pte_code)

483: THEN
484: NULL;
485: END IF;
486:
487: IF NOT QP_GLOBALS.Equal(p_PSG_rec.pte_code,p_old_PSG_rec.pte_code)
488: THEN
489: NULL;
490: END IF;
491:

Line 492: IF NOT QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,p_old_PSG_rec.seeded_sourcing_method)

488: THEN
489: NULL;
490: END IF;
491:
492: IF NOT QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,p_old_PSG_rec.seeded_sourcing_method)
493: THEN
494: NULL;
495: END IF;
496:

Line 497: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_id,p_old_PSG_rec.segment_id)

493: THEN
494: NULL;
495: END IF;
496:
497: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_id,p_old_PSG_rec.segment_id)
498: THEN
499: NULL;
500: END IF;
501:

Line 502: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_level,p_old_PSG_rec.segment_level)

498: THEN
499: NULL;
500: END IF;
501:
502: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_level,p_old_PSG_rec.segment_level)
503: THEN
504: NULL;
505: END IF;
506:

Line 507: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,p_old_PSG_rec.segment_pte_id)

503: THEN
504: NULL;
505: END IF;
506:
507: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,p_old_PSG_rec.segment_pte_id)
508: THEN
509: NULL;
510: END IF;
511:

Line 512: IF NOT QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,p_old_PSG_rec.sourcing_enabled)

508: THEN
509: NULL;
510: END IF;
511:
512: IF NOT QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,p_old_PSG_rec.sourcing_enabled)
513: THEN
514: NULL;
515: END IF;
516:

Line 517: IF NOT QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,p_old_PSG_rec.sourcing_status)

513: THEN
514: NULL;
515: END IF;
516:
517: IF NOT QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,p_old_PSG_rec.sourcing_status)
518: THEN
519: NULL;
520: END IF;
521:

Line 522: IF NOT QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,p_old_PSG_rec.user_sourcing_method)

518: THEN
519: NULL;
520: END IF;
521:
522: IF NOT QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,p_old_PSG_rec.user_sourcing_method)
523: THEN
524: NULL;
525: END IF;
526:

Line 1278: IF QP_GLOBALS.Equal(p_PSG_rec.attribute1,

1274: FOR UPDATE NOWAIT;
1275:
1276: -- Row locked. Compare IN attributes to DB attributes.
1277:
1278: IF QP_GLOBALS.Equal(p_PSG_rec.attribute1,
1279: l_PSG_rec.attribute1)
1280: AND QP_GLOBALS.Equal(p_PSG_rec.attribute10,
1281: l_PSG_rec.attribute10)
1282: AND QP_GLOBALS.Equal(p_PSG_rec.attribute11,

Line 1280: AND QP_GLOBALS.Equal(p_PSG_rec.attribute10,

1276: -- Row locked. Compare IN attributes to DB attributes.
1277:
1278: IF QP_GLOBALS.Equal(p_PSG_rec.attribute1,
1279: l_PSG_rec.attribute1)
1280: AND QP_GLOBALS.Equal(p_PSG_rec.attribute10,
1281: l_PSG_rec.attribute10)
1282: AND QP_GLOBALS.Equal(p_PSG_rec.attribute11,
1283: l_PSG_rec.attribute11)
1284: AND QP_GLOBALS.Equal(p_PSG_rec.attribute12,

Line 1282: AND QP_GLOBALS.Equal(p_PSG_rec.attribute11,

1278: IF QP_GLOBALS.Equal(p_PSG_rec.attribute1,
1279: l_PSG_rec.attribute1)
1280: AND QP_GLOBALS.Equal(p_PSG_rec.attribute10,
1281: l_PSG_rec.attribute10)
1282: AND QP_GLOBALS.Equal(p_PSG_rec.attribute11,
1283: l_PSG_rec.attribute11)
1284: AND QP_GLOBALS.Equal(p_PSG_rec.attribute12,
1285: l_PSG_rec.attribute12)
1286: AND QP_GLOBALS.Equal(p_PSG_rec.attribute13,

Line 1284: AND QP_GLOBALS.Equal(p_PSG_rec.attribute12,

1280: AND QP_GLOBALS.Equal(p_PSG_rec.attribute10,
1281: l_PSG_rec.attribute10)
1282: AND QP_GLOBALS.Equal(p_PSG_rec.attribute11,
1283: l_PSG_rec.attribute11)
1284: AND QP_GLOBALS.Equal(p_PSG_rec.attribute12,
1285: l_PSG_rec.attribute12)
1286: AND QP_GLOBALS.Equal(p_PSG_rec.attribute13,
1287: l_PSG_rec.attribute13)
1288: AND QP_GLOBALS.Equal(p_PSG_rec.attribute14,

Line 1286: AND QP_GLOBALS.Equal(p_PSG_rec.attribute13,

1282: AND QP_GLOBALS.Equal(p_PSG_rec.attribute11,
1283: l_PSG_rec.attribute11)
1284: AND QP_GLOBALS.Equal(p_PSG_rec.attribute12,
1285: l_PSG_rec.attribute12)
1286: AND QP_GLOBALS.Equal(p_PSG_rec.attribute13,
1287: l_PSG_rec.attribute13)
1288: AND QP_GLOBALS.Equal(p_PSG_rec.attribute14,
1289: l_PSG_rec.attribute14)
1290: AND QP_GLOBALS.Equal(p_PSG_rec.attribute15,

Line 1288: AND QP_GLOBALS.Equal(p_PSG_rec.attribute14,

1284: AND QP_GLOBALS.Equal(p_PSG_rec.attribute12,
1285: l_PSG_rec.attribute12)
1286: AND QP_GLOBALS.Equal(p_PSG_rec.attribute13,
1287: l_PSG_rec.attribute13)
1288: AND QP_GLOBALS.Equal(p_PSG_rec.attribute14,
1289: l_PSG_rec.attribute14)
1290: AND QP_GLOBALS.Equal(p_PSG_rec.attribute15,
1291: l_PSG_rec.attribute15)
1292: AND QP_GLOBALS.Equal(p_PSG_rec.attribute2,

Line 1290: AND QP_GLOBALS.Equal(p_PSG_rec.attribute15,

1286: AND QP_GLOBALS.Equal(p_PSG_rec.attribute13,
1287: l_PSG_rec.attribute13)
1288: AND QP_GLOBALS.Equal(p_PSG_rec.attribute14,
1289: l_PSG_rec.attribute14)
1290: AND QP_GLOBALS.Equal(p_PSG_rec.attribute15,
1291: l_PSG_rec.attribute15)
1292: AND QP_GLOBALS.Equal(p_PSG_rec.attribute2,
1293: l_PSG_rec.attribute2)
1294: AND QP_GLOBALS.Equal(p_PSG_rec.attribute3,

Line 1292: AND QP_GLOBALS.Equal(p_PSG_rec.attribute2,

1288: AND QP_GLOBALS.Equal(p_PSG_rec.attribute14,
1289: l_PSG_rec.attribute14)
1290: AND QP_GLOBALS.Equal(p_PSG_rec.attribute15,
1291: l_PSG_rec.attribute15)
1292: AND QP_GLOBALS.Equal(p_PSG_rec.attribute2,
1293: l_PSG_rec.attribute2)
1294: AND QP_GLOBALS.Equal(p_PSG_rec.attribute3,
1295: l_PSG_rec.attribute3)
1296: AND QP_GLOBALS.Equal(p_PSG_rec.attribute4,

Line 1294: AND QP_GLOBALS.Equal(p_PSG_rec.attribute3,

1290: AND QP_GLOBALS.Equal(p_PSG_rec.attribute15,
1291: l_PSG_rec.attribute15)
1292: AND QP_GLOBALS.Equal(p_PSG_rec.attribute2,
1293: l_PSG_rec.attribute2)
1294: AND QP_GLOBALS.Equal(p_PSG_rec.attribute3,
1295: l_PSG_rec.attribute3)
1296: AND QP_GLOBALS.Equal(p_PSG_rec.attribute4,
1297: l_PSG_rec.attribute4)
1298: AND QP_GLOBALS.Equal(p_PSG_rec.attribute5,

Line 1296: AND QP_GLOBALS.Equal(p_PSG_rec.attribute4,

1292: AND QP_GLOBALS.Equal(p_PSG_rec.attribute2,
1293: l_PSG_rec.attribute2)
1294: AND QP_GLOBALS.Equal(p_PSG_rec.attribute3,
1295: l_PSG_rec.attribute3)
1296: AND QP_GLOBALS.Equal(p_PSG_rec.attribute4,
1297: l_PSG_rec.attribute4)
1298: AND QP_GLOBALS.Equal(p_PSG_rec.attribute5,
1299: l_PSG_rec.attribute5)
1300: AND QP_GLOBALS.Equal(p_PSG_rec.attribute6,

Line 1298: AND QP_GLOBALS.Equal(p_PSG_rec.attribute5,

1294: AND QP_GLOBALS.Equal(p_PSG_rec.attribute3,
1295: l_PSG_rec.attribute3)
1296: AND QP_GLOBALS.Equal(p_PSG_rec.attribute4,
1297: l_PSG_rec.attribute4)
1298: AND QP_GLOBALS.Equal(p_PSG_rec.attribute5,
1299: l_PSG_rec.attribute5)
1300: AND QP_GLOBALS.Equal(p_PSG_rec.attribute6,
1301: l_PSG_rec.attribute6)
1302: AND QP_GLOBALS.Equal(p_PSG_rec.attribute7,

Line 1300: AND QP_GLOBALS.Equal(p_PSG_rec.attribute6,

1296: AND QP_GLOBALS.Equal(p_PSG_rec.attribute4,
1297: l_PSG_rec.attribute4)
1298: AND QP_GLOBALS.Equal(p_PSG_rec.attribute5,
1299: l_PSG_rec.attribute5)
1300: AND QP_GLOBALS.Equal(p_PSG_rec.attribute6,
1301: l_PSG_rec.attribute6)
1302: AND QP_GLOBALS.Equal(p_PSG_rec.attribute7,
1303: l_PSG_rec.attribute7)
1304: AND QP_GLOBALS.Equal(p_PSG_rec.attribute8,

Line 1302: AND QP_GLOBALS.Equal(p_PSG_rec.attribute7,

1298: AND QP_GLOBALS.Equal(p_PSG_rec.attribute5,
1299: l_PSG_rec.attribute5)
1300: AND QP_GLOBALS.Equal(p_PSG_rec.attribute6,
1301: l_PSG_rec.attribute6)
1302: AND QP_GLOBALS.Equal(p_PSG_rec.attribute7,
1303: l_PSG_rec.attribute7)
1304: AND QP_GLOBALS.Equal(p_PSG_rec.attribute8,
1305: l_PSG_rec.attribute8)
1306: AND QP_GLOBALS.Equal(p_PSG_rec.attribute9,

Line 1304: AND QP_GLOBALS.Equal(p_PSG_rec.attribute8,

1300: AND QP_GLOBALS.Equal(p_PSG_rec.attribute6,
1301: l_PSG_rec.attribute6)
1302: AND QP_GLOBALS.Equal(p_PSG_rec.attribute7,
1303: l_PSG_rec.attribute7)
1304: AND QP_GLOBALS.Equal(p_PSG_rec.attribute8,
1305: l_PSG_rec.attribute8)
1306: AND QP_GLOBALS.Equal(p_PSG_rec.attribute9,
1307: l_PSG_rec.attribute9)
1308: AND QP_GLOBALS.Equal(p_PSG_rec.context,

Line 1306: AND QP_GLOBALS.Equal(p_PSG_rec.attribute9,

1302: AND QP_GLOBALS.Equal(p_PSG_rec.attribute7,
1303: l_PSG_rec.attribute7)
1304: AND QP_GLOBALS.Equal(p_PSG_rec.attribute8,
1305: l_PSG_rec.attribute8)
1306: AND QP_GLOBALS.Equal(p_PSG_rec.attribute9,
1307: l_PSG_rec.attribute9)
1308: AND QP_GLOBALS.Equal(p_PSG_rec.context,
1309: l_PSG_rec.context)
1310: AND QP_GLOBALS.Equal(p_PSG_rec.created_by,

Line 1308: AND QP_GLOBALS.Equal(p_PSG_rec.context,

1304: AND QP_GLOBALS.Equal(p_PSG_rec.attribute8,
1305: l_PSG_rec.attribute8)
1306: AND QP_GLOBALS.Equal(p_PSG_rec.attribute9,
1307: l_PSG_rec.attribute9)
1308: AND QP_GLOBALS.Equal(p_PSG_rec.context,
1309: l_PSG_rec.context)
1310: AND QP_GLOBALS.Equal(p_PSG_rec.created_by,
1311: l_PSG_rec.created_by)
1312: AND QP_GLOBALS.Equal(p_PSG_rec.creation_date,

Line 1310: AND QP_GLOBALS.Equal(p_PSG_rec.created_by,

1306: AND QP_GLOBALS.Equal(p_PSG_rec.attribute9,
1307: l_PSG_rec.attribute9)
1308: AND QP_GLOBALS.Equal(p_PSG_rec.context,
1309: l_PSG_rec.context)
1310: AND QP_GLOBALS.Equal(p_PSG_rec.created_by,
1311: l_PSG_rec.created_by)
1312: AND QP_GLOBALS.Equal(p_PSG_rec.creation_date,
1313: l_PSG_rec.creation_date)
1314: AND QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,

Line 1312: AND QP_GLOBALS.Equal(p_PSG_rec.creation_date,

1308: AND QP_GLOBALS.Equal(p_PSG_rec.context,
1309: l_PSG_rec.context)
1310: AND QP_GLOBALS.Equal(p_PSG_rec.created_by,
1311: l_PSG_rec.created_by)
1312: AND QP_GLOBALS.Equal(p_PSG_rec.creation_date,
1313: l_PSG_rec.creation_date)
1314: AND QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,
1315: l_PSG_rec.last_updated_by)
1316: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_date,

Line 1314: AND QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,

1310: AND QP_GLOBALS.Equal(p_PSG_rec.created_by,
1311: l_PSG_rec.created_by)
1312: AND QP_GLOBALS.Equal(p_PSG_rec.creation_date,
1313: l_PSG_rec.creation_date)
1314: AND QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,
1315: l_PSG_rec.last_updated_by)
1316: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_date,
1317: l_PSG_rec.last_update_date)
1318: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_login,

Line 1316: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_date,

1312: AND QP_GLOBALS.Equal(p_PSG_rec.creation_date,
1313: l_PSG_rec.creation_date)
1314: AND QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,
1315: l_PSG_rec.last_updated_by)
1316: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_date,
1317: l_PSG_rec.last_update_date)
1318: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_login,
1319: l_PSG_rec.last_update_login)
1320: AND QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,

Line 1318: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_login,

1314: AND QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,
1315: l_PSG_rec.last_updated_by)
1316: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_date,
1317: l_PSG_rec.last_update_date)
1318: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_login,
1319: l_PSG_rec.last_update_login)
1320: AND QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,
1321: l_PSG_rec.limits_enabled)
1322: AND QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,

Line 1320: AND QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,

1316: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_date,
1317: l_PSG_rec.last_update_date)
1318: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_login,
1319: l_PSG_rec.last_update_login)
1320: AND QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,
1321: l_PSG_rec.limits_enabled)
1322: AND QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,
1323: l_PSG_rec.lov_enabled)
1324: AND QP_GLOBALS.Equal(p_PSG_rec.program_application_id,

Line 1322: AND QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,

1318: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_login,
1319: l_PSG_rec.last_update_login)
1320: AND QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,
1321: l_PSG_rec.limits_enabled)
1322: AND QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,
1323: l_PSG_rec.lov_enabled)
1324: AND QP_GLOBALS.Equal(p_PSG_rec.program_application_id,
1325: l_PSG_rec.program_application_id)
1326: AND QP_GLOBALS.Equal(p_PSG_rec.program_id,

Line 1324: AND QP_GLOBALS.Equal(p_PSG_rec.program_application_id,

1320: AND QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,
1321: l_PSG_rec.limits_enabled)
1322: AND QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,
1323: l_PSG_rec.lov_enabled)
1324: AND QP_GLOBALS.Equal(p_PSG_rec.program_application_id,
1325: l_PSG_rec.program_application_id)
1326: AND QP_GLOBALS.Equal(p_PSG_rec.program_id,
1327: l_PSG_rec.program_id)
1328: AND QP_GLOBALS.Equal(p_PSG_rec.program_update_date,

Line 1326: AND QP_GLOBALS.Equal(p_PSG_rec.program_id,

1322: AND QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,
1323: l_PSG_rec.lov_enabled)
1324: AND QP_GLOBALS.Equal(p_PSG_rec.program_application_id,
1325: l_PSG_rec.program_application_id)
1326: AND QP_GLOBALS.Equal(p_PSG_rec.program_id,
1327: l_PSG_rec.program_id)
1328: AND QP_GLOBALS.Equal(p_PSG_rec.program_update_date,
1329: l_PSG_rec.program_update_date)
1330: AND QP_GLOBALS.Equal(p_PSG_rec.pte_code,

Line 1328: AND QP_GLOBALS.Equal(p_PSG_rec.program_update_date,

1324: AND QP_GLOBALS.Equal(p_PSG_rec.program_application_id,
1325: l_PSG_rec.program_application_id)
1326: AND QP_GLOBALS.Equal(p_PSG_rec.program_id,
1327: l_PSG_rec.program_id)
1328: AND QP_GLOBALS.Equal(p_PSG_rec.program_update_date,
1329: l_PSG_rec.program_update_date)
1330: AND QP_GLOBALS.Equal(p_PSG_rec.pte_code,
1331: l_PSG_rec.pte_code)
1332: AND QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,

Line 1330: AND QP_GLOBALS.Equal(p_PSG_rec.pte_code,

1326: AND QP_GLOBALS.Equal(p_PSG_rec.program_id,
1327: l_PSG_rec.program_id)
1328: AND QP_GLOBALS.Equal(p_PSG_rec.program_update_date,
1329: l_PSG_rec.program_update_date)
1330: AND QP_GLOBALS.Equal(p_PSG_rec.pte_code,
1331: l_PSG_rec.pte_code)
1332: AND QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,
1333: l_PSG_rec.seeded_sourcing_method)
1334: AND QP_GLOBALS.Equal(p_PSG_rec.segment_id,

Line 1332: AND QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,

1328: AND QP_GLOBALS.Equal(p_PSG_rec.program_update_date,
1329: l_PSG_rec.program_update_date)
1330: AND QP_GLOBALS.Equal(p_PSG_rec.pte_code,
1331: l_PSG_rec.pte_code)
1332: AND QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,
1333: l_PSG_rec.seeded_sourcing_method)
1334: AND QP_GLOBALS.Equal(p_PSG_rec.segment_id,
1335: l_PSG_rec.segment_id)
1336: AND QP_GLOBALS.Equal(p_PSG_rec.segment_level,

Line 1334: AND QP_GLOBALS.Equal(p_PSG_rec.segment_id,

1330: AND QP_GLOBALS.Equal(p_PSG_rec.pte_code,
1331: l_PSG_rec.pte_code)
1332: AND QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,
1333: l_PSG_rec.seeded_sourcing_method)
1334: AND QP_GLOBALS.Equal(p_PSG_rec.segment_id,
1335: l_PSG_rec.segment_id)
1336: AND QP_GLOBALS.Equal(p_PSG_rec.segment_level,
1337: l_PSG_rec.segment_level)
1338: AND QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,

Line 1336: AND QP_GLOBALS.Equal(p_PSG_rec.segment_level,

1332: AND QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,
1333: l_PSG_rec.seeded_sourcing_method)
1334: AND QP_GLOBALS.Equal(p_PSG_rec.segment_id,
1335: l_PSG_rec.segment_id)
1336: AND QP_GLOBALS.Equal(p_PSG_rec.segment_level,
1337: l_PSG_rec.segment_level)
1338: AND QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,
1339: l_PSG_rec.segment_pte_id)
1340: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,

Line 1338: AND QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,

1334: AND QP_GLOBALS.Equal(p_PSG_rec.segment_id,
1335: l_PSG_rec.segment_id)
1336: AND QP_GLOBALS.Equal(p_PSG_rec.segment_level,
1337: l_PSG_rec.segment_level)
1338: AND QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,
1339: l_PSG_rec.segment_pte_id)
1340: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,
1341: l_PSG_rec.sourcing_enabled)
1342: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,

Line 1340: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,

1336: AND QP_GLOBALS.Equal(p_PSG_rec.segment_level,
1337: l_PSG_rec.segment_level)
1338: AND QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,
1339: l_PSG_rec.segment_pte_id)
1340: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,
1341: l_PSG_rec.sourcing_enabled)
1342: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,
1343: l_PSG_rec.sourcing_status)
1344: AND QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,

Line 1342: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,

1338: AND QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,
1339: l_PSG_rec.segment_pte_id)
1340: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,
1341: l_PSG_rec.sourcing_enabled)
1342: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,
1343: l_PSG_rec.sourcing_status)
1344: AND QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,
1345: l_PSG_rec.user_sourcing_method)
1346: THEN

Line 1344: AND QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,

1340: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,
1341: l_PSG_rec.sourcing_enabled)
1342: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,
1343: l_PSG_rec.sourcing_status)
1344: AND QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,
1345: l_PSG_rec.user_sourcing_method)
1346: THEN
1347:
1348: -- Row has not changed. Set out parameter.

Line 1428: NOT QP_GLOBALS.Equal(p_PSG_rec.pte_code,

1424: BEGIN
1425:
1426: IF p_PSG_rec.pte_code IS NOT NULL AND
1427: p_PSG_rec.pte_code <> FND_API.G_MISS_CHAR AND
1428: NOT QP_GLOBALS.Equal(p_PSG_rec.pte_code,
1429: p_old_PSG_rec.pte_code)
1430: THEN
1431: l_PSG_val_rec.pte := QP_Id_To_Value.Pte
1432: ( p_pte_code => p_PSG_rec.pte_code

Line 1438: NOT QP_GLOBALS.Equal(p_PSG_rec.segment_id,

1434: END IF;
1435:
1436: IF p_PSG_rec.segment_id IS NOT NULL AND
1437: p_PSG_rec.segment_id <> FND_API.G_MISS_NUM AND
1438: NOT QP_GLOBALS.Equal(p_PSG_rec.segment_id,
1439: p_old_PSG_rec.segment_id)
1440: THEN
1441: l_PSG_val_rec.segment := QP_Id_To_Value.Segment
1442: ( p_segment_id => p_PSG_rec.segment_id

Line 1448: NOT QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,

1444: END IF;
1445:
1446: IF p_PSG_rec.segment_pte_id IS NOT NULL AND
1447: p_PSG_rec.segment_pte_id <> FND_API.G_MISS_NUM AND
1448: NOT QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,
1449: p_old_PSG_rec.segment_pte_id)
1450: THEN
1451: l_PSG_val_rec.segment_pte := QP_Id_To_Value.Segment_Pte
1452: ( p_segment_pte_id => p_PSG_rec.segment_pte_id