APPS.ASO_APR_APPROVALS_PKG dependencies on FND_API

Line 113: fnd_api.g_miss_num,

109: requester_group_id)
110: VALUES (px_object_approval_id,
111: DECODE (
112: p_object_id,
113: fnd_api.g_miss_num,
114: NULL,
115: p_object_id
116: ),
117: DECODE (

Line 119: fnd_api.g_miss_char,

115: p_object_id
116: ),
117: DECODE (
118: p_object_type,
119: fnd_api.g_miss_char,
120: NULL,
121: p_object_type
122: ),
123: DECODE (

Line 125: fnd_api.g_miss_num,

121: p_object_type
122: ),
123: DECODE (
124: p_approval_instance_id,
125: fnd_api.g_miss_num,
126: NULL,
127: p_approval_instance_id
128: ),
129: DECODE (

Line 131: fnd_api.g_miss_char,

127: p_approval_instance_id
128: ),
129: DECODE (
130: p_approval_status,
131: fnd_api.g_miss_char,
132: NULL,
133: p_approval_status
134: ),
135: DECODE (

Line 137: fnd_api.g_miss_num,

133: p_approval_status
134: ),
135: DECODE (
136: p_application_id,
137: fnd_api.g_miss_num,
138: NULL,
139: p_application_id
140: ),
141: aso_utility_pvt.DECODE (

Line 143: fnd_api.g_miss_date,

139: p_application_id
140: ),
141: aso_utility_pvt.DECODE (
142: p_start_date,
143: fnd_api.g_miss_date,
144: NULL,
145: p_start_date
146: ),
147: aso_utility_pvt.DECODE (

Line 149: fnd_api.g_miss_date,

145: p_start_date
146: ),
147: aso_utility_pvt.DECODE (
148: p_end_date,
149: fnd_api.g_miss_date,
150: NULL,
151: p_end_date
152: ),
153: aso_utility_pvt.DECODE (

Line 155: fnd_api.g_miss_date,

151: p_end_date
152: ),
153: aso_utility_pvt.DECODE (
154: p_creation_date,
155: fnd_api.g_miss_date,
156: NULL,
157: p_creation_date
158: ),
159: DECODE (

Line 161: fnd_api.g_miss_num,

157: p_creation_date
158: ),
159: DECODE (
160: p_created_by,
161: fnd_api.g_miss_num,
162: NULL,
163: p_created_by
164: ),
165: aso_utility_pvt.DECODE (

Line 167: fnd_api.g_miss_date,

163: p_created_by
164: ),
165: aso_utility_pvt.DECODE (
166: p_last_update_date,
167: fnd_api.g_miss_date,
168: NULL,
169: p_last_update_date
170: ),
171: DECODE (

Line 173: fnd_api.g_miss_num,

169: p_last_update_date
170: ),
171: DECODE (
172: p_last_updated_by,
173: fnd_api.g_miss_num,
174: NULL,
175: p_last_updated_by
176: ),
177: DECODE (

Line 179: fnd_api.g_miss_num,

175: p_last_updated_by
176: ),
177: DECODE (
178: p_last_update_login,
179: fnd_api.g_miss_num,
180: NULL,
181: p_last_update_login
182: ),
183: DECODE (

Line 185: fnd_api.g_miss_char,

181: p_last_update_login
182: ),
183: DECODE (
184: p_attribute1,
185: fnd_api.g_miss_char,
186: NULL,
187: p_attribute1
188: ),
189: DECODE (

Line 191: fnd_api.g_miss_char,

187: p_attribute1
188: ),
189: DECODE (
190: p_attribute2,
191: fnd_api.g_miss_char,
192: NULL,
193: p_attribute2
194: ),
195: DECODE (

Line 197: fnd_api.g_miss_char,

193: p_attribute2
194: ),
195: DECODE (
196: p_attribute3,
197: fnd_api.g_miss_char,
198: NULL,
199: p_attribute3
200: ),
201: DECODE (

Line 203: fnd_api.g_miss_char,

199: p_attribute3
200: ),
201: DECODE (
202: p_attribute4,
203: fnd_api.g_miss_char,
204: NULL,
205: p_attribute4
206: ),
207: DECODE (

Line 209: fnd_api.g_miss_char,

205: p_attribute4
206: ),
207: DECODE (
208: p_attribute5,
209: fnd_api.g_miss_char,
210: NULL,
211: p_attribute5
212: ),
213: DECODE (

Line 215: fnd_api.g_miss_char,

211: p_attribute5
212: ),
213: DECODE (
214: p_attribute6,
215: fnd_api.g_miss_char,
216: NULL,
217: p_attribute6
218: ),
219: DECODE (

Line 221: fnd_api.g_miss_char,

217: p_attribute6
218: ),
219: DECODE (
220: p_attribute7,
221: fnd_api.g_miss_char,
222: NULL,
223: p_attribute7
224: ),
225: DECODE (

Line 227: fnd_api.g_miss_char,

223: p_attribute7
224: ),
225: DECODE (
226: p_attribute8,
227: fnd_api.g_miss_char,
228: NULL,
229: p_attribute8
230: ),
231: DECODE (

Line 233: fnd_api.g_miss_char,

229: p_attribute8
230: ),
231: DECODE (
232: p_attribute9,
233: fnd_api.g_miss_char,
234: NULL,
235: p_attribute9
236: ),
237: DECODE (

Line 239: fnd_api.g_miss_char,

235: p_attribute9
236: ),
237: DECODE (
238: p_attribute10,
239: fnd_api.g_miss_char,
240: NULL,
241: p_attribute10
242: ),
243: DECODE (

Line 245: fnd_api.g_miss_char,

241: p_attribute10
242: ),
243: DECODE (
244: p_attribute11,
245: fnd_api.g_miss_char,
246: NULL,
247: p_attribute11
248: ),
249: DECODE (

Line 251: fnd_api.g_miss_char,

247: p_attribute11
248: ),
249: DECODE (
250: p_attribute12,
251: fnd_api.g_miss_char,
252: NULL,
253: p_attribute12
254: ),
255: DECODE (

Line 257: fnd_api.g_miss_char,

253: p_attribute12
254: ),
255: DECODE (
256: p_attribute13,
257: fnd_api.g_miss_char,
258: NULL,
259: p_attribute13
260: ),
261: DECODE (

Line 263: fnd_api.g_miss_char,

259: p_attribute13
260: ),
261: DECODE (
262: p_attribute14,
263: fnd_api.g_miss_char,
264: NULL,
265: p_attribute14
266: ),
267: DECODE (

Line 269: fnd_api.g_miss_char,

265: p_attribute14
266: ),
267: DECODE (
268: p_attribute15,
269: fnd_api.g_miss_char,
270: NULL,
271: p_attribute15
272: ),
273: DECODE (

Line 275: fnd_api.g_miss_char,

271: p_attribute15
272: ),
273: DECODE (
274: p_attribute16,
275: fnd_api.g_miss_char,
276: NULL,
277: p_attribute16
278: ),
279: DECODE (

Line 281: fnd_api.g_miss_char,

277: p_attribute16
278: ),
279: DECODE (
280: p_attribute17,
281: fnd_api.g_miss_char,
282: NULL,
283: p_attribute17
284: ),
285: DECODE (

Line 287: fnd_api.g_miss_char,

283: p_attribute17
284: ),
285: DECODE (
286: p_attribute18,
287: fnd_api.g_miss_char,
288: NULL,
289: p_attribute18
290: ),
291: DECODE (

Line 293: fnd_api.g_miss_char,

289: p_attribute18
290: ),
291: DECODE (
292: p_attribute19,
293: fnd_api.g_miss_char,
294: NULL,
295: p_attribute19
296: ),
297: DECODE (

Line 299: fnd_api.g_miss_char,

295: p_attribute19
296: ),
297: DECODE (
298: p_attribute20,
299: fnd_api.g_miss_char,
300: NULL,
301: p_attribute20
302: ),
303: DECODE (

Line 305: fnd_api.g_miss_char,

301: p_attribute20
302: ),
303: DECODE (
304: p_context,
305: fnd_api.g_miss_char,
306: NULL,
307: p_context
308: ),
309: DECODE (

Line 311: fnd_api.g_miss_num,

307: p_context
308: ),
309: DECODE (
310: p_security_group_id,
311: fnd_api.g_miss_num,
312: NULL,
313: p_security_group_id
314: ),
315: DECODE (

Line 317: fnd_api.g_miss_num,

313: p_security_group_id
314: ),
315: DECODE (
316: p_object_version_number,
317: fnd_api.g_miss_num,
318: NULL,
319: p_object_version_number
320: ),
321: DECODE (

Line 323: fnd_api.g_miss_num,

319: p_object_version_number
320: ),
321: DECODE (
322: p_requester_userid,
323: fnd_api.g_miss_num,
324: NULL,
325: p_requester_userid
326: ),
327: DECODE (

Line 329: fnd_api.g_miss_char,

325: p_requester_userid
326: ),
327: DECODE (
328: p_requester_comments,
329: fnd_api.g_miss_char,
330: NULL,
331: p_requester_comments
332: ),
333: DECODE (

Line 335: fnd_api.g_miss_num,

331: p_requester_comments
332: ),
333: DECODE (
334: p_requester_group_id,
335: fnd_api.g_miss_num,
336: NULL,
337: p_requester_group_id
338: ));
339:

