DBA Data[Home] [Help]

APPS.AR_ARXKIR_XMLP_PKG dependencies on DUAL

Line 271: DUAL;

267: ,'990D00')
268: ,'n/a'))
269: INTO PERCENT_VALUE
270: FROM
271: DUAL;
272: IF PERCENT_VALUE = 'n/a' THEN
273: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
274: END IF;
275: RETURN (PERCENT_VALUE);

Line 296: DUAL;

292: ,'990D00')
293: ,'n/a'))
294: INTO PERCENT_VALUE
295: FROM
296: DUAL;
297: IF PERCENT_VALUE = 'n/a' THEN
298: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
299: END IF;
300: RETURN (PERCENT_VALUE);

Line 321: DUAL;

317: ,TO_CHAR((((CURRENT_NEW_INVOICES_COUN - PRIOR_NEW_INVOICES_COUNT) / PRIOR_NEW_INVOICES_COUNT)) * 100
318: ,'990D00'))
319: INTO PERCENT_VALUE
320: FROM
321: DUAL;
322: IF PERCENT_VALUE = 'n/a' THEN
323: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
324: END IF;
325: RETURN (PERCENT_VALUE);

Line 347: DUAL;

343: ,'990D00')
344: ,'n/a'))
345: INTO PERCENT_VALUE
346: FROM
347: DUAL;
348: IF PERCENT_VALUE = 'n/a' THEN
349: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
350: END IF;
351: RETURN (PERCENT_VALUE);

Line 373: DUAL;

369: ,'990D00')
370: ,'n/a'))
371: INTO PERCENT_VALUE
372: FROM
373: DUAL;
374: IF PERCENT_VALUE = 'n/a' THEN
375: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
376: END IF;
377: RETURN (PERCENT_VALUE);

Line 399: DUAL;

395: ,'990D00')
396: ,'n/a'))
397: INTO PERCENT_VALUE
398: FROM
399: DUAL;
400: IF PERCENT_VALUE = 'n/a' THEN
401: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
402: END IF;
403: RETURN (PERCENT_VALUE);

Line 425: DUAL;

421: ,'990D00')
422: ,'n/a'))
423: INTO PERCENT_VALUE
424: FROM
425: DUAL;
426: IF PERCENT_VALUE = 'n/a' THEN
427: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
428: END IF;
429: RETURN (PERCENT_VALUE);

Line 451: DUAL;

447: ,'990D00')
448: ,'n/a'))
449: INTO PERCENT_VALUE
450: FROM
451: DUAL;
452: IF PERCENT_VALUE = 'n/a' THEN
453: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
454: END IF;
455: RETURN (PERCENT_VALUE);

Line 476: DUAL;

472: ,'990D00')
473: ,'n/a'))
474: INTO PERCENT_VALUE
475: FROM
476: DUAL;
477: IF PERCENT_VALUE = 'n/a' THEN
478: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
479: END IF;
480: RETURN (PERCENT_VALUE);

Line 501: DUAL;

497: ,'990D00')
498: ,'n/a'))
499: INTO PERCENT_VALUE
500: FROM
501: DUAL;
502: IF PERCENT_VALUE = 'n/a' THEN
503: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
504: END IF;
505: RETURN (PERCENT_VALUE);

Line 527: DUAL;

523: ,'990D00')
524: ,'n/a'))
525: INTO PERCENT_VALUE
526: FROM
527: DUAL;
528: IF PERCENT_VALUE = 'n/a' THEN
529: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
530: END IF;
531: RETURN (PERCENT_VALUE);

Line 553: DUAL;

549: ,'990D00')
550: ,'n/a'))
551: INTO PERCENT_VALUE
552: FROM
553: DUAL;
554: IF PERCENT_VALUE = 'n/a' THEN
555: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
556: END IF;
557: RETURN (PERCENT_VALUE);

Line 579: DUAL;

575: ,'990D00')
576: ,'n/a'))
577: INTO PERCENT_VALUE
578: FROM
579: DUAL;
580: IF PERCENT_VALUE = 'n/a' THEN
581: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
582: END IF;
583: RETURN (PERCENT_VALUE);

Line 605: DUAL;

601: ,'990D00')
602: ,'n/a'))
603: INTO PERCENT_VALUE
604: FROM
605: DUAL;
606: IF PERCENT_VALUE = 'n/a' THEN
607: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
608: END IF;
609: RETURN (PERCENT_VALUE);

Line 631: DUAL;

627: ,'990D00')
628: ,'n/a'))
629: INTO PERCENT_VALUE
630: FROM
631: DUAL;
632: IF PERCENT_VALUE = 'n/a' THEN
633: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
634: END IF;
635: RETURN (PERCENT_VALUE);

Line 657: DUAL;

653: ,'990D00')
654: ,'n/a'))
655: INTO PERCENT_VALUE
656: FROM
657: DUAL;
658: IF PERCENT_VALUE = 'n/a' THEN
659: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
660: END IF;
661: RETURN (PERCENT_VALUE);

Line 683: DUAL;

