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.OE_HEADER_SECURITY dependencies on OE_AK_ORDER_HEADERS_V

Line 15: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

11:
12: FUNCTION Is_Op_Constrained
13: ( p_operation IN VARCHAR2
14: , p_column_name IN VARCHAR2 DEFAULT NULL
15: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
16: , x_on_operation_action OUT NOCOPY NUMBER
17:
18: ) RETURN NUMBER IS
19: l_constraint_id NUMBER;

Line 314: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

310:
311:
312: FUNCTION ACCOUNTING_RULE
313: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
314: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
315: , x_on_operation_action OUT NOCOPY NUMBER
316:
317: ) RETURN NUMBER
318: IS

Line 335: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

331: END ACCOUNTING_RULE;
332:
333: FUNCTION ACCOUNTING_RULE_DURATION
334: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
335: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
336: , x_on_operation_action OUT NOCOPY NUMBER
337:
338: ) RETURN NUMBER
339: IS

Line 359: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

355: -- Start of fix #1459428 for function definition
356:
357: FUNCTION ATTRIBUTE1
358: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
359: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
360: , x_on_operation_action OUT NOCOPY NUMBER
361:
362: ) RETURN NUMBER
363: IS

Line 380: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

376: END ATTRIBUTE1;
377:
378: FUNCTION ATTRIBUTE10
379: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
380: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
381: , x_on_operation_action OUT NOCOPY NUMBER
382:
383: ) RETURN NUMBER
384: IS

Line 401: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

397: END ATTRIBUTE10;
398:
399: FUNCTION ATTRIBUTE11
400: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
401: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
402: , x_on_operation_action OUT NOCOPY NUMBER
403:
404: ) RETURN NUMBER
405: IS

Line 423: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

419:
420:
421: FUNCTION ATTRIBUTE12
422: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
423: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
424: , x_on_operation_action OUT NOCOPY NUMBER
425:
426: ) RETURN NUMBER
427: IS

Line 444: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

440: END ATTRIBUTE12;
441:
442: FUNCTION ATTRIBUTE13
443: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
444: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
445: , x_on_operation_action OUT NOCOPY NUMBER
446:
447: ) RETURN NUMBER
448: IS

Line 466: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

462:
463:
464: FUNCTION ATTRIBUTE14
465: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
466: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
467: , x_on_operation_action OUT NOCOPY NUMBER
468:
469: ) RETURN NUMBER
470: IS

Line 487: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

483: END ATTRIBUTE14;
484:
485: FUNCTION ATTRIBUTE15
486: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
487: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
488: , x_on_operation_action OUT NOCOPY NUMBER
489:
490: ) RETURN NUMBER
491: IS

Line 509: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

505:
506: -- For bug 2184255
507: FUNCTION ATTRIBUTE16
508: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
509: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
510: , x_on_operation_action OUT NOCOPY NUMBER
511:
512: ) RETURN NUMBER
513: IS

Line 531: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

527:
528:
529: FUNCTION ATTRIBUTE17
530: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
531: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
532: , x_on_operation_action OUT NOCOPY NUMBER
533:
534: ) RETURN NUMBER
535: IS

Line 552: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

548: END ATTRIBUTE17;
549:
550: FUNCTION ATTRIBUTE18
551: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
552: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
553: , x_on_operation_action OUT NOCOPY NUMBER
554:
555: ) RETURN NUMBER
556: IS

Line 574: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

570:
571:
572: FUNCTION ATTRIBUTE19
573: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
574: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
575: , x_on_operation_action OUT NOCOPY NUMBER
576:
577: ) RETURN NUMBER
578: IS

Line 596: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

592:
593:
594: FUNCTION ATTRIBUTE2
595: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
596: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
597: , x_on_operation_action OUT NOCOPY NUMBER
598:
599: ) RETURN NUMBER
600: IS

Line 617: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

613: END ATTRIBUTE2;
614:
615: FUNCTION ATTRIBUTE20
616: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
617: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
618: , x_on_operation_action OUT NOCOPY NUMBER
619:
620: ) RETURN NUMBER
621: IS

Line 638: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

634: END ATTRIBUTE20;
635:
636: FUNCTION ATTRIBUTE3
637: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
638: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
639: , x_on_operation_action OUT NOCOPY NUMBER
640:
641: ) RETURN NUMBER
642: IS