Line 421: fnd_api.g_miss_num,

417:
418: UPDATE aso_apr_obj_approvals
419: SET object_id = DECODE (
420: p_object_id,
421: fnd_api.g_miss_num,
422: object_id,
423: p_object_id
424: ),
425: object_type = DECODE (

Line 427: fnd_api.g_miss_char,

423: p_object_id
424: ),
425: object_type = DECODE (
426: p_object_type,
427: fnd_api.g_miss_char,
428: object_type,
429: p_object_type
430: ),
431: approval_instance_id = DECODE (

Line 433: fnd_api.g_miss_num,

429: p_object_type
430: ),
431: approval_instance_id = DECODE (
432: p_approval_instance_id,
433: fnd_api.g_miss_num,
434: approval_instance_id,
435: p_approval_instance_id
436: ),
437: approval_status = DECODE (

Line 439: fnd_api.g_miss_char,

435: p_approval_instance_id
436: ),
437: approval_status = DECODE (
438: p_approval_status,
439: fnd_api.g_miss_char,
440: approval_status,
441: p_approval_status
442: ),
443: application_id = DECODE (

Line 445: fnd_api.g_miss_num,

441: p_approval_status
442: ),
443: application_id = DECODE (
444: p_application_id,
445: fnd_api.g_miss_num,
446: application_id,
447: p_application_id
448: ),
449: start_date = aso_utility_pvt.DECODE (

Line 451: fnd_api.g_miss_date,

447: p_application_id
448: ),
449: start_date = aso_utility_pvt.DECODE (
450: p_start_date,
451: fnd_api.g_miss_date,
452: start_date,
453: p_start_date
454: ),
455: end_date = aso_utility_pvt.DECODE (

Line 457: fnd_api.g_miss_date,

453: p_start_date
454: ),
455: end_date = aso_utility_pvt.DECODE (
456: p_end_date,
457: fnd_api.g_miss_date,
458: end_date,
459: p_end_date
460: ),
461: last_update_date = aso_utility_pvt.DECODE (

Line 463: fnd_api.g_miss_date,

459: p_end_date
460: ),
461: last_update_date = aso_utility_pvt.DECODE (
462: p_last_update_date,
463: fnd_api.g_miss_date,
464: last_update_date,
465: p_last_update_date
466: ),
467: last_updated_by = DECODE (

Line 469: fnd_api.g_miss_num,

465: p_last_update_date
466: ),
467: last_updated_by = DECODE (
468: p_last_updated_by,
469: fnd_api.g_miss_num,
470: last_updated_by,
471: p_last_updated_by
472: ),
473: last_update_login = DECODE (

Line 475: fnd_api.g_miss_num,

471: p_last_updated_by
472: ),
473: last_update_login = DECODE (
474: p_last_update_login,
475: fnd_api.g_miss_num,
476: last_update_login,
477: p_last_update_login
478: ),
479: attribute1 = DECODE (

Line 481: fnd_api.g_miss_char,

477: p_last_update_login
478: ),
479: attribute1 = DECODE (
480: p_attribute1,
481: fnd_api.g_miss_char,
482: attribute1,
483: p_attribute1
484: ),
485: attribute2 = DECODE (

Line 487: fnd_api.g_miss_char,

483: p_attribute1
484: ),
485: attribute2 = DECODE (
486: p_attribute2,
487: fnd_api.g_miss_char,
488: attribute2,
489: p_attribute2
490: ),
491: attribute3 = DECODE (

Line 493: fnd_api.g_miss_char,

489: p_attribute2
490: ),
491: attribute3 = DECODE (
492: p_attribute3,
493: fnd_api.g_miss_char,
494: attribute3,
495: p_attribute3
496: ),
497: attribute4 = DECODE (

Line 499: fnd_api.g_miss_char,

495: p_attribute3
496: ),
497: attribute4 = DECODE (
498: p_attribute4,
499: fnd_api.g_miss_char,
500: attribute4,
501: p_attribute4
502: ),
503: attribute5 = DECODE (

Line 505: fnd_api.g_miss_char,

501: p_attribute4
502: ),
503: attribute5 = DECODE (
504: p_attribute5,
505: fnd_api.g_miss_char,
506: attribute5,
507: p_attribute5
508: ),
509: attribute6 = DECODE (

Line 511: fnd_api.g_miss_char,

507: p_attribute5
508: ),
509: attribute6 = DECODE (
510: p_attribute6,
511: fnd_api.g_miss_char,
512: attribute6,
513: p_attribute6
514: ),
515: attribute7 = DECODE (

Line 517: fnd_api.g_miss_char,

513: p_attribute6
514: ),
515: attribute7 = DECODE (
516: p_attribute7,
517: fnd_api.g_miss_char,
518: attribute7,
519: p_attribute7
520: ),
521: attribute8 = DECODE (

Line 523: fnd_api.g_miss_char,

519: p_attribute7
520: ),
521: attribute8 = DECODE (
522: p_attribute8,
523: fnd_api.g_miss_char,
524: attribute8,
525: p_attribute8
526: ),
527: attribute9 = DECODE (

Line 529: fnd_api.g_miss_char,

525: p_attribute8
526: ),
527: attribute9 = DECODE (
528: p_attribute9,
529: fnd_api.g_miss_char,
530: attribute9,
531: p_attribute9
532: ),
533: attribute10 = DECODE (

Line 535: fnd_api.g_miss_char,

531: p_attribute9
532: ),
533: attribute10 = DECODE (
534: p_attribute10,
535: fnd_api.g_miss_char,
536: attribute10,
537: p_attribute10
538: ),
539: attribute11 = DECODE (

Line 541: fnd_api.g_miss_char,

537: p_attribute10
538: ),
539: attribute11 = DECODE (
540: p_attribute11,
541: fnd_api.g_miss_char,
542: attribute11,
543: p_attribute11
544: ),
545: attribute12 = DECODE (

Line 547: fnd_api.g_miss_char,

543: p_attribute11
544: ),
545: attribute12 = DECODE (
546: p_attribute12,
547: fnd_api.g_miss_char,
548: attribute12,
549: p_attribute12
550: ),
551: attribute13 = DECODE (

Line 553: fnd_api.g_miss_char,

549: p_attribute12
550: ),
551: attribute13 = DECODE (
552: p_attribute13,
553: fnd_api.g_miss_char,
554: attribute13,
555: p_attribute13
556: ),
557: attribute14 = DECODE (

Line 559: fnd_api.g_miss_char,

555: p_attribute13
556: ),
557: attribute14 = DECODE (
558: p_attribute14,
559: fnd_api.g_miss_char,
560: attribute14,
561: p_attribute14
562: ),
563: attribute15 = DECODE (

Line 565: fnd_api.g_miss_char,

561: p_attribute14
562: ),
563: attribute15 = DECODE (
564: p_attribute15,
565: fnd_api.g_miss_char,
566: attribute15,
567: p_attribute15
568: ),
569: attribute16 = DECODE (

Line 571: fnd_api.g_miss_char,

567: p_attribute15
568: ),
569: attribute16 = DECODE (
570: p_attribute16,
571: fnd_api.g_miss_char,
572: attribute16,
573: p_attribute16
574: ),
575: attribute17 = DECODE (

Line 577: fnd_api.g_miss_char,

573: p_attribute16
574: ),
575: attribute17 = DECODE (
576: p_attribute17,
577: fnd_api.g_miss_char,
578: attribute17,
579: p_attribute17
580: ),
581: attribute18 = DECODE (

Line 583: fnd_api.g_miss_char,

579: p_attribute17
580: ),
581: attribute18 = DECODE (
582: p_attribute18,
583: fnd_api.g_miss_char,
584: attribute18,
585: p_attribute18
586: ),
587: attribute19 = DECODE (

Line 589: fnd_api.g_miss_char,

585: p_attribute18
586: ),
587: attribute19 = DECODE (
588: p_attribute19,
589: fnd_api.g_miss_char,
590: attribute19,
591: p_attribute19
592: ),
593: attribute20 = DECODE (

Line 595: fnd_api.g_miss_char,

591: p_attribute19
592: ),
593: attribute20 = DECODE (
594: p_attribute20,
595: fnd_api.g_miss_char,
596: attribute20,
597: p_attribute20
598: ),
599: CONTEXT = DECODE (

Line 601: fnd_api.g_miss_char,

597: p_attribute20
598: ),
599: CONTEXT = DECODE (
600: p_context,
601: fnd_api.g_miss_char,
602: CONTEXT,
603: p_context
604: ),
605: security_group_id = DECODE (

Line 607: fnd_api.g_miss_num,

603: p_context
604: ),
605: security_group_id = DECODE (
606: p_security_group_id,
607: fnd_api.g_miss_num,
608: security_group_id,
609: p_security_group_id
610: ),
611: object_version_number = DECODE (

Line 613: fnd_api.g_miss_num,

609: p_security_group_id
610: ),
611: object_version_number = DECODE (
612: p_object_version_number,
613: fnd_api.g_miss_num,
614: object_version_number,
615: p_object_version_number
616: ),
617: requester_userid = DECODE (

Line 619: fnd_api.g_miss_num,

615: p_object_version_number
616: ),
617: requester_userid = DECODE (
618: p_requester_userid,
619: fnd_api.g_miss_num,
620: requester_userid,
621: p_requester_userid
622: ),
623: requester_comments = DECODE (

Line 625: fnd_api.g_miss_char,

621: p_requester_userid
622: ),
623: requester_comments = DECODE (
624: p_requester_comments,
625: fnd_api.g_miss_char,
626: requester_comments,
627: p_requester_comments
628: ),
629: requester_group_id = DECODE (

Line 631: fnd_api.g_miss_num,

627: p_requester_comments
628: ),
629: requester_group_id = DECODE (
630: p_requester_group_id,
631: fnd_api.g_miss_num,
632: requester_group_id,
633: p_requester_group_id
634: )
635: WHERE object_approval_id = p_object_approval_id;