679: ,'990D00')
680: ,'n/a'))
681: INTO PERCENT_VALUE
682: FROM
683: DUAL;
684: IF PERCENT_VALUE = 'n/a' THEN
685: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
686: END IF;
687: RETURN (PERCENT_VALUE);

Line 709: DUAL;

705: ,'990D00')
706: ,'n/a'))
707: INTO PERCENT_VALUE
708: FROM
709: DUAL;
710: IF PERCENT_VALUE = 'n/a' THEN
711: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
712: END IF;
713: RETURN (PERCENT_VALUE);

Line 735: DUAL;

731: ,'990D00')
732: ,'n/a'))
733: INTO PERCENT_VALUE
734: FROM
735: DUAL;
736: IF PERCENT_VALUE = 'n/a' THEN
737: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
738: END IF;
739: RETURN (PERCENT_VALUE);

Line 761: DUAL;

757: ,'990D00')
758: ,'n/a'))
759: INTO PERCENT_VALUE
760: FROM
761: DUAL;
762: IF PERCENT_VALUE = 'n/a' THEN
763: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
764: END IF;
765: RETURN (PERCENT_VALUE);

Line 787: DUAL;

783: ,'990D00')
784: ,'n/a'))
785: INTO PERCENT_VALUE
786: FROM
787: DUAL;
788: IF PERCENT_VALUE = 'n/a' THEN
789: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
790: END IF;
791: RETURN (PERCENT_VALUE);

Line 813: DUAL;

809: ,'990D00')
810: ,'n/a'))
811: INTO PERCENT_VALUE
812: FROM
813: DUAL;
814: IF PERCENT_VALUE = 'n/a' THEN
815: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
816: END IF;
817: RETURN (PERCENT_VALUE);

Line 839: DUAL;

835: ,'990D00')
836: ,'n/a'))
837: INTO PERCENT_VALUE
838: FROM
839: DUAL;
840: IF PERCENT_VALUE = 'n/a' THEN
841: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
842: END IF;
843: RETURN (PERCENT_VALUE);

Line 865: DUAL;

861: ,'990D00')
862: ,'n/a'))
863: INTO PERCENT_VALUE
864: FROM
865: DUAL;
866: IF PERCENT_VALUE = 'n/a' THEN
867: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
868: END IF;
869: RETURN (PERCENT_VALUE);

Line 891: DUAL;

887: ,'990D00')
888: ,'n/a'))
889: INTO PERCENT_VALUE
890: FROM
891: DUAL;
892: IF PERCENT_VALUE = 'n/a' THEN
893: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
894: END IF;
895: RETURN (PERCENT_VALUE);

Line 917: DUAL;

913: ,'990D00')
914: ,'n/a'))
915: INTO PERCENT_VALUE
916: FROM
917: DUAL;
918: IF PERCENT_VALUE = 'n/a' THEN
919: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
920: END IF;
921: RETURN (PERCENT_VALUE);

Line 943: DUAL;

939: ,'990D00')
940: ,'n/a'))
941: INTO PERCENT_VALUE
942: FROM
943: DUAL;
944: IF PERCENT_VALUE = 'n/a' THEN
945: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
946: END IF;
947: RETURN (PERCENT_VALUE);

Line 969: DUAL;

965: ,'990D00')
966: ,'n/a'))
967: INTO PERCENT_VALUE
968: FROM
969: DUAL;
970: IF PERCENT_VALUE = 'n/a' THEN
971: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
972: END IF;
973: RETURN (PERCENT_VALUE);

Line 994: DUAL;

990: ,'990D00')
991: ,'n/a'))
992: INTO PERCENT_VALUE
993: FROM
994: DUAL;
995: IF PERCENT_VALUE = 'n/a' THEN
996: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
997: END IF;
998: PC_CUSTOMER_COUNT := PERCENT_VALUE;

Line 1020: DUAL;

1016: ,'990D00')
1017: ,'n/a'))
1018: INTO PERCENT_VALUE
1019: FROM
1020: DUAL;
1021: IF PERCENT_VALUE = 'n/a' THEN
1022: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
1023: END IF;
1024: PC_LOCATION_COUNT := PERCENT_VALUE;

Line 1046: DUAL;

1042: ,'990D00')
1043: ,'n/a'))
1044: INTO PERCENT_VALUE
1045: FROM
1046: DUAL;
1047: IF PERCENT_VALUE = 'n/a' THEN
1048: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
1049: END IF;
1050: PC_PAY_PER_BATCH := PERCENT_VALUE;

Line 1072: DUAL;

1068: ,'990D00')
1069: ,'n/a'))
1070: INTO PERCENT_VALUE
1071: FROM
1072: DUAL;
1073: IF PERCENT_VALUE = 'n/a' THEN
1074: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
1075: END IF;
1076: PC_PAY_PER_DAY := PERCENT_VALUE;

Line 1098: DUAL;

1094: ,'990D00')
1095: ,'n/a'))
1096: INTO PERCENT_VALUE
1097: FROM
1098: DUAL;
1099: IF PERCENT_VALUE = 'n/a' THEN
1100: PERCENT_VALUE := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_NA_LOWER');
1101: END IF;
1102: PC_BATCH_PER_DAY_COUNT := PERCENT_VALUE;