Line 660: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

656:
657:
658: FUNCTION ATTRIBUTE4
659: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
660: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
661: , x_on_operation_action OUT NOCOPY NUMBER
662:
663: ) RETURN NUMBER
664: IS

Line 681: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

677: END ATTRIBUTE4;
678:
679: FUNCTION ATTRIBUTE5
680: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
681: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
682: , x_on_operation_action OUT NOCOPY NUMBER
683:
684: ) RETURN NUMBER
685: IS

Line 703: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

699:
700:
701: FUNCTION ATTRIBUTE6
702: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
703: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
704: , x_on_operation_action OUT NOCOPY NUMBER
705:
706: ) RETURN NUMBER
707: IS

Line 724: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

720: END ATTRIBUTE6;
721:
722: FUNCTION ATTRIBUTE7
723: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
724: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
725: , x_on_operation_action OUT NOCOPY NUMBER
726:
727: ) RETURN NUMBER
728: IS

Line 746: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

742:
743:
744: FUNCTION ATTRIBUTE8
745: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
746: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
747: , x_on_operation_action OUT NOCOPY NUMBER
748:
749: ) RETURN NUMBER
750: IS

Line 767: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

763: END ATTRIBUTE8;
764:
765: FUNCTION ATTRIBUTE9
766: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
767: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
768: , x_on_operation_action OUT NOCOPY NUMBER
769:
770: ) RETURN NUMBER
771: IS

Line 788: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

784: END ATTRIBUTE9;
785:
786: FUNCTION CANCELLED
787: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
788: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
789: , x_on_operation_action OUT NOCOPY NUMBER
790:
791: ) RETURN NUMBER
792: IS

Line 809: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

805: END CANCELLED;
806:
807: FUNCTION AGREEMENT
808: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
809: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
810: , x_on_operation_action OUT NOCOPY NUMBER
811:
812: ) RETURN NUMBER
813: IS

Line 830: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

826: END AGREEMENT;
827:
828: FUNCTION CONTEXT
829: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
830: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
831: , x_on_operation_action OUT NOCOPY NUMBER
832:
833: ) RETURN NUMBER
834: IS

Line 853: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

849: -- End of fix #1459428 for function definition
850:
851: FUNCTION CONVERSION_RATE
852: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
853: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
854: , x_on_operation_action OUT NOCOPY NUMBER
855:
856: ) RETURN NUMBER
857: IS

Line 875: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

871:
872:
873: FUNCTION CONVERSION_RATE_DATE
874: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
875: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
876: , x_on_operation_action OUT NOCOPY NUMBER
877:
878: ) RETURN NUMBER
879: IS

Line 896: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

892: END CONVERSION_RATE_DATE;
893:
894: FUNCTION CUSTOMER_PREFERENCE_SET
895: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
896: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
897: , x_on_operation_action OUT NOCOPY NUMBER
898:
899: ) RETURN NUMBER
900: IS

Line 917: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

913: END CUSTOMER_PREFERENCE_SET;
914:
915: FUNCTION CONVERSION_TYPE
916: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
917: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
918: , x_on_operation_action OUT NOCOPY NUMBER
919:
920: ) RETURN NUMBER
921: IS

Line 939: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

935:
936:
937: FUNCTION CREATED_BY
938: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
939: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
940: , x_on_operation_action OUT NOCOPY NUMBER
941:
942: ) RETURN NUMBER
943: IS

Line 961: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

957:
958:
959: FUNCTION CUST_PO_NUMBER
960: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
961: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
962: , x_on_operation_action OUT NOCOPY NUMBER
963:
964: ) RETURN NUMBER
965: IS

Line 983: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

979:
980:
981: FUNCTION DELIVER_TO_CONTACT
982: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
983: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
984: , x_on_operation_action OUT NOCOPY NUMBER
985:
986: ) RETURN NUMBER
987: IS

Line 1004: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1000: END DELIVER_TO_CONTACT;
1001:
1002: FUNCTION IB_OWNER
1003: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1004: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1005: , x_on_operation_action OUT NOCOPY NUMBER
1006:
1007: ) RETURN NUMBER
1008: IS