Line 830: OR (px_approval_det_id = fnd_api.g_miss_num)

826: );
827: END IF;
828:
829: IF (px_approval_det_id IS NULL)
830: OR (px_approval_det_id = fnd_api.g_miss_num)
831: THEN
832: OPEN c2;
833: FETCH c2 INTO px_approval_det_id;
834: CLOSE c2;

Line 878: fnd_api.g_miss_num,

874: object_version_number)
875: VALUES (px_approval_det_id,
876: DECODE (
877: p_object_approval_id,
878: fnd_api.g_miss_num,
879: NULL,
880: p_object_approval_id
881: ),
882: DECODE (

Line 884: fnd_api.g_miss_num,

880: p_object_approval_id
881: ),
882: DECODE (
883: p_approver_person_id,
884: fnd_api.g_miss_num,
885: NULL,
886: p_approver_person_id
887: ),
888: DECODE (

Line 890: fnd_api.g_miss_num,

886: p_approver_person_id
887: ),
888: DECODE (
889: p_approver_user_id,
890: fnd_api.g_miss_num,
891: NULL,
892: p_approver_user_id
893: ),
894: DECODE (

Line 896: fnd_api.g_miss_num,

892: p_approver_user_id
893: ),
894: DECODE (
895: p_approver_sequence,
896: fnd_api.g_miss_num,
897: NULL,
898: p_approver_sequence
899: ),
900: DECODE (

Line 902: fnd_api.g_miss_char,

898: p_approver_sequence
899: ),
900: DECODE (
901: p_approver_status,
902: fnd_api.g_miss_char,
903: NULL,
904: p_approver_status
905: ),
906: DECODE (

Line 908: fnd_api.g_miss_char,

904: p_approver_status
905: ),
906: DECODE (
907: p_approver_comments,
908: fnd_api.g_miss_char,
909: NULL,
910: p_approver_comments
911: ),
912: aso_utility_pvt.DECODE (

Line 914: fnd_api.g_miss_date,

910: p_approver_comments
911: ),
912: aso_utility_pvt.DECODE (
913: p_date_sent,
914: fnd_api.g_miss_date,
915: NULL,
916: p_date_sent
917: ),
918: aso_utility_pvt.DECODE (

Line 920: fnd_api.g_miss_date,

916: p_date_sent
917: ),
918: aso_utility_pvt.DECODE (
919: p_date_received,
920: fnd_api.g_miss_date,
921: NULL,
922: p_date_received
923: ),
924: aso_utility_pvt.DECODE (

Line 926: fnd_api.g_miss_date,

922: p_date_received
923: ),
924: aso_utility_pvt.DECODE (
925: p_creation_date,
926: fnd_api.g_miss_date,
927: NULL,
928: p_creation_date
929: ),
930: aso_utility_pvt.DECODE (

Line 932: fnd_api.g_miss_date,

928: p_creation_date
929: ),
930: aso_utility_pvt.DECODE (
931: p_last_update_date,
932: fnd_api.g_miss_date,
933: NULL,
934: p_last_update_date
935: ),
936: DECODE (

Line 938: fnd_api.g_miss_num,

934: p_last_update_date
935: ),
936: DECODE (
937: p_created_by,
938: fnd_api.g_miss_num,
939: NULL,
940: p_created_by
941: ),
942: DECODE (

Line 944: fnd_api.g_miss_num,

940: p_created_by
941: ),
942: DECODE (
943: p_last_updated_by,
944: fnd_api.g_miss_num,
945: NULL,
946: p_last_updated_by
947: ),
948: DECODE (

Line 950: fnd_api.g_miss_num,

946: p_last_updated_by
947: ),
948: DECODE (
949: p_last_update_login,
950: fnd_api.g_miss_num,
951: NULL,
952: p_last_update_login
953: ),
954: DECODE (

Line 956: fnd_api.g_miss_char,

952: p_last_update_login
953: ),
954: DECODE (
955: p_attribute1,
956: fnd_api.g_miss_char,
957: NULL,
958: p_attribute1
959: ),
960: DECODE (

Line 962: fnd_api.g_miss_char,

958: p_attribute1
959: ),
960: DECODE (
961: p_attribute2,
962: fnd_api.g_miss_char,
963: NULL,
964: p_attribute2
965: ),
966: DECODE (

Line 968: fnd_api.g_miss_char,

964: p_attribute2
965: ),
966: DECODE (
967: p_attribute3,
968: fnd_api.g_miss_char,
969: NULL,
970: p_attribute3
971: ),
972: DECODE (

Line 974: fnd_api.g_miss_char,

970: p_attribute3
971: ),
972: DECODE (
973: p_attribute4,
974: fnd_api.g_miss_char,
975: NULL,
976: p_attribute4
977: ),
978: DECODE (

Line 980: fnd_api.g_miss_char,

976: p_attribute4
977: ),
978: DECODE (
979: p_attribute5,
980: fnd_api.g_miss_char,
981: NULL,
982: p_attribute5
983: ),
984: DECODE (

Line 986: fnd_api.g_miss_char,

982: p_attribute5
983: ),
984: DECODE (
985: p_attribute6,
986: fnd_api.g_miss_char,
987: NULL,
988: p_attribute6
989: ),
990: DECODE (

Line 992: fnd_api.g_miss_char,

988: p_attribute6
989: ),
990: DECODE (
991: p_attribute7,
992: fnd_api.g_miss_char,
993: NULL,
994: p_attribute7
995: ),
996: DECODE (

Line 998: fnd_api.g_miss_char,

994: p_attribute7
995: ),
996: DECODE (
997: p_attribute8,
998: fnd_api.g_miss_char,
999: NULL,
1000: p_attribute8
1001: ),
1002: DECODE (

Line 1004: fnd_api.g_miss_char,

1000: p_attribute8
1001: ),
1002: DECODE (
1003: p_attribute9,
1004: fnd_api.g_miss_char,
1005: NULL,
1006: p_attribute9
1007: ),
1008: DECODE (

Line 1010: fnd_api.g_miss_char,

1006: p_attribute9
1007: ),
1008: DECODE (
1009: p_attribute10,
1010: fnd_api.g_miss_char,
1011: NULL,
1012: p_attribute10
1013: ),
1014: DECODE (

Line 1016: fnd_api.g_miss_char,

1012: p_attribute10
1013: ),
1014: DECODE (
1015: p_attribute11,
1016: fnd_api.g_miss_char,
1017: NULL,
1018: p_attribute11
1019: ),
1020: DECODE (

Line 1022: fnd_api.g_miss_char,

1018: p_attribute11
1019: ),
1020: DECODE (
1021: p_attribute12,
1022: fnd_api.g_miss_char,
1023: NULL,
1024: p_attribute12
1025: ),
1026: DECODE (

Line 1028: fnd_api.g_miss_char,

1024: p_attribute12
1025: ),
1026: DECODE (
1027: p_attribute13,
1028: fnd_api.g_miss_char,
1029: NULL,
1030: p_attribute13
1031: ),
1032: DECODE (

Line 1034: fnd_api.g_miss_char,

1030: p_attribute13
1031: ),
1032: DECODE (
1033: p_attribute14,
1034: fnd_api.g_miss_char,
1035: NULL,
1036: p_attribute14
1037: ),
1038: DECODE (

Line 1040: fnd_api.g_miss_char,

1036: p_attribute14
1037: ),
1038: DECODE (
1039: p_attribute15,
1040: fnd_api.g_miss_char,
1041: NULL,
1042: p_attribute15
1043: ),
1044: DECODE (

Line 1046: fnd_api.g_miss_char,

1042: p_attribute15
1043: ),
1044: DECODE (
1045: p_attribute16,
1046: fnd_api.g_miss_char,
1047: NULL,
1048: p_attribute16
1049: ),
1050: DECODE (

Line 1052: fnd_api.g_miss_char,

1048: p_attribute16
1049: ),
1050: DECODE (
1051: p_attribute17,
1052: fnd_api.g_miss_char,
1053: NULL,
1054: p_attribute17
1055: ),
1056: DECODE (

Line 1058: fnd_api.g_miss_char,

1054: p_attribute17
1055: ),
1056: DECODE (
1057: p_attribute18,
1058: fnd_api.g_miss_char,
1059: NULL,
1060: p_attribute18
1061: ),
1062: DECODE (

Line 1064: fnd_api.g_miss_char,

1060: p_attribute18
1061: ),
1062: DECODE (
1063: p_attribute19,
1064: fnd_api.g_miss_char,
1065: NULL,
1066: p_attribute19
1067: ),
1068: DECODE (

Line 1070: fnd_api.g_miss_char,

1066: p_attribute19
1067: ),
1068: DECODE (
1069: p_attribute20,
1070: fnd_api.g_miss_char,
1071: NULL,
1072: p_attribute20
1073: ),
1074: DECODE (

Line 1076: fnd_api.g_miss_char,

1072: p_attribute20
1073: ),
1074: DECODE (
1075: p_context,
1076: fnd_api.g_miss_char,
1077: NULL,
1078: p_context
1079: ),
1080: DECODE (

Line 1082: fnd_api.g_miss_num,

1078: p_context
1079: ),
1080: DECODE (
1081: p_security_group_id,
1082: fnd_api.g_miss_num,
1083: NULL,
1084: p_security_group_id
1085: ),
1086: DECODE (

Line 1088: fnd_api.g_miss_num,

1084: p_security_group_id
1085: ),
1086: DECODE (
1087: p_object_version_number,
1088: fnd_api.g_miss_num,
1089: NULL,
1090: p_object_version_number
1091: ));
1092:

Line 1158: fnd_api.g_miss_num,

1154:
1155: UPDATE aso_apr_approval_details
1156: SET approval_det_id = DECODE (
1157: p_approval_det_id,
1158: fnd_api.g_miss_num,
1159: approval_det_id,
1160: p_approval_det_id
1161: ),
1162: object_approval_id = DECODE (

Line 1164: fnd_api.g_miss_num,

1160: p_approval_det_id
1161: ),
1162: object_approval_id = DECODE (
1163: p_object_approval_id,
1164: fnd_api.g_miss_num,
1165: object_approval_id,
1166: p_object_approval_id
1167: ),
1168: approver_person_id = DECODE (

Line 1170: fnd_api.g_miss_num,

1166: p_object_approval_id
1167: ),
1168: approver_person_id = DECODE (
1169: p_approver_person_id,
1170: fnd_api.g_miss_num,
1171: approver_person_id,
1172: p_approver_person_id
1173: ),
1174: approver_user_id = DECODE (

Line 1176: fnd_api.g_miss_num,

1172: p_approver_person_id
1173: ),
1174: approver_user_id = DECODE (
1175: p_approver_user_id,
1176: fnd_api.g_miss_num,
1177: approver_user_id,
1178: p_approver_user_id
1179: ),
1180: approver_sequence = DECODE (

Line 1182: fnd_api.g_miss_num,

1178: p_approver_user_id
1179: ),
1180: approver_sequence = DECODE (
1181: p_approver_sequence,
1182: fnd_api.g_miss_num,
1183: approver_sequence,
1184: p_approver_sequence
1185: ),
1186: approver_status = DECODE (

Line 1188: fnd_api.g_miss_char,

1184: p_approver_sequence
1185: ),
1186: approver_status = DECODE (
1187: p_approver_status,
1188: fnd_api.g_miss_char,
1189: approver_status,
1190: p_approver_status
1191: ),
1192: approver_comments = DECODE (

Line 1194: fnd_api.g_miss_char,

1190: p_approver_status
1191: ),
1192: approver_comments = DECODE (
1193: p_approver_comments,
1194: fnd_api.g_miss_char,
1195: approver_comments,
1196: p_approver_comments
1197: ),
1198: date_sent = aso_utility_pvt.DECODE (

Line 1200: fnd_api.g_miss_date,

1196: p_approver_comments
1197: ),
1198: date_sent = aso_utility_pvt.DECODE (
1199: p_date_sent,
1200: fnd_api.g_miss_date,
1201: date_sent,
1202: p_date_sent
1203: ),
1204: date_received = aso_utility_pvt.DECODE (

Line 1206: fnd_api.g_miss_date,

1202: p_date_sent
1203: ),
1204: date_received = aso_utility_pvt.DECODE (
1205: p_date_received,
1206: fnd_api.g_miss_date,
1207: date_received,
1208: p_date_received
1209: ),
1210: creation_date = aso_utility_pvt.DECODE (

Line 1212: fnd_api.g_miss_date,

1208: p_date_received
1209: ),
1210: creation_date = aso_utility_pvt.DECODE (
1211: p_creation_date,
1212: fnd_api.g_miss_date,
1213: creation_date,
1214: p_creation_date
1215: ),
1216: last_update_date = aso_utility_pvt.DECODE (

Line 1218: fnd_api.g_miss_date,

1214: p_creation_date
1215: ),
1216: last_update_date = aso_utility_pvt.DECODE (
1217: p_last_update_date,
1218: fnd_api.g_miss_date,
1219: last_update_date,
1220: p_last_update_date
1221: ),
1222: created_by = DECODE (

Line 1224: fnd_api.g_miss_num,

1220: p_last_update_date
1221: ),
1222: created_by = DECODE (
1223: p_created_by,
1224: fnd_api.g_miss_num,
1225: created_by,
1226: p_created_by
1227: ),
1228: last_updated_by = DECODE (

Line 1230: fnd_api.g_miss_num,

1226: p_created_by
1227: ),
1228: last_updated_by = DECODE (
1229: p_last_updated_by,
1230: fnd_api.g_miss_num,
1231: last_updated_by,
1232: p_last_updated_by
1233: ),
1234: last_update_login = DECODE (

Line 1236: fnd_api.g_miss_num,

1232: p_last_updated_by
1233: ),
1234: last_update_login = DECODE (
1235: p_last_update_login,
1236: fnd_api.g_miss_num,
1237: last_update_login,
1238: p_last_update_login
1239: ),
1240: attribute1 = DECODE (

Line 1242: fnd_api.g_miss_char,

1238: p_last_update_login
1239: ),
1240: attribute1 = DECODE (
1241: p_attribute1,
1242: fnd_api.g_miss_char,
1243: attribute1,
1244: p_attribute1
1245: ),
1246: attribute2 = DECODE (

Line 1248: fnd_api.g_miss_char,

1244: p_attribute1
1245: ),
1246: attribute2 = DECODE (
1247: p_attribute2,
1248: fnd_api.g_miss_char,
1249: attribute2,
1250: p_attribute2
1251: ),
1252: attribute3 = DECODE (

Line 1254: fnd_api.g_miss_char,

1250: p_attribute2
1251: ),
1252: attribute3 = DECODE (
1253: p_attribute3,
1254: fnd_api.g_miss_char,
1255: attribute3,
1256: p_attribute3
1257: ),
1258: attribute4 = DECODE (

Line 1260: fnd_api.g_miss_char,

1256: p_attribute3
1257: ),
1258: attribute4 = DECODE (
1259: p_attribute4,
1260: fnd_api.g_miss_char,
1261: attribute4,
1262: p_attribute4
1263: ),
1264: attribute5 = DECODE (

Line 1266: fnd_api.g_miss_char,

1262: p_attribute4
1263: ),
1264: attribute5 = DECODE (
1265: p_attribute5,
1266: fnd_api.g_miss_char,
1267: attribute5,
1268: p_attribute5
1269: ),
1270: attribute6 = DECODE (

Line 1272: fnd_api.g_miss_char,

1268: p_attribute5
1269: ),
1270: attribute6 = DECODE (
1271: p_attribute6,
1272: fnd_api.g_miss_char,
1273: attribute6,
1274: p_attribute6
1275: ),
1276: attribute7 = DECODE (

Line 1278: fnd_api.g_miss_char,

1274: p_attribute6
1275: ),
1276: attribute7 = DECODE (
1277: p_attribute7,
1278: fnd_api.g_miss_char,
1279: attribute7,
1280: p_attribute7
1281: ),
1282: attribute8 = DECODE (

Line 1284: fnd_api.g_miss_char,

1280: p_attribute7
1281: ),
1282: attribute8 = DECODE (
1283: p_attribute8,
1284: fnd_api.g_miss_char,
1285: attribute8,
1286: p_attribute8
1287: ),
1288: attribute9 = DECODE (

Line 1290: fnd_api.g_miss_char,

1286: p_attribute8
1287: ),
1288: attribute9 = DECODE (
1289: p_attribute9,
1290: fnd_api.g_miss_char,
1291: attribute9,
1292: p_attribute9
1293: ),
1294: attribute10 = DECODE (

Line 1296: fnd_api.g_miss_char,

1292: p_attribute9
1293: ),
1294: attribute10 = DECODE (
1295: p_attribute10,
1296: fnd_api.g_miss_char,
1297: attribute10,
1298: p_attribute10
1299: ),
1300: attribute11 = DECODE (

Line 1302: fnd_api.g_miss_char,

1298: p_attribute10
1299: ),
1300: attribute11 = DECODE (
1301: p_attribute11,
1302: fnd_api.g_miss_char,
1303: attribute11,
1304: p_attribute11
1305: ),
1306: attribute12 = DECODE (

Line 1308: fnd_api.g_miss_char,

1304: p_attribute11
1305: ),
1306: attribute12 = DECODE (
1307: p_attribute12,
1308: fnd_api.g_miss_char,
1309: attribute12,
1310: p_attribute12
1311: ),
1312: attribute13 = DECODE (

Line 1314: fnd_api.g_miss_char,

1310: p_attribute12
1311: ),
1312: attribute13 = DECODE (
1313: p_attribute13,
1314: fnd_api.g_miss_char,
1315: attribute13,
1316: p_attribute13
1317: ),
1318: attribute14 = DECODE (

Line 1320: fnd_api.g_miss_char,

1316: p_attribute13
1317: ),
1318: attribute14 = DECODE (
1319: p_attribute14,
1320: fnd_api.g_miss_char,
1321: attribute14,
1322: p_attribute14
1323: ),
1324: attribute15 = DECODE (

Line 1326: fnd_api.g_miss_char,

1322: p_attribute14
1323: ),
1324: attribute15 = DECODE (
1325: p_attribute15,
1326: fnd_api.g_miss_char,
1327: attribute15,
1328: p_attribute15
1329: ),
1330: attribute16 = DECODE (

Line 1332: fnd_api.g_miss_char,

1328: p_attribute15
1329: ),
1330: attribute16 = DECODE (
1331: p_attribute16,
1332: fnd_api.g_miss_char,
1333: attribute16,
1334: p_attribute16
1335: ),
1336: attribute17 = DECODE (

Line 1338: fnd_api.g_miss_char,

1334: p_attribute16
1335: ),
1336: attribute17 = DECODE (
1337: p_attribute17,
1338: fnd_api.g_miss_char,
1339: attribute17,
1340: p_attribute17
1341: ),
1342: attribute18 = DECODE (

Line 1344: fnd_api.g_miss_char,

1340: p_attribute17
1341: ),
1342: attribute18 = DECODE (
1343: p_attribute18,
1344: fnd_api.g_miss_char,
1345: attribute18,
1346: p_attribute18
1347: ),
1348: attribute19 = DECODE (

Line 1350: fnd_api.g_miss_char,

1346: p_attribute18
1347: ),
1348: attribute19 = DECODE (
1349: p_attribute19,
1350: fnd_api.g_miss_char,
1351: attribute19,
1352: p_attribute19
1353: ),
1354: attribute20 = DECODE (

Line 1356: fnd_api.g_miss_char,

1352: p_attribute19
1353: ),
1354: attribute20 = DECODE (
1355: p_attribute20,
1356: fnd_api.g_miss_char,
1357: attribute20,
1358: p_attribute20
1359: ),
1360: CONTEXT = DECODE (

Line 1362: fnd_api.g_miss_char,

1358: p_attribute20
1359: ),
1360: CONTEXT = DECODE (
1361: p_context,
1362: fnd_api.g_miss_char,
1363: CONTEXT,
1364: p_context
1365: ),
1366: security_group_id = DECODE (

Line 1368: fnd_api.g_miss_num,

1364: p_context
1365: ),
1366: security_group_id = DECODE (
1367: p_security_group_id,
1368: fnd_api.g_miss_num,
1369: security_group_id,
1370: p_security_group_id
1371: ),
1372: object_version_number = DECODE (

Line 1374: fnd_api.g_miss_num,

1370: p_security_group_id
1371: ),
1372: object_version_number = DECODE (
1373: p_object_version_number,
1374: fnd_api.g_miss_num,
1375: object_version_number,
1376: p_object_version_number
1377: )
1378: WHERE approval_det_id = p_approval_det_id;