Line 1025: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1021: END IB_OWNER;
1022:
1023: FUNCTION IB_INSTALLED_AT_LOCATION
1024: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1025: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1026: , x_on_operation_action OUT NOCOPY NUMBER
1027:
1028: ) RETURN NUMBER
1029: IS

Line 1046: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1042: END IB_INSTALLED_AT_LOCATION;
1043:
1044: FUNCTION IB_CURRENT_LOCATION
1045: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1046: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1047: , x_on_operation_action OUT NOCOPY NUMBER
1048:
1049: ) RETURN NUMBER
1050: IS

Line 1067: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1063: END IB_CURRENT_LOCATION;
1064:
1065: FUNCTION END_CUSTOMER_CONTACT
1066: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1067: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1068: , x_on_operation_action OUT NOCOPY NUMBER
1069:
1070: ) RETURN NUMBER
1071: IS

Line 1089: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1085:
1086:
1087: FUNCTION END_CUSTOMER_SITE_USE
1088: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1089: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1090: , x_on_operation_action OUT NOCOPY NUMBER
1091:
1092: ) RETURN NUMBER
1093: IS

Line 1111: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1107:
1108:
1109: FUNCTION END_CUSTOMER
1110: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1111: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1112: , x_on_operation_action OUT NOCOPY NUMBER
1113:
1114: ) RETURN NUMBER
1115: IS

Line 1133: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1129:
1130:
1131: FUNCTION DELIVER_TO_ORG
1132: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1133: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1134: , x_on_operation_action OUT NOCOPY NUMBER
1135:
1136: ) RETURN NUMBER
1137: IS

Line 1155: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1151:
1152:
1153: FUNCTION DEMAND_CLASS
1154: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1155: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1156: , x_on_operation_action OUT NOCOPY NUMBER
1157:
1158: ) RETURN NUMBER
1159: IS

Line 1176: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1172: END DEMAND_CLASS;
1173:
1174: FUNCTION EARLIEST_SCHEDULE_LIMIT
1175: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1176: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1177: , x_on_operation_action OUT NOCOPY NUMBER
1178:
1179: ) RETURN NUMBER
1180: IS

Line 1197: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1193: END EARLIEST_SCHEDULE_LIMIT;
1194:
1195: FUNCTION FOB_POINT
1196: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1197: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1198: , x_on_operation_action OUT NOCOPY NUMBER
1199:
1200: ) RETURN NUMBER
1201: IS

Line 1219: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1215:
1216:
1217: FUNCTION FREIGHT_CARRIER
1218: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1219: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1220: , x_on_operation_action OUT NOCOPY NUMBER
1221:
1222: ) RETURN NUMBER
1223: IS

Line 1241: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1237:
1238:
1239: FUNCTION FREIGHT_TERMS
1240: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1241: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1242: , x_on_operation_action OUT NOCOPY NUMBER
1243:
1244: ) RETURN NUMBER
1245: IS

Line 1262: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1258: END FREIGHT_TERMS;
1259:
1260: FUNCTION INVOICE_TO_CONTACT
1261: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1262: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1263: , x_on_operation_action OUT NOCOPY NUMBER
1264:
1265: ) RETURN NUMBER
1266: IS

Line 1283: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1279: END INVOICE_TO_CONTACT;
1280:
1281: FUNCTION INVOICE_TO_ORG
1282: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1283: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1284: , x_on_operation_action OUT NOCOPY NUMBER
1285:
1286: ) RETURN NUMBER
1287: IS

Line 1304: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1300: END INVOICE_TO_ORG;
1301:
1302: FUNCTION INVOICING_RULE
1303: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1304: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1305: , x_on_operation_action OUT NOCOPY NUMBER
1306:
1307: ) RETURN NUMBER
1308: IS

Line 1325: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1321: END INVOICING_RULE;
1322:
1323: FUNCTION LATEST_SCHEDULE_LIMIT
1324: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1325: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1326: , x_on_operation_action OUT NOCOPY NUMBER
1327:
1328: ) RETURN NUMBER
1329: IS

Line 1347: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1343:
1344:
1345: FUNCTION ORDERED_DATE
1346: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1347: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1348: , x_on_operation_action OUT NOCOPY NUMBER
1349:
1350: ) RETURN NUMBER
1351: IS

Line 1369: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1365:
1366:
1367: FUNCTION ORDER_DATE_TYPE_CODE
1368: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1369: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1370: , x_on_operation_action OUT NOCOPY NUMBER
1371:
1372: ) RETURN NUMBER
1373: IS

Line 1390: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1386: END ORDER_DATE_TYPE_CODE;
1387:
1388: FUNCTION ORDER_NUMBER
1389: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1390: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1391: , x_on_operation_action OUT NOCOPY NUMBER
1392:
1393: ) RETURN NUMBER
1394: IS

Line 1412: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1408:
1409:
1410: FUNCTION ORDER_SOURCE
1411: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1412: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1413: , x_on_operation_action OUT NOCOPY NUMBER
1414:
1415: ) RETURN NUMBER
1416: IS

Line 1434: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1430:
1431:
1432: FUNCTION ORDER_TYPE
1433: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1434: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1435: , x_on_operation_action OUT NOCOPY NUMBER
1436:
1437: ) RETURN NUMBER
1438: IS

Line 1457: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1453:
1454:
1455: FUNCTION ORIG_SYS_DOCUMENT_REF
1456: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1457: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1458: , x_on_operation_action OUT NOCOPY NUMBER
1459:
1460: ) RETURN NUMBER
1461: IS

Line 1478: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1474: END ORIG_SYS_DOCUMENT_REF;
1475:
1476: FUNCTION PACKING_INSTRUCTIONS
1477: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1478: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1479: , x_on_operation_action OUT NOCOPY NUMBER
1480:
1481: ) RETURN NUMBER
1482: IS

Line 1500: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1496:
1497:
1498: FUNCTION PAYMENT_TERM
1499: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1500: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1501: , x_on_operation_action OUT NOCOPY NUMBER
1502:
1503: ) RETURN NUMBER
1504: IS

Line 1522: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1518:
1519:
1520: FUNCTION PRICE_LIST
1521: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1522: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1523: , x_on_operation_action OUT NOCOPY NUMBER
1524:
1525: ) RETURN NUMBER
1526: IS

Line 1544: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1540:
1541:
1542: FUNCTION PRICING_DATE
1543: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1544: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1545: , x_on_operation_action OUT NOCOPY NUMBER
1546:
1547: ) RETURN NUMBER
1548: IS

Line 1565: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1561: END PRICING_DATE;
1562:
1563: FUNCTION REQUEST_DATE
1564: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1565: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1566: , x_on_operation_action OUT NOCOPY NUMBER
1567:
1568: ) RETURN NUMBER
1569: IS

Line 1587: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1583:
1584:
1585: FUNCTION RETURN_REASON
1586: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1587: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1588: , x_on_operation_action OUT NOCOPY NUMBER
1589:
1590: ) RETURN NUMBER
1591: IS

Line 1609: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1605:
1606:
1607: FUNCTION SALESREP
1608: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1609: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1610: , x_on_operation_action OUT NOCOPY NUMBER
1611:
1612: ) RETURN NUMBER
1613: IS

Line 1631: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1627:
1628:
1629: FUNCTION SHIPMENT_PRIORITY
1630: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1631: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1632: , x_on_operation_action OUT NOCOPY NUMBER
1633:
1634: ) RETURN NUMBER
1635: IS

Line 1652: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1648: END SHIPMENT_PRIORITY;
1649:
1650: FUNCTION SHIPPING_INSTRUCTIONS
1651: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1652: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1653: , x_on_operation_action OUT NOCOPY NUMBER
1654:
1655: ) RETURN NUMBER
1656: IS

Line 1673: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1669: END SHIPPING_INSTRUCTIONS;
1670:
1671: FUNCTION SHIPPING_METHOD
1672: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1673: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1674: , x_on_operation_action OUT NOCOPY NUMBER
1675:
1676: ) RETURN NUMBER
1677: IS

Line 1694: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1690: END SHIPPING_METHOD;
1691:
1692: FUNCTION SHIP_FROM_ORG
1693: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1694: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1695: , x_on_operation_action OUT NOCOPY NUMBER
1696:
1697: ) RETURN NUMBER
1698: IS

Line 1716: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1712:
1713:
1714: FUNCTION SHIP_TOLERANCE_ABOVE
1715: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1716: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1717: , x_on_operation_action OUT NOCOPY NUMBER
1718:
1719: ) RETURN NUMBER
1720: IS