Line 1565: --If (px_RULE_ID IS NULL) OR (px_RULE_ID = FND_API.G_MISS_NUM) then

1561: 1,
1562: 'N'
1563: );
1564: END IF;
1565: --If (px_RULE_ID IS NULL) OR (px_RULE_ID = FND_API.G_MISS_NUM) then
1566: OPEN c2;
1567: FETCH c2 INTO px_rule_id;
1568: CLOSE c2;
1569: --End If;

Line 1606: fnd_api.g_miss_num,

1602: object_version_number)
1603: VALUES (px_rule_id,
1604: DECODE (
1605: p_oam_rule_id,
1606: fnd_api.g_miss_num,
1607: NULL,
1608: p_oam_rule_id
1609: ),
1610: DECODE (

Line 1612: fnd_api.g_miss_num,

1608: p_oam_rule_id
1609: ),
1610: DECODE (
1611: p_rule_action_id,
1612: fnd_api.g_miss_num,
1613: NULL,
1614: p_rule_action_id
1615: ),
1616: aso_utility_pvt.DECODE (

Line 1618: fnd_api.g_miss_date,

1614: p_rule_action_id
1615: ),
1616: aso_utility_pvt.DECODE (
1617: p_creation_date,
1618: fnd_api.g_miss_date,
1619: NULL,
1620: p_creation_date
1621: ),
1622: DECODE (

Line 1624: fnd_api.g_miss_num,

1620: p_creation_date
1621: ),
1622: DECODE (
1623: p_created_by,
1624: fnd_api.g_miss_num,
1625: NULL,
1626: p_created_by
1627: ),
1628: aso_utility_pvt.DECODE (

Line 1630: fnd_api.g_miss_date,

1626: p_created_by
1627: ),
1628: aso_utility_pvt.DECODE (
1629: p_last_update_date,
1630: fnd_api.g_miss_date,
1631: NULL,
1632: p_last_update_date
1633: ),
1634: DECODE (

Line 1636: fnd_api.g_miss_num,

1632: p_last_update_date
1633: ),
1634: DECODE (
1635: p_last_updated_by,
1636: fnd_api.g_miss_num,
1637: NULL,
1638: p_last_updated_by
1639: ),
1640: DECODE (

Line 1642: fnd_api.g_miss_num,

1638: p_last_updated_by
1639: ),
1640: DECODE (
1641: p_last_update_login,
1642: fnd_api.g_miss_num,
1643: NULL,
1644: p_last_update_login
1645: ),
1646: DECODE (

Line 1648: fnd_api.g_miss_num,

1644: p_last_update_login
1645: ),
1646: DECODE (
1647: p_object_approval_id,
1648: fnd_api.g_miss_num,
1649: NULL,
1650: p_object_approval_id
1651: ),
1652: DECODE (

Line 1654: fnd_api.g_miss_char,

1650: p_object_approval_id
1651: ),
1652: DECODE (
1653: p_attribute1,
1654: fnd_api.g_miss_char,
1655: NULL,
1656: p_attribute1
1657: ),
1658: DECODE (

Line 1660: fnd_api.g_miss_char,

1656: p_attribute1
1657: ),
1658: DECODE (
1659: p_attribute2,
1660: fnd_api.g_miss_char,
1661: NULL,
1662: p_attribute2
1663: ),
1664: DECODE (

Line 1666: fnd_api.g_miss_char,

1662: p_attribute2
1663: ),
1664: DECODE (
1665: p_attribute3,
1666: fnd_api.g_miss_char,
1667: NULL,
1668: p_attribute3
1669: ),
1670: DECODE (

Line 1672: fnd_api.g_miss_char,

1668: p_attribute3
1669: ),
1670: DECODE (
1671: p_attribute4,
1672: fnd_api.g_miss_char,
1673: NULL,
1674: p_attribute4
1675: ),
1676: DECODE (

Line 1678: fnd_api.g_miss_char,

1674: p_attribute4
1675: ),
1676: DECODE (
1677: p_attribute5,
1678: fnd_api.g_miss_char,
1679: NULL,
1680: p_attribute5
1681: ),
1682: DECODE (

Line 1684: fnd_api.g_miss_char,

1680: p_attribute5
1681: ),
1682: DECODE (
1683: p_attribute6,
1684: fnd_api.g_miss_char,
1685: NULL,
1686: p_attribute6
1687: ),
1688: DECODE (

Line 1690: fnd_api.g_miss_char,

1686: p_attribute6
1687: ),
1688: DECODE (
1689: p_attribute7,
1690: fnd_api.g_miss_char,
1691: NULL,
1692: p_attribute7
1693: ),
1694: DECODE (

Line 1696: fnd_api.g_miss_char,

1692: p_attribute7
1693: ),
1694: DECODE (
1695: p_attribute8,
1696: fnd_api.g_miss_char,
1697: NULL,
1698: p_attribute8
1699: ),
1700: DECODE (

Line 1702: fnd_api.g_miss_char,

1698: p_attribute8
1699: ),
1700: DECODE (
1701: p_attribute9,
1702: fnd_api.g_miss_char,
1703: NULL,
1704: p_attribute9
1705: ),
1706: DECODE (

Line 1708: fnd_api.g_miss_char,

1704: p_attribute9
1705: ),
1706: DECODE (
1707: p_attribute10,
1708: fnd_api.g_miss_char,
1709: NULL,
1710: p_attribute10
1711: ),
1712: DECODE (

Line 1714: fnd_api.g_miss_char,

1710: p_attribute10
1711: ),
1712: DECODE (
1713: p_attribute11,
1714: fnd_api.g_miss_char,
1715: NULL,
1716: p_attribute11
1717: ),
1718: DECODE (

Line 1720: fnd_api.g_miss_char,

1716: p_attribute11
1717: ),
1718: DECODE (
1719: p_attribute12,
1720: fnd_api.g_miss_char,
1721: NULL,
1722: p_attribute12
1723: ),
1724: DECODE (

Line 1726: fnd_api.g_miss_char,

1722: p_attribute12
1723: ),
1724: DECODE (
1725: p_attribute13,
1726: fnd_api.g_miss_char,
1727: NULL,
1728: p_attribute13
1729: ),
1730: DECODE (

Line 1732: fnd_api.g_miss_char,

1728: p_attribute13
1729: ),
1730: DECODE (
1731: p_attribute14,
1732: fnd_api.g_miss_char,
1733: NULL,
1734: p_attribute14
1735: ),
1736: DECODE (

Line 1738: fnd_api.g_miss_char,

1734: p_attribute14
1735: ),
1736: DECODE (
1737: p_attribute15,
1738: fnd_api.g_miss_char,
1739: NULL,
1740: p_attribute15
1741: ),
1742: DECODE (

Line 1744: fnd_api.g_miss_char,

1740: p_attribute15
1741: ),
1742: DECODE (
1743: p_attribute16,
1744: fnd_api.g_miss_char,
1745: NULL,
1746: p_attribute16
1747: ),
1748: DECODE (

Line 1750: fnd_api.g_miss_char,

1746: p_attribute16
1747: ),
1748: DECODE (
1749: p_attribute17,
1750: fnd_api.g_miss_char,
1751: NULL,
1752: p_attribute17
1753: ),
1754: DECODE (

Line 1756: fnd_api.g_miss_char,

1752: p_attribute17
1753: ),
1754: DECODE (
1755: p_attribute18,
1756: fnd_api.g_miss_char,
1757: NULL,
1758: p_attribute18
1759: ),
1760: DECODE (

Line 1762: fnd_api.g_miss_char,

1758: p_attribute18
1759: ),
1760: DECODE (
1761: p_attribute19,
1762: fnd_api.g_miss_char,
1763: NULL,
1764: p_attribute19
1765: ),
1766: DECODE (

Line 1768: fnd_api.g_miss_char,

1764: p_attribute19
1765: ),
1766: DECODE (
1767: p_attribute20,
1768: fnd_api.g_miss_char,
1769: NULL,
1770: p_attribute20
1771: ),
1772: DECODE (

Line 1774: fnd_api.g_miss_char,

1770: p_attribute20
1771: ),
1772: DECODE (
1773: p_context,
1774: fnd_api.g_miss_char,
1775: NULL,
1776: p_context
1777: ),
1778: DECODE (

Line 1780: fnd_api.g_miss_num,

1776: p_context
1777: ),
1778: DECODE (
1779: p_security_group_id,
1780: fnd_api.g_miss_num,
1781: NULL,
1782: p_security_group_id
1783: ),
1784: DECODE (

Line 1786: fnd_api.g_miss_num,

1782: p_security_group_id
1783: ),
1784: DECODE (
1785: p_object_version_number,
1786: fnd_api.g_miss_num,
1787: NULL,
1788: p_object_version_number
1789: ));
1790:

Line 1847: fnd_api.g_miss_num,

1843: UPDATE aso_apr_rules
1844: SET rule_id = p_rule_id,
1845: oam_rule_id = DECODE (
1846: p_oam_rule_id,
1847: fnd_api.g_miss_num,
1848: rule_id,
1849: p_oam_rule_id
1850: ),
1851: rule_action_id = DECODE (

Line 1853: fnd_api.g_miss_num,

1849: p_oam_rule_id
1850: ),
1851: rule_action_id = DECODE (
1852: p_rule_action_id,
1853: fnd_api.g_miss_num,
1854: rule_action_id,
1855: p_rule_action_id
1856: ),
1857: creation_date = aso_utility_pvt.DECODE (

Line 1859: fnd_api.g_miss_date,

1855: p_rule_action_id
1856: ),
1857: creation_date = aso_utility_pvt.DECODE (
1858: p_creation_date,
1859: fnd_api.g_miss_date,
1860: creation_date,
1861: p_creation_date
1862: ),
1863: created_by = DECODE (

Line 1865: fnd_api.g_miss_num,

1861: p_creation_date
1862: ),
1863: created_by = DECODE (
1864: p_created_by,
1865: fnd_api.g_miss_num,
1866: created_by,
1867: p_created_by
1868: ),
1869: last_update_date = aso_utility_pvt.DECODE (

Line 1871: fnd_api.g_miss_date,

1867: p_created_by
1868: ),
1869: last_update_date = aso_utility_pvt.DECODE (
1870: p_last_update_date,
1871: fnd_api.g_miss_date,
1872: last_update_date,
1873: p_last_update_date
1874: ),
1875: last_updated_by = DECODE (

Line 1877: fnd_api.g_miss_num,

1873: p_last_update_date
1874: ),
1875: last_updated_by = DECODE (
1876: p_last_updated_by,
1877: fnd_api.g_miss_num,
1878: NULL,
1879: p_last_updated_by
1880: ),
1881: last_update_login = DECODE (

Line 1883: fnd_api.g_miss_num,

1879: p_last_updated_by
1880: ),
1881: last_update_login = DECODE (
1882: p_last_update_login,
1883: fnd_api.g_miss_num,
1884: last_update_login,
1885: p_last_update_login
1886: ),
1887: object_approval_id = DECODE (

Line 1889: fnd_api.g_miss_num,

1885: p_last_update_login
1886: ),
1887: object_approval_id = DECODE (
1888: p_object_approval_id,
1889: fnd_api.g_miss_num,
1890: object_approval_id,
1891: p_object_approval_id
1892: ),
1893: attribute1 = DECODE (

Line 1895: fnd_api.g_miss_char,

1891: p_object_approval_id
1892: ),
1893: attribute1 = DECODE (
1894: p_attribute1,
1895: fnd_api.g_miss_char,
1896: attribute1,
1897: p_attribute1
1898: ),
1899: attribute2 = DECODE (

Line 1901: fnd_api.g_miss_char,

1897: p_attribute1
1898: ),
1899: attribute2 = DECODE (
1900: p_attribute2,
1901: fnd_api.g_miss_char,
1902: attribute2,
1903: p_attribute2
1904: ),
1905: attribute3 = DECODE (

Line 1907: fnd_api.g_miss_char,

1903: p_attribute2
1904: ),
1905: attribute3 = DECODE (
1906: p_attribute3,
1907: fnd_api.g_miss_char,
1908: attribute3,
1909: p_attribute3
1910: ),
1911: attribute4 = DECODE (

Line 1913: fnd_api.g_miss_char,

1909: p_attribute3
1910: ),
1911: attribute4 = DECODE (
1912: p_attribute4,
1913: fnd_api.g_miss_char,
1914: attribute4,
1915: p_attribute4
1916: ),
1917: attribute5 = DECODE (

Line 1919: fnd_api.g_miss_char,

1915: p_attribute4
1916: ),
1917: attribute5 = DECODE (
1918: p_attribute5,
1919: fnd_api.g_miss_char,
1920: attribute5,
1921: p_attribute5
1922: ),
1923: attribute6 = DECODE (

Line 1925: fnd_api.g_miss_char,

1921: p_attribute5
1922: ),
1923: attribute6 = DECODE (
1924: p_attribute6,
1925: fnd_api.g_miss_char,
1926: attribute6,
1927: p_attribute6
1928: ),
1929: attribute7 = DECODE (

Line 1931: fnd_api.g_miss_char,

1927: p_attribute6
1928: ),
1929: attribute7 = DECODE (
1930: p_attribute7,
1931: fnd_api.g_miss_char,
1932: attribute7,
1933: p_attribute7
1934: ),
1935: attribute8 = DECODE (

Line 1937: fnd_api.g_miss_char,

1933: p_attribute7
1934: ),
1935: attribute8 = DECODE (
1936: p_attribute8,
1937: fnd_api.g_miss_char,
1938: attribute8,
1939: p_attribute8
1940: ),
1941: attribute9 = DECODE (

Line 1943: fnd_api.g_miss_char,

1939: p_attribute8
1940: ),
1941: attribute9 = DECODE (
1942: p_attribute9,
1943: fnd_api.g_miss_char,
1944: attribute9,
1945: p_attribute9
1946: ),
1947: attribute10 = DECODE (

Line 1949: fnd_api.g_miss_char,

1945: p_attribute9
1946: ),
1947: attribute10 = DECODE (
1948: p_attribute10,
1949: fnd_api.g_miss_char,
1950: attribute10,
1951: p_attribute10
1952: ),
1953: attribute11 = DECODE (

Line 1955: fnd_api.g_miss_char,

1951: p_attribute10
1952: ),
1953: attribute11 = DECODE (
1954: p_attribute11,
1955: fnd_api.g_miss_char,
1956: attribute11,
1957: p_attribute11
1958: ),
1959: attribute12 = DECODE (

Line 1961: fnd_api.g_miss_char,

1957: p_attribute11
1958: ),
1959: attribute12 = DECODE (
1960: p_attribute12,
1961: fnd_api.g_miss_char,
1962: attribute12,
1963: p_attribute12
1964: ),
1965: attribute13 = DECODE (

Line 1967: fnd_api.g_miss_char,

1963: p_attribute12
1964: ),
1965: attribute13 = DECODE (
1966: p_attribute13,
1967: fnd_api.g_miss_char,
1968: attribute13,
1969: p_attribute13
1970: ),
1971: attribute14 = DECODE (

Line 1973: fnd_api.g_miss_char,

1969: p_attribute13
1970: ),
1971: attribute14 = DECODE (
1972: p_attribute14,
1973: fnd_api.g_miss_char,
1974: attribute14,
1975: p_attribute14
1976: ),
1977: attribute15 = DECODE (

Line 1979: fnd_api.g_miss_char,

1975: p_attribute14
1976: ),
1977: attribute15 = DECODE (
1978: p_attribute15,
1979: fnd_api.g_miss_char,
1980: attribute15,
1981: p_attribute15
1982: ),
1983: attribute16 = DECODE (

Line 1985: fnd_api.g_miss_char,

1981: p_attribute15
1982: ),
1983: attribute16 = DECODE (
1984: p_attribute16,
1985: fnd_api.g_miss_char,
1986: attribute16,
1987: p_attribute16
1988: ),
1989: attribute17 = DECODE (

Line 1991: fnd_api.g_miss_char,

1987: p_attribute16
1988: ),
1989: attribute17 = DECODE (
1990: p_attribute17,
1991: fnd_api.g_miss_char,
1992: attribute17,
1993: p_attribute17
1994: ),
1995: attribute18 = DECODE (

Line 1997: fnd_api.g_miss_char,

1993: p_attribute17
1994: ),
1995: attribute18 = DECODE (
1996: p_attribute18,
1997: fnd_api.g_miss_char,
1998: attribute18,
1999: p_attribute18
2000: ),
2001: attribute19 = DECODE (

Line 2003: fnd_api.g_miss_char,

1999: p_attribute18
2000: ),
2001: attribute19 = DECODE (
2002: p_attribute19,
2003: fnd_api.g_miss_char,
2004: attribute19,
2005: p_attribute19
2006: ),
2007: attribute20 = DECODE (

Line 2009: fnd_api.g_miss_char,

2005: p_attribute19
2006: ),
2007: attribute20 = DECODE (
2008: p_attribute20,
2009: fnd_api.g_miss_char,
2010: attribute20,
2011: p_attribute20
2012: ),
2013: CONTEXT = DECODE (

Line 2015: fnd_api.g_miss_char,

2011: p_attribute20
2012: ),
2013: CONTEXT = DECODE (
2014: p_context,
2015: fnd_api.g_miss_char,
2016: CONTEXT,
2017: p_context
2018: ),
2019: security_group_id = DECODE (

Line 2021: fnd_api.g_miss_num,

2017: p_context
2018: ),
2019: security_group_id = DECODE (
2020: p_security_group_id,
2021: fnd_api.g_miss_num,
2022: security_group_id,
2023: p_security_group_id
2024: ),
2025: object_version_number = DECODE (

Line 2027: fnd_api.g_miss_num,

2023: p_security_group_id
2024: ),
2025: object_version_number = DECODE (
2026: p_object_version_number,
2027: fnd_api.g_miss_num,
2028: object_version_number,
2029: p_object_version_number
2030: )
2031: WHERE rule_id = p_rule_id;