Line 1738: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1734:
1735:
1736: FUNCTION SHIP_TOLERANCE_BELOW
1737: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1738: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1739: , x_on_operation_action OUT NOCOPY NUMBER
1740:
1741: ) RETURN NUMBER
1742: IS

Line 1760: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1756:
1757:
1758: FUNCTION SHIP_TO_CONTACT
1759: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1760: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1761: , x_on_operation_action OUT NOCOPY NUMBER
1762:
1763: ) RETURN NUMBER
1764: IS

Line 1782: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1778:
1779:
1780: FUNCTION SHIP_TO_ORG
1781: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1782: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1783: , x_on_operation_action OUT NOCOPY NUMBER
1784:
1785: ) RETURN NUMBER
1786: IS

Line 1804: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1800:
1801:
1802: FUNCTION SOLD_TO_CONTACT
1803: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1804: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1805: , x_on_operation_action OUT NOCOPY NUMBER
1806:
1807: ) RETURN NUMBER
1808: IS

Line 1826: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1822:
1823:
1824: FUNCTION SOLD_TO_ORG
1825: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1826: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1827: , x_on_operation_action OUT NOCOPY NUMBER
1828:
1829: ) RETURN NUMBER
1830: IS

Line 1848: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1844:
1845:
1846: FUNCTION SOURCE_DOCUMENT_TYPE
1847: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1848: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1849: , x_on_operation_action OUT NOCOPY NUMBER
1850:
1851: ) RETURN NUMBER
1852: IS

Line 1870: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1866:
1867:
1868: FUNCTION TAX_EXEMPT
1869: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1870: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1871: , x_on_operation_action OUT NOCOPY NUMBER
1872:
1873: ) RETURN NUMBER
1874: IS

Line 1892: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1888:
1889:
1890: FUNCTION TAX_EXEMPT_NUMBER
1891: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1892: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1893: , x_on_operation_action OUT NOCOPY NUMBER
1894:
1895: ) RETURN NUMBER
1896: IS

Line 1914: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1910:
1911:
1912: FUNCTION TAX_EXEMPT_REASON
1913: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1914: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1915: , x_on_operation_action OUT NOCOPY NUMBER
1916:
1917: ) RETURN NUMBER
1918: IS

Line 1937: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1933:
1934:
1935: FUNCTION TRANSACTIONAL_CURR
1936: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1937: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1938: , x_on_operation_action OUT NOCOPY NUMBER
1939:
1940: ) RETURN NUMBER
1941: IS

Line 1959: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1955:
1956:
1957: FUNCTION CREDIT_CARD_APPROVAL_DATE
1958: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1959: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1960: , x_on_operation_action OUT NOCOPY NUMBER
1961:
1962: ) RETURN NUMBER
1963: IS

Line 1983: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1979: the Sales Channel Field be allowed to set the security rules */
1980:
1981: FUNCTION SALES_CHANNEL_CODE
1982: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1983: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1984: , x_on_operation_action OUT NOCOPY NUMBER
1985:
1986: ) RETURN NUMBER
1987: IS

Line 2005: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2001:
2002: /* START PREPAYMENT */
2003: FUNCTION PAYMENT_TYPE
2004: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2005: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2006: , x_on_operation_action OUT NOCOPY NUMBER
2007:
2008: ) RETURN NUMBER
2009: IS

Line 2026: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2022: END PAYMENT_TYPE;
2023:
2024: FUNCTION CREDIT_CARD_HOLDER_NAME
2025: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2026: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2027: , x_on_operation_action OUT NOCOPY NUMBER
2028:
2029: ) RETURN NUMBER
2030: IS

Line 2047: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2043: END CREDIT_CARD_HOLDER_NAME;
2044:
2045: FUNCTION CREDIT_CARD
2046: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2047: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2048: , x_on_operation_action OUT NOCOPY NUMBER
2049:
2050: ) RETURN NUMBER
2051: IS

Line 2068: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2064: END CREDIT_CARD;
2065:
2066: FUNCTION CREDIT_CARD_NUMBER
2067: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2068: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2069: , x_on_operation_action OUT NOCOPY NUMBER
2070:
2071: ) RETURN NUMBER
2072: IS

Line 2089: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2085: END CREDIT_CARD_NUMBER;
2086:
2087: FUNCTION CREDIT_CARD_EXPIRATION_DATE
2088: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2089: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2090: , x_on_operation_action OUT NOCOPY NUMBER
2091:
2092: ) RETURN NUMBER
2093: IS

Line 2113: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2109: /* For bug 2395032 */
2110:
2111: FUNCTION PAYMENT_AMOUNT
2112: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2113: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2114: , x_on_operation_action OUT NOCOPY NUMBER
2115:
2116: ) RETURN NUMBER
2117: IS

Line 2134: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2130: END PAYMENT_AMOUNT;
2131:
2132: FUNCTION CHECK_NUMBER
2133: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2134: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2135: , x_on_operation_action OUT NOCOPY NUMBER
2136:
2137: ) RETURN NUMBER
2138: IS

Line 2157: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2153: /* End 2395032 */
2154:
2155: FUNCTION BLANKET_NUMBER
2156: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2157: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2158: , x_on_operation_action OUT NOCOPY NUMBER
2159:
2160: ) RETURN NUMBER
2161: IS

Line 2180: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2176: -- QUOTING changes
2177:
2178: FUNCTION QUOTE_NUMBER
2179: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2180: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2181: , x_on_operation_action OUT NOCOPY NUMBER
2182:
2183: ) RETURN NUMBER
2184: IS

Line 2201: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2197: END QUOTE_NUMBER;
2198:
2199: FUNCTION QUOTE_DATE
2200: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2201: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2202: , x_on_operation_action OUT NOCOPY NUMBER
2203:
2204: ) RETURN NUMBER
2205: IS

Line 2222: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2218: END QUOTE_DATE;
2219:
2220: FUNCTION SALES_DOCUMENT_NAME
2221: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2222: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2223: , x_on_operation_action OUT NOCOPY NUMBER
2224:
2225: ) RETURN NUMBER
2226: IS

Line 2243: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2239: END SALES_DOCUMENT_NAME;
2240:
2241: FUNCTION TRANSACTION_PHASE
2242: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2243: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2244: , x_on_operation_action OUT NOCOPY NUMBER
2245:
2246: ) RETURN NUMBER
2247: IS

Line 2264: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2260: END TRANSACTION_PHASE;
2261:
2262: FUNCTION USER_STATUS
2263: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2264: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2265: , x_on_operation_action OUT NOCOPY NUMBER
2266:
2267: ) RETURN NUMBER
2268: IS

Line 2285: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2281: END USER_STATUS;
2282:
2283: FUNCTION EXPIRATION_DATE
2284: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2285: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2286: , x_on_operation_action OUT NOCOPY NUMBER
2287:
2288: ) RETURN NUMBER
2289: IS

Line 2306: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2302: END EXPIRATION_DATE;
2303:
2304: FUNCTION VERSION_NUMBER
2305: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2306: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2307: , x_on_operation_action OUT NOCOPY NUMBER
2308:
2309: ) RETURN NUMBER
2310: IS

Line 2327: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2323: END VERSION_NUMBER;
2324:
2325: FUNCTION SOLD_TO_SITE_USE
2326: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2327: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2328: , x_on_operation_action OUT NOCOPY NUMBER
2329:
2330: ) RETURN NUMBER
2331: IS

Line 2370: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2366:
2367: -- Bug 8217769 New Function added for Default Fulfillment Set
2368: FUNCTION DEFAULT_FULFILLMENT_SET
2369: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2370: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2371: , x_on_operation_action OUT NOCOPY NUMBER
2372: ) RETURN NUMBER
2373: IS
2374: l_result NUMBER;

Line 2395: l_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;

2391:
2392: ) IS
2393: l_operation VARCHAR2(1);
2394: l_on_operation_action NUMBER;
2395: l_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
2396: --
2397: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2398: --
2399: BEGIN

Line 2477: l_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;

2473: ) IS
2474: l_operation VARCHAR2(1);
2475: l_on_operation_action NUMBER;
2476: l_result NUMBER;
2477: l_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
2478: l_column_name VARCHAR2(30);
2479: l_active_flag VARCHAR2(1);
2480: e_inacitve_pl EXCEPTION;
2481: l_check_all_cols_constraint VARCHAR2(1);