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_BLANKET_HEADER_SECURITY dependencies on OE_PC_GLOBALS

Line 34: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_BLANKET_HEADER

30: ( p_responsibility_id => nvl(fnd_global.resp_id, -1)
31: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
32: , p_operation => p_operation
33: , p_qualifier_attribute => p_record.transaction_phase_code
34: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_BLANKET_HEADER
35: , p_column_name => p_column_name
36: , p_check_all_cols_constraint => g_check_all_cols_constraint
37: , p_is_caller_defaulting => g_is_caller_defaulting
38: , x_constraint_id => l_constraint_id

Line 43: if l_result = OE_PC_GLOBALS.YES then

39: , x_constraining_conditions_grp => l_grp
40: , x_on_operation_action => x_on_operation_action
41: );
42:
43: if l_result = OE_PC_GLOBALS.YES then
44:
45: IF g_check_all_cols_constraint = 'Y'
46: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
47: OR p_operation = OE_PC_GLOBALS.CREATE_OP)

Line 46: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP

42:
43: if l_result = OE_PC_GLOBALS.YES then
44:
45: IF g_check_all_cols_constraint = 'Y'
46: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
47: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
48: AND p_column_name IS NOT NULL THEN
49: SELECT column_name
50: INTO l_column_name

Line 47: OR p_operation = OE_PC_GLOBALS.CREATE_OP)

43: if l_result = OE_PC_GLOBALS.YES then
44:
45: IF g_check_all_cols_constraint = 'Y'
46: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
47: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
48: AND p_column_name IS NOT NULL THEN
49: SELECT column_name
50: INTO l_column_name
51: FROM oe_pc_constraints

Line 61: elsif l_result = OE_PC_GLOBALS.ERROR then

57: RAISE FND_API.G_EXC_ERROR;
58: end if;
59: END IF;
60:
61: elsif l_result = OE_PC_GLOBALS.ERROR then
62:
63: raise FND_API.G_EXC_UNEXPECTED_ERROR;
64:
65: end if;

Line 84: IF l_result = OE_PC_GLOBALS.YES THEN

80: IF g_is_caller_defaulting = 'N' THEN
81: IF l_code_level >= '110508' and nvl(l_audit_trail_enabled,'D') <> 'D' THEN
82: IF l_audit_trail_enabled = 'B' THEN -- capture only for booked orders
83: IF p_record.booked_flag = 'Y' THEN
84: IF l_result = OE_PC_GLOBALS.YES THEN
85: IF x_on_operation_action = 1 THEN
86: -- set OUT result to NOT CONSTRAINED
87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;

Line 104: IF l_result = OE_PC_GLOBALS.YES THEN

100: END IF;
101: END IF;
102: END IF;
103: ELSE -- capture audit trail for all orders
104: IF l_result = OE_PC_GLOBALS.YES THEN
105: IF x_on_operation_action = 1 THEN
106: -- set OUT result to NOT CONSTRAINED
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;

Line 128: l_result := OE_PC_GLOBALS.NO;

124: END IF;
125: */
126: /* End AuditTrail */
127: IF x_on_operation_action > 0 THEN
128: l_result := OE_PC_GLOBALS.NO;
129: END IF;
130: RETURN l_result;
131:
132: END Is_Op_Constrained;

Line 139: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

135: -- PUBLIC PROCEDURES
136:
137:
138: FUNCTION ACCOUNTING_RULE
139: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
140: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
141: , x_on_operation_action OUT NOCOPY NUMBER
142:
143: ) RETURN NUMBER

Line 160: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

156:
157: END ACCOUNTING_RULE;
158:
159: FUNCTION CONVERSION_TYPE
160: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
161: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
162: , x_on_operation_action OUT NOCOPY NUMBER
163:
164: ) RETURN NUMBER

Line 182: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

178: END CONVERSION_TYPE;
179:
180:
181: FUNCTION CUST_PO_NUMBER
182: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
183: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
184: , x_on_operation_action OUT NOCOPY NUMBER
185:
186: ) RETURN NUMBER

Line 204: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

200: END CUST_PO_NUMBER;
201:
202:
203: FUNCTION DELIVER_TO_ORG
204: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
205: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
206: , x_on_operation_action OUT NOCOPY NUMBER
207:
208: ) RETURN NUMBER

Line 226: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

222: END DELIVER_TO_ORG;
223:
224:
225: FUNCTION FREIGHT_TERMS
226: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
227: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
228: , x_on_operation_action OUT NOCOPY NUMBER
229:
230: ) RETURN NUMBER

Line 248: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

244: END FREIGHT_TERMS;
245:
246:
247: FUNCTION INVOICE_TO_ORG
248: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
249: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
250: , x_on_operation_action OUT NOCOPY NUMBER
251:
252: ) RETURN NUMBER

Line 269: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

265:
266: END INVOICE_TO_ORG;
267:
268: FUNCTION INVOICING_RULE
269: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
270: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
271: , x_on_operation_action OUT NOCOPY NUMBER
272:
273: ) RETURN NUMBER

Line 290: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

286:
287: END INVOICING_RULE;
288:
289: FUNCTION ORDER_NUMBER
290: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
291: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
292: , x_on_operation_action OUT NOCOPY NUMBER
293:
294: ) RETURN NUMBER

Line 311: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

307:
308: END ORDER_NUMBER;
309:
310: FUNCTION ORDER_TYPE
311: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
312: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
313: , x_on_operation_action OUT NOCOPY NUMBER
314:
315: ) RETURN NUMBER

Line 333: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

329: END ORDER_TYPE;
330:
331:
332: FUNCTION PACKING_INSTRUCTIONS
333: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
334: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
335: , x_on_operation_action OUT NOCOPY NUMBER
336:
337: ) RETURN NUMBER

Line 355: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

351: END PACKING_INSTRUCTIONS;
352:
353:
354: FUNCTION PAYMENT_TERM
355: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
356: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
357: , x_on_operation_action OUT NOCOPY NUMBER
358:
359: ) RETURN NUMBER

Line 377: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

373: END PAYMENT_TERM;
374:
375:
376: FUNCTION PRICE_LIST
377: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
378: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
379: , x_on_operation_action OUT NOCOPY NUMBER
380:
381: ) RETURN NUMBER

Line 399: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

395: END PRICE_LIST;
396:
397:
398: FUNCTION SALESREP
399: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
400: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
401: , x_on_operation_action OUT NOCOPY NUMBER
402:
403: ) RETURN NUMBER

Line 421: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

417: END SALESREP;
418:
419:
420: FUNCTION SHIPPING_INSTRUCTIONS
421: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
422: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
423: , x_on_operation_action OUT NOCOPY NUMBER
424:
425: ) RETURN NUMBER

Line 442: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

438:
439: END SHIPPING_INSTRUCTIONS;
440:
441: FUNCTION SHIPPING_METHOD
442: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
443: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
444: , x_on_operation_action OUT NOCOPY NUMBER
445:
446: ) RETURN NUMBER

Line 464: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

460: END SHIPPING_METHOD;
461:
462:
463: FUNCTION SHIP_FROM_ORG
464: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
465: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
466: , x_on_operation_action OUT NOCOPY NUMBER
467:
468: ) RETURN NUMBER

Line 486: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

482: END SHIP_FROM_ORG;
483:
484:
485: FUNCTION SHIP_TO_ORG
486: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
487: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
488: , x_on_operation_action OUT NOCOPY NUMBER
489:
490: ) RETURN NUMBER

Line 508: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

504: END SHIP_TO_ORG;
505:
506:
507: FUNCTION SOLD_TO_CONTACT
508: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
509: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
510: , x_on_operation_action OUT NOCOPY NUMBER
511:
512: ) RETURN NUMBER

Line 530: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

526: END SOLD_TO_CONTACT;
527:
528:
529: FUNCTION SOLD_TO_ORG
530: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
531: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
532: , x_on_operation_action OUT NOCOPY NUMBER
533:
534: ) RETURN NUMBER

Line 552: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 573: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

569:
570: END TRANSACTIONAL_CURR;
571:
572: FUNCTION ENFORCE_ACCOUNTING_RULE_FLAG
573: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
574: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
575: , x_on_operation_action OUT NOCOPY NUMBER
576: ) RETURN NUMBER
577: IS

Line 593: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

589:
590: END ENFORCE_ACCOUNTING_RULE_FLAG;
591:
592: FUNCTION ENFORCE_INVOICE_TO_FLAG
593: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
594: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
595: , x_on_operation_action OUT NOCOPY NUMBER
596: ) RETURN NUMBER
597: IS

Line 613: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

609:
610: END ENFORCE_INVOICE_TO_FLAG;
611:
612: FUNCTION ENFORCE_PRICE_LIST_FLAG
613: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
614: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
615: , x_on_operation_action OUT NOCOPY NUMBER
616: ) RETURN NUMBER
617: IS

Line 633: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

629:
630: END ENFORCE_PRICE_LIST_FLAG;
631:
632: FUNCTION ENFORCE_PAYMENT_TERM_FLAG
633: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
634: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
635: , x_on_operation_action OUT NOCOPY NUMBER
636: ) RETURN NUMBER
637: IS

Line 653: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

649:
650: END ENFORCE_PAYMENT_TERM_FLAG;
651:
652: FUNCTION ENFORCE_INVOICING_RULE_FLAG
653: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
654: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
655: , x_on_operation_action OUT NOCOPY NUMBER
656: ) RETURN NUMBER
657: IS

Line 673: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

669:
670: END ENFORCE_INVOICING_RULE_FLAG;
671:
672: FUNCTION ENFORCE_SHIP_TO_FLAG
673: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
674: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
675: , x_on_operation_action OUT NOCOPY NUMBER
676: ) RETURN NUMBER
677: IS

Line 693: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

689:
690: END ENFORCE_SHIP_TO_FLAG;
691:
692: FUNCTION ENFORCE_FREIGHT_TERM_FLAG
693: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
694: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
695: , x_on_operation_action OUT NOCOPY NUMBER
696: ) RETURN NUMBER
697: IS

Line 713: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

709:
710: END ENFORCE_FREIGHT_TERM_FLAG;
711:
712: FUNCTION ENFORCE_SHIPPING_METHOD_FLAG
713: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
714: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
715: , x_on_operation_action OUT NOCOPY NUMBER
716: ) RETURN NUMBER
717: IS

Line 733: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

729:
730: END ENFORCE_SHIPPING_METHOD_FLAG;
731:
732: FUNCTION START_DATE_ACTIVE
733: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
734: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
735: , x_on_operation_action OUT NOCOPY NUMBER
736: ) RETURN NUMBER
737: IS

Line 753: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

749:
750: END START_DATE_ACTIVE;
751:
752: FUNCTION END_DATE_ACTIVE
753: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
754: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
755: , x_on_operation_action OUT NOCOPY NUMBER
756: ) RETURN NUMBER
757: IS

Line 773: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

769:
770: END END_DATE_ACTIVE;
771:
772: FUNCTION BLANKET_MIN_AMOUNT
773: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
774: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
775: , x_on_operation_action OUT NOCOPY NUMBER
776: ) RETURN NUMBER
777: IS

Line 793: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

789:
790: END BLANKET_MIN_AMOUNT;
791:
792: FUNCTION BLANKET_MAX_AMOUNT
793: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
794: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
795: , x_on_operation_action OUT NOCOPY NUMBER
796: ) RETURN NUMBER
797: IS

Line 813: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

809:
810: END BLANKET_MAX_AMOUNT;
811:
812: FUNCTION VERSION_NUMBER
813: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
814: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
815: , x_on_operation_action OUT NOCOPY NUMBER
816: ) RETURN NUMBER
817: IS

Line 833: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

829:
830: END VERSION_NUMBER;
831:
832: FUNCTION REVISION_CHANGE_REASON
833: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
834: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
835: , x_on_operation_action OUT NOCOPY NUMBER
836: ) RETURN NUMBER
837: IS

Line 853: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

849:
850: END REVISION_CHANGE_REASON;
851:
852: FUNCTION REVISION_CHANGE_DATE
853: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
854: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
855: , x_on_operation_action OUT NOCOPY NUMBER
856: ) RETURN NUMBER
857: IS

Line 873: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

869:
870: END REVISION_CHANGE_DATE;
871:
872: FUNCTION REVISION_CHANGE_COMMENTS
873: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
874: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
875: , x_on_operation_action OUT NOCOPY NUMBER
876: ) RETURN NUMBER
877: IS

Line 893: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

889:
890: END REVISION_CHANGE_COMMENTS;
891:
892: FUNCTION OVERRIDE_AMOUNT_FLAG
893: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
894: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
895: , x_on_operation_action OUT NOCOPY NUMBER
896: ) RETURN NUMBER
897: IS

Line 913: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

909:
910: END OVERRIDE_AMOUNT_FLAG;
911:
912: FUNCTION TRANSACTION_PHASE
913: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
914: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
915: , x_on_operation_action OUT NOCOPY NUMBER
916: ) RETURN NUMBER
917: IS

Line 933: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

929:
930: END TRANSACTION_PHASE;
931:
932: FUNCTION SOLD_TO_SITE_USE
933: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
934: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
935: , x_on_operation_action OUT NOCOPY NUMBER
936: ) RETURN NUMBER
937: IS

Line 953: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

949:
950: END SOLD_TO_SITE_USE;
951:
952: FUNCTION SALES_DOCUMENT_NAME
953: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
954: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
955: , x_on_operation_action OUT NOCOPY NUMBER
956: ) RETURN NUMBER
957: IS

Line 973: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

969:
970: END SALES_DOCUMENT_NAME;
971:
972: FUNCTION CUSTOMER_SIGNATURE
973: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
974: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
975: , x_on_operation_action OUT NOCOPY NUMBER
976: ) RETURN NUMBER
977: IS

Line 993: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

989:
990: END CUSTOMER_SIGNATURE;
991:
992: FUNCTION CUSTOMER_SIGNATURE_DATE
993: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
994: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
995: , x_on_operation_action OUT NOCOPY NUMBER
996: ) RETURN NUMBER
997: IS

Line 1013: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1009:
1010: END CUSTOMER_SIGNATURE_DATE;
1011:
1012: FUNCTION SUPPLIER_SIGNATURE
1013: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1014: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1015: , x_on_operation_action OUT NOCOPY NUMBER
1016: ) RETURN NUMBER
1017: IS

Line 1033: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1029:
1030: END SUPPLIER_SIGNATURE;
1031:
1032: FUNCTION SUPPLIER_SIGNATURE_DATE
1033: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1034: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1035: , x_on_operation_action OUT NOCOPY NUMBER
1036: ) RETURN NUMBER
1037: IS

Line 1053: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1049:
1050: END SUPPLIER_SIGNATURE_DATE;
1051:
1052: FUNCTION USER_STATUS
1053: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1054: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1055: , x_on_operation_action OUT NOCOPY NUMBER
1056: ) RETURN NUMBER
1057: IS

Line 1073: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1069:
1070: END USER_STATUS;
1071:
1072: FUNCTION NEW_PRICE_LIST
1073: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1074: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1075: , x_on_operation_action OUT NOCOPY NUMBER
1076: ) RETURN NUMBER
1077: IS

Line 1093: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1089:
1090: END NEW_PRICE_LIST;
1091:
1092: FUNCTION NEW_MODIFIER_LIST
1093: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1094: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1095: , x_on_operation_action OUT NOCOPY NUMBER
1096: ) RETURN NUMBER
1097: IS

Line 1113: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1109:
1110: END NEW_MODIFIER_LIST;
1111:
1112: FUNCTION DEFAULT_DISCOUNT_PERCENT
1113: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1114: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1115: , x_on_operation_action OUT NOCOPY NUMBER
1116: ) RETURN NUMBER
1117: IS

Line 1133: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1154: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1150: END DEFAULT_DISCOUNT_AMOUNT;
1151:
1152: --bug6531947
1153: FUNCTION CONTEXT
1154: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1155: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1156: , x_on_operation_action OUT NOCOPY NUMBER
1157: ) RETURN NUMBER
1158: IS

Line 1174: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1170:
1171: END CONTEXT;
1172:
1173: FUNCTION ATTRIBUTE1
1174: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1175: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1176: , x_on_operation_action OUT NOCOPY NUMBER
1177: ) RETURN NUMBER
1178: IS

Line 1194: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1190:
1191: END ATTRIBUTE1;
1192:
1193: FUNCTION ATTRIBUTE2
1194: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1195: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1196: , x_on_operation_action OUT NOCOPY NUMBER
1197: ) RETURN NUMBER
1198: IS

Line 1214: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1210:
1211: END ATTRIBUTE2;
1212:
1213: FUNCTION ATTRIBUTE3
1214: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1215: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1216: , x_on_operation_action OUT NOCOPY NUMBER
1217: ) RETURN NUMBER
1218: IS

Line 1234: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1230:
1231: END ATTRIBUTE3;
1232:
1233: FUNCTION ATTRIBUTE4
1234: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1235: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1236: , x_on_operation_action OUT NOCOPY NUMBER
1237: ) RETURN NUMBER
1238: IS

Line 1254: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1250:
1251: END ATTRIBUTE4;
1252:
1253: FUNCTION ATTRIBUTE5
1254: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1255: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1256: , x_on_operation_action OUT NOCOPY NUMBER
1257: ) RETURN NUMBER
1258: IS

Line 1274: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1270:
1271: END ATTRIBUTE5;
1272:
1273: FUNCTION ATTRIBUTE6
1274: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1275: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1276: , x_on_operation_action OUT NOCOPY NUMBER
1277: ) RETURN NUMBER
1278: IS

Line 1294: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1290:
1291: END ATTRIBUTE6;
1292:
1293: FUNCTION ATTRIBUTE7
1294: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1295: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1296: , x_on_operation_action OUT NOCOPY NUMBER
1297: ) RETURN NUMBER
1298: IS

Line 1314: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1310:
1311: END ATTRIBUTE7;
1312:
1313: FUNCTION ATTRIBUTE8
1314: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1315: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1316: , x_on_operation_action OUT NOCOPY NUMBER
1317: ) RETURN NUMBER
1318: IS

Line 1334: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1330:
1331: END ATTRIBUTE8;
1332:
1333: FUNCTION ATTRIBUTE9
1334: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1335: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1336: , x_on_operation_action OUT NOCOPY NUMBER
1337: ) RETURN NUMBER
1338: IS

Line 1354: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1350:
1351: END ATTRIBUTE9;
1352:
1353: FUNCTION ATTRIBUTE10
1354: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1355: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1356: , x_on_operation_action OUT NOCOPY NUMBER
1357: ) RETURN NUMBER
1358: IS

Line 1374: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1370:
1371: END ATTRIBUTE10;
1372:
1373: FUNCTION ATTRIBUTE11
1374: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1375: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1376: , x_on_operation_action OUT NOCOPY NUMBER
1377: ) RETURN NUMBER
1378: IS

Line 1394: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1390:
1391: END ATTRIBUTE11;
1392:
1393: FUNCTION ATTRIBUTE12
1394: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1395: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1396: , x_on_operation_action OUT NOCOPY NUMBER
1397: ) RETURN NUMBER
1398: IS

Line 1414: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1410:
1411: END ATTRIBUTE12;
1412:
1413: FUNCTION ATTRIBUTE13
1414: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1415: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1416: , x_on_operation_action OUT NOCOPY NUMBER
1417: ) RETURN NUMBER
1418: IS

Line 1434: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1454: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1450:
1451: END ATTRIBUTE14;
1452:
1453: FUNCTION ATTRIBUTE15
1454: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1455: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1456: , x_on_operation_action OUT NOCOPY NUMBER
1457: ) RETURN NUMBER
1458: IS

Line 1474: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1470:
1471: END ATTRIBUTE15;
1472:
1473: FUNCTION ATTRIBUTE16
1474: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1475: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1476: , x_on_operation_action OUT NOCOPY NUMBER
1477: ) RETURN NUMBER
1478: IS

Line 1494: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1490:
1491: END ATTRIBUTE16;
1492:
1493: FUNCTION ATTRIBUTE17
1494: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1495: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1496: , x_on_operation_action OUT NOCOPY NUMBER
1497: ) RETURN NUMBER
1498: IS

Line 1514: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1510:
1511: END ATTRIBUTE17;
1512:
1513: FUNCTION ATTRIBUTE18
1514: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1515: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1516: , x_on_operation_action OUT NOCOPY NUMBER
1517: ) RETURN NUMBER
1518: IS

Line 1534: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1530:
1531: END ATTRIBUTE18;
1532:
1533: FUNCTION ATTRIBUTE19
1534: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1535: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1536: , x_on_operation_action OUT NOCOPY NUMBER
1537: ) RETURN NUMBER
1538: IS

Line 1554: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1550:
1551: END ATTRIBUTE19;
1552:
1553: FUNCTION ATTRIBUTE20
1554: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1555: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
1556: , x_on_operation_action OUT NOCOPY NUMBER
1557: ) RETURN NUMBER
1558: IS

Line 1595: l_operation := OE_PC_GLOBALS.CREATE_OP;

1591: -- Initializing return status to SUCCESS
1592: x_return_status := FND_API.G_RET_STS_SUCCESS;
1593:
1594: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1595: l_operation := OE_PC_GLOBALS.CREATE_OP;
1596: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1597: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1598: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1599: l_operation := OE_PC_GLOBALS.DELETE_OP;

Line 1597: l_operation := OE_PC_GLOBALS.UPDATE_OP;

1593:
1594: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1595: l_operation := OE_PC_GLOBALS.CREATE_OP;
1596: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1597: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1598: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1599: l_operation := OE_PC_GLOBALS.DELETE_OP;
1600: ELSE
1601: IF l_debug_level > 0 THEN

Line 1599: l_operation := OE_PC_GLOBALS.DELETE_OP;

1595: l_operation := OE_PC_GLOBALS.CREATE_OP;
1596: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1597: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1598: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1599: l_operation := OE_PC_GLOBALS.DELETE_OP;
1600: ELSE
1601: IF l_debug_level > 0 THEN
1602: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1603: END IF;

Line 1667: x_result := OE_PC_GLOBALS.NO;

1663: -- Initializing return status to SUCCESS
1664: x_return_status := FND_API.G_RET_STS_SUCCESS;
1665:
1666: -- Initializing out result to NOT CONSTRAINED
1667: x_result := OE_PC_GLOBALS.NO;
1668:
1669: -- Get the operation code to be passed to the security framework API
1670: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1671: -- Bug 1987983 : if the order source is Copy then skip the Attribute

Line 1677: l_operation := OE_PC_GLOBALS.CREATE_OP;

1673: -- IF p_HEADER_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
1674: -- THEN
1675: -- RETURN;
1676: -- ELSE
1677: l_operation := OE_PC_GLOBALS.CREATE_OP;
1678: -- END IF;
1679: -- Bug 1755817: if there are no attribute-specific insert
1680: -- constraints, then no need to go further. Entity level
1681: -- security check for CREATE will be called again from

Line 1684: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_BLANKET_HEADER

1680: -- constraints, then no need to go further. Entity level
1681: -- security check for CREATE will be called again from
1682: -- process order after defaulting.
1683: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
1684: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_BLANKET_HEADER
1685: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
1686: ,p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
1687: )
1688: THEN

Line 1693: l_operation := OE_PC_GLOBALS.UPDATE_OP;

1689: RETURN;
1690: END IF;
1691:
1692: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1693: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1694: ELSE
1695: IF l_debug_level > 0 THEN
1696: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1697: END IF;

Line 1719: IF l_result = OE_PC_GLOBALS.YES THEN

1715: (p_operation => l_operation
1716: ,p_record => l_rowtype_rec
1717: ,x_on_operation_action => l_on_operation_action
1718: );
1719: IF l_result = OE_PC_GLOBALS.YES THEN
1720: -- set OUT result to CONSTRAINED
1721: x_result := OE_PC_GLOBALS.YES;
1722: --RAISE;
1723: END IF;

Line 1721: x_result := OE_PC_GLOBALS.YES;

1717: ,x_on_operation_action => l_on_operation_action
1718: );
1719: IF l_result = OE_PC_GLOBALS.YES THEN
1720: -- set OUT result to CONSTRAINED
1721: x_result := OE_PC_GLOBALS.YES;
1722: --RAISE;
1723: END IF;
1724: END IF;
1725:

Line 1762: IF l_result = OE_PC_GLOBALS.YES THEN

1758: ,p_record => l_rowtype_rec
1759: ,x_on_operation_action => l_on_operation_action
1760: );
1761:
1762: IF l_result = OE_PC_GLOBALS.YES THEN
1763: -- set OUT result to CONSTRAINED
1764: x_result := OE_PC_GLOBALS.YES;
1765: END IF;
1766:

Line 1764: x_result := OE_PC_GLOBALS.YES;

1760: );
1761:
1762: IF l_result = OE_PC_GLOBALS.YES THEN
1763: -- set OUT result to CONSTRAINED
1764: x_result := OE_PC_GLOBALS.YES;
1765: END IF;
1766:
1767: END IF;
1768:

Line 1778: IF l_result = OE_PC_GLOBALS.YES THEN

1774: ,p_record => l_rowtype_rec
1775: ,x_on_operation_action => l_on_operation_action
1776: );
1777:
1778: IF l_result = OE_PC_GLOBALS.YES THEN
1779: -- set OUT result to CONSTRAINED
1780: x_result := OE_PC_GLOBALS.YES;
1781: END IF;
1782:

Line 1780: x_result := OE_PC_GLOBALS.YES;

1776: );
1777:
1778: IF l_result = OE_PC_GLOBALS.YES THEN
1779: -- set OUT result to CONSTRAINED
1780: x_result := OE_PC_GLOBALS.YES;
1781: END IF;
1782:
1783: END IF;
1784:

Line 1794: IF l_result = OE_PC_GLOBALS.YES THEN

1790: ,p_record => l_rowtype_rec
1791: ,x_on_operation_action => l_on_operation_action
1792: );
1793:
1794: IF l_result = OE_PC_GLOBALS.YES THEN
1795: -- set OUT result to CONSTRAINED
1796: x_result := OE_PC_GLOBALS.YES;
1797: END IF;
1798:

Line 1796: x_result := OE_PC_GLOBALS.YES;

1792: );
1793:
1794: IF l_result = OE_PC_GLOBALS.YES THEN
1795: -- set OUT result to CONSTRAINED
1796: x_result := OE_PC_GLOBALS.YES;
1797: END IF;
1798:
1799: END IF;
1800:

Line 1810: IF l_result = OE_PC_GLOBALS.YES THEN

1806: ,p_record => l_rowtype_rec
1807: ,x_on_operation_action => l_on_operation_action
1808: );
1809:
1810: IF l_result = OE_PC_GLOBALS.YES THEN
1811: -- set OUT result to CONSTRAINED
1812: x_result := OE_PC_GLOBALS.YES;
1813: END IF;
1814:

Line 1812: x_result := OE_PC_GLOBALS.YES;

1808: );
1809:
1810: IF l_result = OE_PC_GLOBALS.YES THEN
1811: -- set OUT result to CONSTRAINED
1812: x_result := OE_PC_GLOBALS.YES;
1813: END IF;
1814:
1815: END IF;
1816:

Line 1826: IF l_result = OE_PC_GLOBALS.YES THEN

1822: ,p_record => l_rowtype_rec
1823: ,x_on_operation_action => l_on_operation_action
1824: );
1825:
1826: IF l_result = OE_PC_GLOBALS.YES THEN
1827: -- set OUT result to CONSTRAINED
1828: x_result := OE_PC_GLOBALS.YES;
1829: END IF;
1830:

Line 1828: x_result := OE_PC_GLOBALS.YES;

1824: );
1825:
1826: IF l_result = OE_PC_GLOBALS.YES THEN
1827: -- set OUT result to CONSTRAINED
1828: x_result := OE_PC_GLOBALS.YES;
1829: END IF;
1830:
1831: END IF;
1832:

Line 1842: IF l_result = OE_PC_GLOBALS.YES THEN

1838: ,p_record => l_rowtype_rec
1839: ,x_on_operation_action => l_on_operation_action
1840: );
1841:
1842: IF l_result = OE_PC_GLOBALS.YES THEN
1843: -- set OUT result to CONSTRAINED
1844: x_result := OE_PC_GLOBALS.YES;
1845: END IF;
1846:

Line 1844: x_result := OE_PC_GLOBALS.YES;

1840: );
1841:
1842: IF l_result = OE_PC_GLOBALS.YES THEN
1843: -- set OUT result to CONSTRAINED
1844: x_result := OE_PC_GLOBALS.YES;
1845: END IF;
1846:
1847: END IF;
1848:

Line 1858: IF l_result = OE_PC_GLOBALS.YES THEN

1854: ,p_record => l_rowtype_rec
1855: ,x_on_operation_action => l_on_operation_action
1856: );
1857:
1858: IF l_result = OE_PC_GLOBALS.YES THEN
1859: -- set OUT result to CONSTRAINED
1860: x_result := OE_PC_GLOBALS.YES;
1861: END IF;
1862:

Line 1860: x_result := OE_PC_GLOBALS.YES;

1856: );
1857:
1858: IF l_result = OE_PC_GLOBALS.YES THEN
1859: -- set OUT result to CONSTRAINED
1860: x_result := OE_PC_GLOBALS.YES;
1861: END IF;
1862:
1863: END IF;
1864:

Line 1874: IF l_result = OE_PC_GLOBALS.YES THEN

1870: ,p_record => l_rowtype_rec
1871: ,x_on_operation_action => l_on_operation_action
1872: );
1873:
1874: IF l_result = OE_PC_GLOBALS.YES THEN
1875: -- set OUT result to CONSTRAINED
1876: x_result := OE_PC_GLOBALS.YES;
1877: END IF;
1878:

Line 1876: x_result := OE_PC_GLOBALS.YES;

1872: );
1873:
1874: IF l_result = OE_PC_GLOBALS.YES THEN
1875: -- set OUT result to CONSTRAINED
1876: x_result := OE_PC_GLOBALS.YES;
1877: END IF;
1878:
1879: END IF;
1880:

Line 1890: IF l_result = OE_PC_GLOBALS.YES THEN

1886: ,p_record => l_rowtype_rec
1887: ,x_on_operation_action => l_on_operation_action
1888: );
1889:
1890: IF l_result = OE_PC_GLOBALS.YES THEN
1891: -- set OUT result to CONSTRAINED
1892: x_result := OE_PC_GLOBALS.YES;
1893: END IF;
1894:

Line 1892: x_result := OE_PC_GLOBALS.YES;

1888: );
1889:
1890: IF l_result = OE_PC_GLOBALS.YES THEN
1891: -- set OUT result to CONSTRAINED
1892: x_result := OE_PC_GLOBALS.YES;
1893: END IF;
1894:
1895: END IF;
1896:

Line 1906: IF l_result = OE_PC_GLOBALS.YES THEN

1902: ,p_record => l_rowtype_rec
1903: ,x_on_operation_action => l_on_operation_action
1904: );
1905:
1906: IF l_result = OE_PC_GLOBALS.YES THEN
1907: -- set OUT result to CONSTRAINED
1908: x_result := OE_PC_GLOBALS.YES;
1909: END IF;
1910:

Line 1908: x_result := OE_PC_GLOBALS.YES;

1904: );
1905:
1906: IF l_result = OE_PC_GLOBALS.YES THEN
1907: -- set OUT result to CONSTRAINED
1908: x_result := OE_PC_GLOBALS.YES;
1909: END IF;
1910:
1911: END IF;
1912:

Line 1922: IF l_result = OE_PC_GLOBALS.YES THEN

1918: ,p_record => l_rowtype_rec
1919: ,x_on_operation_action => l_on_operation_action
1920: );
1921:
1922: IF l_result = OE_PC_GLOBALS.YES THEN
1923: -- set OUT result to CONSTRAINED
1924: x_result := OE_PC_GLOBALS.YES;
1925: END IF;
1926:

Line 1924: x_result := OE_PC_GLOBALS.YES;

1920: );
1921:
1922: IF l_result = OE_PC_GLOBALS.YES THEN
1923: -- set OUT result to CONSTRAINED
1924: x_result := OE_PC_GLOBALS.YES;
1925: END IF;
1926:
1927: END IF;
1928:

Line 1941: IF l_result = OE_PC_GLOBALS.YES THEN

1937: IF l_debug_level > 0 THEN
1938: oe_debug_pub.add( 'exiting price list check:' || l_result, 2 ) ;
1939: END IF;
1940:
1941: IF l_result = OE_PC_GLOBALS.YES THEN
1942: -- set OUT result to CONSTRAINED
1943: x_result := OE_PC_GLOBALS.YES;
1944: END IF;
1945:

Line 1943: x_result := OE_PC_GLOBALS.YES;

1939: END IF;
1940:
1941: IF l_result = OE_PC_GLOBALS.YES THEN
1942: -- set OUT result to CONSTRAINED
1943: x_result := OE_PC_GLOBALS.YES;
1944: END IF;
1945:
1946: END IF;
1947:

Line 1957: IF l_result = OE_PC_GLOBALS.YES THEN

1953: ,p_record => l_rowtype_rec
1954: ,x_on_operation_action => l_on_operation_action
1955: );
1956:
1957: IF l_result = OE_PC_GLOBALS.YES THEN
1958: -- set OUT result to CONSTRAINED
1959: x_result := OE_PC_GLOBALS.YES;
1960: END IF;
1961:

Line 1959: x_result := OE_PC_GLOBALS.YES;

1955: );
1956:
1957: IF l_result = OE_PC_GLOBALS.YES THEN
1958: -- set OUT result to CONSTRAINED
1959: x_result := OE_PC_GLOBALS.YES;
1960: END IF;
1961:
1962: END IF;
1963:

Line 1973: IF l_result = OE_PC_GLOBALS.YES THEN

1969: ,p_record => l_rowtype_rec
1970: ,x_on_operation_action => l_on_operation_action
1971: );
1972:
1973: IF l_result = OE_PC_GLOBALS.YES THEN
1974: -- set OUT result to CONSTRAINED
1975: x_result := OE_PC_GLOBALS.YES;
1976: END IF;
1977:

Line 1975: x_result := OE_PC_GLOBALS.YES;

1971: );
1972:
1973: IF l_result = OE_PC_GLOBALS.YES THEN
1974: -- set OUT result to CONSTRAINED
1975: x_result := OE_PC_GLOBALS.YES;
1976: END IF;
1977:
1978: END IF;
1979:

Line 1989: IF l_result = OE_PC_GLOBALS.YES THEN

1985: ,p_record => l_rowtype_rec
1986: ,x_on_operation_action => l_on_operation_action
1987: );
1988:
1989: IF l_result = OE_PC_GLOBALS.YES THEN
1990: -- set OUT result to CONSTRAINED
1991: x_result := OE_PC_GLOBALS.YES;
1992: END IF;
1993:

Line 1991: x_result := OE_PC_GLOBALS.YES;

1987: );
1988:
1989: IF l_result = OE_PC_GLOBALS.YES THEN
1990: -- set OUT result to CONSTRAINED
1991: x_result := OE_PC_GLOBALS.YES;
1992: END IF;
1993:
1994: END IF;
1995:

Line 2005: IF l_result = OE_PC_GLOBALS.YES THEN

2001: ,p_record => l_rowtype_rec
2002: ,x_on_operation_action => l_on_operation_action
2003: );
2004:
2005: IF l_result = OE_PC_GLOBALS.YES THEN
2006: -- set OUT result to CONSTRAINED
2007: x_result := OE_PC_GLOBALS.YES;
2008: END IF;
2009:

Line 2007: x_result := OE_PC_GLOBALS.YES;

2003: );
2004:
2005: IF l_result = OE_PC_GLOBALS.YES THEN
2006: -- set OUT result to CONSTRAINED
2007: x_result := OE_PC_GLOBALS.YES;
2008: END IF;
2009:
2010: END IF;
2011:

Line 2021: IF l_result = OE_PC_GLOBALS.YES THEN

2017: ,p_record => l_rowtype_rec
2018: ,x_on_operation_action => l_on_operation_action
2019: );
2020:
2021: IF l_result = OE_PC_GLOBALS.YES THEN
2022: -- set OUT result to CONSTRAINED
2023: x_result := OE_PC_GLOBALS.YES;
2024: END IF;
2025:

Line 2023: x_result := OE_PC_GLOBALS.YES;

2019: );
2020:
2021: IF l_result = OE_PC_GLOBALS.YES THEN
2022: -- set OUT result to CONSTRAINED
2023: x_result := OE_PC_GLOBALS.YES;
2024: END IF;
2025:
2026: END IF;
2027:

Line 2037: IF l_result = OE_PC_GLOBALS.YES THEN

2033: ,p_record => l_rowtype_rec
2034: ,x_on_operation_action => l_on_operation_action
2035: );
2036:
2037: IF l_result = OE_PC_GLOBALS.YES THEN
2038: -- set OUT result to CONSTRAINED
2039: x_result := OE_PC_GLOBALS.YES;
2040: END IF;
2041:

Line 2039: x_result := OE_PC_GLOBALS.YES;

2035: );
2036:
2037: IF l_result = OE_PC_GLOBALS.YES THEN
2038: -- set OUT result to CONSTRAINED
2039: x_result := OE_PC_GLOBALS.YES;
2040: END IF;
2041:
2042: END IF;
2043:

Line 2053: IF l_result = OE_PC_GLOBALS.YES THEN

2049: ,p_record => l_rowtype_rec
2050: ,x_on_operation_action => l_on_operation_action
2051: );
2052:
2053: IF l_result = OE_PC_GLOBALS.YES THEN
2054: -- set OUT result to CONSTRAINED
2055: x_result := OE_PC_GLOBALS.YES;
2056: END IF;
2057:

Line 2055: x_result := OE_PC_GLOBALS.YES;

2051: );
2052:
2053: IF l_result = OE_PC_GLOBALS.YES THEN
2054: -- set OUT result to CONSTRAINED
2055: x_result := OE_PC_GLOBALS.YES;
2056: END IF;
2057:
2058: END IF;
2059:

Line 2069: IF l_result = OE_PC_GLOBALS.YES THEN

2065: ,p_record => l_rowtype_rec
2066: ,x_on_operation_action => l_on_operation_action
2067: );
2068:
2069: IF l_result = OE_PC_GLOBALS.YES THEN
2070: -- set OUT result to CONSTRAINED
2071: x_result := OE_PC_GLOBALS.YES;
2072: END IF;
2073:

Line 2071: x_result := OE_PC_GLOBALS.YES;

2067: );
2068:
2069: IF l_result = OE_PC_GLOBALS.YES THEN
2070: -- set OUT result to CONSTRAINED
2071: x_result := OE_PC_GLOBALS.YES;
2072: END IF;
2073:
2074: END IF;
2075:

Line 2085: IF l_result = OE_PC_GLOBALS.YES THEN

2081: ,p_record => l_rowtype_rec
2082: ,x_on_operation_action => l_on_operation_action
2083: );
2084:
2085: IF l_result = OE_PC_GLOBALS.YES THEN
2086: -- set OUT result to CONSTRAINED
2087: x_result := OE_PC_GLOBALS.YES;
2088: END IF;
2089:

Line 2087: x_result := OE_PC_GLOBALS.YES;

2083: );
2084:
2085: IF l_result = OE_PC_GLOBALS.YES THEN
2086: -- set OUT result to CONSTRAINED
2087: x_result := OE_PC_GLOBALS.YES;
2088: END IF;
2089:
2090: END IF;
2091:

Line 2101: IF l_result = OE_PC_GLOBALS.YES THEN

2097: ,p_record => l_rowtype_rec
2098: ,x_on_operation_action => l_on_operation_action
2099: );
2100:
2101: IF l_result = OE_PC_GLOBALS.YES THEN
2102: -- set OUT result to CONSTRAINED
2103: x_result := OE_PC_GLOBALS.YES;
2104: END IF;
2105:

Line 2103: x_result := OE_PC_GLOBALS.YES;

2099: );
2100:
2101: IF l_result = OE_PC_GLOBALS.YES THEN
2102: -- set OUT result to CONSTRAINED
2103: x_result := OE_PC_GLOBALS.YES;
2104: END IF;
2105:
2106: END IF;
2107:

Line 2117: IF l_result = OE_PC_GLOBALS.YES THEN

2113: ,p_record => l_rowtype_rec
2114: ,x_on_operation_action => l_on_operation_action
2115: );
2116:
2117: IF l_result = OE_PC_GLOBALS.YES THEN
2118: -- set OUT result to CONSTRAINED
2119: x_result := OE_PC_GLOBALS.YES;
2120: END IF;
2121:

Line 2119: x_result := OE_PC_GLOBALS.YES;

2115: );
2116:
2117: IF l_result = OE_PC_GLOBALS.YES THEN
2118: -- set OUT result to CONSTRAINED
2119: x_result := OE_PC_GLOBALS.YES;
2120: END IF;
2121:
2122: END IF;
2123:

Line 2133: IF l_result = OE_PC_GLOBALS.YES THEN

2129: ,p_record => l_rowtype_rec
2130: ,x_on_operation_action => l_on_operation_action
2131: );
2132:
2133: IF l_result = OE_PC_GLOBALS.YES THEN
2134: -- set OUT result to CONSTRAINED
2135: x_result := OE_PC_GLOBALS.YES;
2136: END IF;
2137:

Line 2135: x_result := OE_PC_GLOBALS.YES;

2131: );
2132:
2133: IF l_result = OE_PC_GLOBALS.YES THEN
2134: -- set OUT result to CONSTRAINED
2135: x_result := OE_PC_GLOBALS.YES;
2136: END IF;
2137:
2138: END IF;
2139:

Line 2149: IF l_result = OE_PC_GLOBALS.YES THEN

2145: ,p_record => l_rowtype_rec
2146: ,x_on_operation_action => l_on_operation_action
2147: );
2148:
2149: IF l_result = OE_PC_GLOBALS.YES THEN
2150: -- set OUT result to CONSTRAINED
2151: x_result := OE_PC_GLOBALS.YES;
2152: END IF;
2153:

Line 2151: x_result := OE_PC_GLOBALS.YES;

2147: );
2148:
2149: IF l_result = OE_PC_GLOBALS.YES THEN
2150: -- set OUT result to CONSTRAINED
2151: x_result := OE_PC_GLOBALS.YES;
2152: END IF;
2153:
2154: END IF;
2155:

Line 2165: IF l_result = OE_PC_GLOBALS.YES THEN

2161: ,p_record => l_rowtype_rec
2162: ,x_on_operation_action => l_on_operation_action
2163: );
2164:
2165: IF l_result = OE_PC_GLOBALS.YES THEN
2166: -- set OUT result to CONSTRAINED
2167: x_result := OE_PC_GLOBALS.YES;
2168: END IF;
2169:

Line 2167: x_result := OE_PC_GLOBALS.YES;

2163: );
2164:
2165: IF l_result = OE_PC_GLOBALS.YES THEN
2166: -- set OUT result to CONSTRAINED
2167: x_result := OE_PC_GLOBALS.YES;
2168: END IF;
2169:
2170: END IF;
2171:

Line 2181: IF l_result = OE_PC_GLOBALS.YES THEN

2177: ,p_record => l_rowtype_rec
2178: ,x_on_operation_action => l_on_operation_action
2179: );
2180:
2181: IF l_result = OE_PC_GLOBALS.YES THEN
2182: -- set OUT result to CONSTRAINED
2183: x_result := OE_PC_GLOBALS.YES;
2184: END IF;
2185:

Line 2183: x_result := OE_PC_GLOBALS.YES;

2179: );
2180:
2181: IF l_result = OE_PC_GLOBALS.YES THEN
2182: -- set OUT result to CONSTRAINED
2183: x_result := OE_PC_GLOBALS.YES;
2184: END IF;
2185:
2186: END IF;
2187:

Line 2197: IF l_result = OE_PC_GLOBALS.YES THEN

2193: ,p_record => l_rowtype_rec
2194: ,x_on_operation_action => l_on_operation_action
2195: );
2196:
2197: IF l_result = OE_PC_GLOBALS.YES THEN
2198: -- set OUT result to CONSTRAINED
2199: x_result := OE_PC_GLOBALS.YES;
2200: END IF;
2201:

Line 2199: x_result := OE_PC_GLOBALS.YES;

2195: );
2196:
2197: IF l_result = OE_PC_GLOBALS.YES THEN
2198: -- set OUT result to CONSTRAINED
2199: x_result := OE_PC_GLOBALS.YES;
2200: END IF;
2201:
2202: END IF;
2203:

Line 2213: IF l_result = OE_PC_GLOBALS.YES THEN

2209: ,p_record => l_rowtype_rec
2210: ,x_on_operation_action => l_on_operation_action
2211: );
2212:
2213: IF l_result = OE_PC_GLOBALS.YES THEN
2214: -- set OUT result to CONSTRAINED
2215: x_result := OE_PC_GLOBALS.YES;
2216: END IF;
2217:

Line 2215: x_result := OE_PC_GLOBALS.YES;

2211: );
2212:
2213: IF l_result = OE_PC_GLOBALS.YES THEN
2214: -- set OUT result to CONSTRAINED
2215: x_result := OE_PC_GLOBALS.YES;
2216: END IF;
2217:
2218: END IF;
2219:

Line 2229: IF l_result = OE_PC_GLOBALS.YES THEN

2225: ,p_record => l_rowtype_rec
2226: ,x_on_operation_action => l_on_operation_action
2227: );
2228:
2229: IF l_result = OE_PC_GLOBALS.YES THEN
2230: -- set OUT result to CONSTRAINED
2231: x_result := OE_PC_GLOBALS.YES;
2232: END IF;
2233:

Line 2231: x_result := OE_PC_GLOBALS.YES;

2227: );
2228:
2229: IF l_result = OE_PC_GLOBALS.YES THEN
2230: -- set OUT result to CONSTRAINED
2231: x_result := OE_PC_GLOBALS.YES;
2232: END IF;
2233:
2234: END IF;
2235:

Line 2245: IF l_result = OE_PC_GLOBALS.YES THEN

2241: ,p_record => l_rowtype_rec
2242: ,x_on_operation_action => l_on_operation_action
2243: );
2244:
2245: IF l_result = OE_PC_GLOBALS.YES THEN
2246: -- set OUT result to CONSTRAINED
2247: x_result := OE_PC_GLOBALS.YES;
2248: END IF;
2249:

Line 2247: x_result := OE_PC_GLOBALS.YES;

2243: );
2244:
2245: IF l_result = OE_PC_GLOBALS.YES THEN
2246: -- set OUT result to CONSTRAINED
2247: x_result := OE_PC_GLOBALS.YES;
2248: END IF;
2249:
2250: END IF;
2251:

Line 2261: IF l_result = OE_PC_GLOBALS.YES THEN

2257: ,p_record => l_rowtype_rec
2258: ,x_on_operation_action => l_on_operation_action
2259: );
2260:
2261: IF l_result = OE_PC_GLOBALS.YES THEN
2262: -- set OUT result to CONSTRAINED
2263: x_result := OE_PC_GLOBALS.YES;
2264: END IF;
2265:

Line 2263: x_result := OE_PC_GLOBALS.YES;

2259: );
2260:
2261: IF l_result = OE_PC_GLOBALS.YES THEN
2262: -- set OUT result to CONSTRAINED
2263: x_result := OE_PC_GLOBALS.YES;
2264: END IF;
2265:
2266: END IF;
2267:

Line 2277: IF l_result = OE_PC_GLOBALS.YES THEN

2273: ,p_record => l_rowtype_rec
2274: ,x_on_operation_action => l_on_operation_action
2275: );
2276:
2277: IF l_result = OE_PC_GLOBALS.YES THEN
2278: -- set OUT result to CONSTRAINED
2279: x_result := OE_PC_GLOBALS.YES;
2280: END IF;
2281:

Line 2279: x_result := OE_PC_GLOBALS.YES;

2275: );
2276:
2277: IF l_result = OE_PC_GLOBALS.YES THEN
2278: -- set OUT result to CONSTRAINED
2279: x_result := OE_PC_GLOBALS.YES;
2280: END IF;
2281:
2282: END IF;
2283:

Line 2293: IF l_result = OE_PC_GLOBALS.YES THEN

2289: ,p_record => l_rowtype_rec
2290: ,x_on_operation_action => l_on_operation_action
2291: );
2292:
2293: IF l_result = OE_PC_GLOBALS.YES THEN
2294: -- set OUT result to CONSTRAINED
2295: x_result := OE_PC_GLOBALS.YES;
2296: END IF;
2297:

Line 2295: x_result := OE_PC_GLOBALS.YES;

2291: );
2292:
2293: IF l_result = OE_PC_GLOBALS.YES THEN
2294: -- set OUT result to CONSTRAINED
2295: x_result := OE_PC_GLOBALS.YES;
2296: END IF;
2297:
2298: END IF;
2299:

Line 2309: IF l_result = OE_PC_GLOBALS.YES THEN

2305: ,p_record => l_rowtype_rec
2306: ,x_on_operation_action => l_on_operation_action
2307: );
2308:
2309: IF l_result = OE_PC_GLOBALS.YES THEN
2310: -- set OUT result to CONSTRAINED
2311: x_result := OE_PC_GLOBALS.YES;
2312: END IF;
2313:

Line 2311: x_result := OE_PC_GLOBALS.YES;

2307: );
2308:
2309: IF l_result = OE_PC_GLOBALS.YES THEN
2310: -- set OUT result to CONSTRAINED
2311: x_result := OE_PC_GLOBALS.YES;
2312: END IF;
2313:
2314: END IF;
2315:

Line 2325: IF l_result = OE_PC_GLOBALS.YES THEN

2321: ,p_record => l_rowtype_rec
2322: ,x_on_operation_action => l_on_operation_action
2323: );
2324:
2325: IF l_result = OE_PC_GLOBALS.YES THEN
2326: -- set OUT result to CONSTRAINED
2327: x_result := OE_PC_GLOBALS.YES;
2328: END IF;
2329:

Line 2327: x_result := OE_PC_GLOBALS.YES;

2323: );
2324:
2325: IF l_result = OE_PC_GLOBALS.YES THEN
2326: -- set OUT result to CONSTRAINED
2327: x_result := OE_PC_GLOBALS.YES;
2328: END IF;
2329:
2330: END IF;
2331:

Line 2341: IF l_result = OE_PC_GLOBALS.YES THEN

2337: ,p_record => l_rowtype_rec
2338: ,x_on_operation_action => l_on_operation_action
2339: );
2340:
2341: IF l_result = OE_PC_GLOBALS.YES THEN
2342: -- set OUT result to CONSTRAINED
2343: x_result := OE_PC_GLOBALS.YES;
2344: END IF;
2345:

Line 2343: x_result := OE_PC_GLOBALS.YES;

2339: );
2340:
2341: IF l_result = OE_PC_GLOBALS.YES THEN
2342: -- set OUT result to CONSTRAINED
2343: x_result := OE_PC_GLOBALS.YES;
2344: END IF;
2345:
2346: END IF;
2347:

Line 2357: IF l_result = OE_PC_GLOBALS.YES THEN

2353: ,p_record => l_rowtype_rec
2354: ,x_on_operation_action => l_on_operation_action
2355: );
2356:
2357: IF l_result = OE_PC_GLOBALS.YES THEN
2358: -- set OUT result to CONSTRAINED
2359: x_result := OE_PC_GLOBALS.YES;
2360: END IF;
2361:

Line 2359: x_result := OE_PC_GLOBALS.YES;

2355: );
2356:
2357: IF l_result = OE_PC_GLOBALS.YES THEN
2358: -- set OUT result to CONSTRAINED
2359: x_result := OE_PC_GLOBALS.YES;
2360: END IF;
2361:
2362: END IF;
2363:

Line 2373: IF l_result = OE_PC_GLOBALS.YES THEN

2369: ,p_record => l_rowtype_rec
2370: ,x_on_operation_action => l_on_operation_action
2371: );
2372:
2373: IF l_result = OE_PC_GLOBALS.YES THEN
2374: -- set OUT result to CONSTRAINED
2375: x_result := OE_PC_GLOBALS.YES;
2376: END IF;
2377:

Line 2375: x_result := OE_PC_GLOBALS.YES;

2371: );
2372:
2373: IF l_result = OE_PC_GLOBALS.YES THEN
2374: -- set OUT result to CONSTRAINED
2375: x_result := OE_PC_GLOBALS.YES;
2376: END IF;
2377:
2378: END IF;
2379:

Line 2389: IF l_result = OE_PC_GLOBALS.YES THEN

2385: ,p_record => l_rowtype_rec
2386: ,x_on_operation_action => l_on_operation_action
2387: );
2388:
2389: IF l_result = OE_PC_GLOBALS.YES THEN
2390: -- set OUT result to CONSTRAINED
2391: x_result := OE_PC_GLOBALS.YES;
2392: END IF;
2393:

Line 2391: x_result := OE_PC_GLOBALS.YES;

2387: );
2388:
2389: IF l_result = OE_PC_GLOBALS.YES THEN
2390: -- set OUT result to CONSTRAINED
2391: x_result := OE_PC_GLOBALS.YES;
2392: END IF;
2393:
2394: END IF;
2395:

Line 2405: IF l_result = OE_PC_GLOBALS.YES THEN

2401: ,p_record => l_rowtype_rec
2402: ,x_on_operation_action => l_on_operation_action
2403: );
2404:
2405: IF l_result = OE_PC_GLOBALS.YES THEN
2406: -- set OUT result to CONSTRAINED
2407: x_result := OE_PC_GLOBALS.YES;
2408: END IF;
2409:

Line 2407: x_result := OE_PC_GLOBALS.YES;

2403: );
2404:
2405: IF l_result = OE_PC_GLOBALS.YES THEN
2406: -- set OUT result to CONSTRAINED
2407: x_result := OE_PC_GLOBALS.YES;
2408: END IF;
2409:
2410: END IF;
2411:

Line 2421: IF l_result = OE_PC_GLOBALS.YES THEN

2417: ,p_record => l_rowtype_rec
2418: ,x_on_operation_action => l_on_operation_action
2419: );
2420:
2421: IF l_result = OE_PC_GLOBALS.YES THEN
2422: -- set OUT result to CONSTRAINED
2423: x_result := OE_PC_GLOBALS.YES;
2424: END IF;
2425:

Line 2423: x_result := OE_PC_GLOBALS.YES;

2419: );
2420:
2421: IF l_result = OE_PC_GLOBALS.YES THEN
2422: -- set OUT result to CONSTRAINED
2423: x_result := OE_PC_GLOBALS.YES;
2424: END IF;
2425:
2426: END IF;
2427:

Line 2437: IF l_result = OE_PC_GLOBALS.YES THEN

2433: ,p_record => l_rowtype_rec
2434: ,x_on_operation_action => l_on_operation_action
2435: );
2436:
2437: IF l_result = OE_PC_GLOBALS.YES THEN
2438: -- set OUT result to CONSTRAINED
2439: x_result := OE_PC_GLOBALS.YES;
2440: END IF;
2441:

Line 2439: x_result := OE_PC_GLOBALS.YES;

2435: );
2436:
2437: IF l_result = OE_PC_GLOBALS.YES THEN
2438: -- set OUT result to CONSTRAINED
2439: x_result := OE_PC_GLOBALS.YES;
2440: END IF;
2441:
2442: END IF;
2443:

Line 2453: IF l_result = OE_PC_GLOBALS.YES THEN

2449: ,p_record => l_rowtype_rec
2450: ,x_on_operation_action => l_on_operation_action
2451: );
2452:
2453: IF l_result = OE_PC_GLOBALS.YES THEN
2454: -- set OUT result to CONSTRAINED
2455: x_result := OE_PC_GLOBALS.YES;
2456: END IF;
2457:

Line 2455: x_result := OE_PC_GLOBALS.YES;

2451: );
2452:
2453: IF l_result = OE_PC_GLOBALS.YES THEN
2454: -- set OUT result to CONSTRAINED
2455: x_result := OE_PC_GLOBALS.YES;
2456: END IF;
2457:
2458: END IF;
2459:

Line 2469: IF l_result = OE_PC_GLOBALS.YES THEN

2465: ,p_record => l_rowtype_rec
2466: ,x_on_operation_action => l_on_operation_action
2467: );
2468:
2469: IF l_result = OE_PC_GLOBALS.YES THEN
2470: -- set OUT result to CONSTRAINED
2471: x_result := OE_PC_GLOBALS.YES;
2472: END IF;
2473:

Line 2471: x_result := OE_PC_GLOBALS.YES;

2467: );
2468:
2469: IF l_result = OE_PC_GLOBALS.YES THEN
2470: -- set OUT result to CONSTRAINED
2471: x_result := OE_PC_GLOBALS.YES;
2472: END IF;
2473:
2474: END IF;
2475:

Line 2488: IF l_result = OE_PC_GLOBALS.YES THEN

2484: ,p_record => l_rowtype_rec
2485: ,x_on_operation_action => l_on_operation_action
2486: );
2487:
2488: IF l_result = OE_PC_GLOBALS.YES THEN
2489: -- set OUT result to CONSTRAINED
2490: x_result := OE_PC_GLOBALS.YES;
2491: END IF;
2492:

Line 2490: x_result := OE_PC_GLOBALS.YES;

2486: );
2487:
2488: IF l_result = OE_PC_GLOBALS.YES THEN
2489: -- set OUT result to CONSTRAINED
2490: x_result := OE_PC_GLOBALS.YES;
2491: END IF;
2492:
2493: END IF;
2494:

Line 2508: IF l_result = OE_PC_GLOBALS.YES THEN

2504: ,p_record => l_rowtype_rec
2505: ,x_on_operation_action => l_on_operation_action
2506: );
2507:
2508: IF l_result = OE_PC_GLOBALS.YES THEN
2509: -- set OUT result to CONSTRAINED
2510: x_result := OE_PC_GLOBALS.YES;
2511: END IF;
2512:

Line 2510: x_result := OE_PC_GLOBALS.YES;

2506: );
2507:
2508: IF l_result = OE_PC_GLOBALS.YES THEN
2509: -- set OUT result to CONSTRAINED
2510: x_result := OE_PC_GLOBALS.YES;
2511: END IF;
2512:
2513: END IF;
2514:

Line 2524: IF l_result = OE_PC_GLOBALS.YES THEN

2520: ,p_record => l_rowtype_rec
2521: ,x_on_operation_action => l_on_operation_action
2522: );
2523:
2524: IF l_result = OE_PC_GLOBALS.YES THEN
2525: -- set OUT result to CONSTRAINED
2526: x_result := OE_PC_GLOBALS.YES;
2527: END IF;
2528:

Line 2526: x_result := OE_PC_GLOBALS.YES;

2522: );
2523:
2524: IF l_result = OE_PC_GLOBALS.YES THEN
2525: -- set OUT result to CONSTRAINED
2526: x_result := OE_PC_GLOBALS.YES;
2527: END IF;
2528:
2529: END IF;
2530:

Line 2540: IF l_result = OE_PC_GLOBALS.YES THEN

2536: ,p_record => l_rowtype_rec
2537: ,x_on_operation_action => l_on_operation_action
2538: );
2539:
2540: IF l_result = OE_PC_GLOBALS.YES THEN
2541: -- set OUT result to CONSTRAINED
2542: x_result := OE_PC_GLOBALS.YES;
2543: END IF;
2544:

Line 2542: x_result := OE_PC_GLOBALS.YES;

2538: );
2539:
2540: IF l_result = OE_PC_GLOBALS.YES THEN
2541: -- set OUT result to CONSTRAINED
2542: x_result := OE_PC_GLOBALS.YES;
2543: END IF;
2544:
2545: END IF;
2546: --bug6531947

Line 2557: IF l_result = OE_PC_GLOBALS.YES THEN

2553: ,p_record => l_rowtype_rec
2554: ,x_on_operation_action => l_on_operation_action
2555: );
2556:
2557: IF l_result = OE_PC_GLOBALS.YES THEN
2558: -- set OUT result to CONSTRAINED
2559: x_result := OE_PC_GLOBALS.YES;
2560: END IF;
2561:

Line 2559: x_result := OE_PC_GLOBALS.YES;

2555: );
2556:
2557: IF l_result = OE_PC_GLOBALS.YES THEN
2558: -- set OUT result to CONSTRAINED
2559: x_result := OE_PC_GLOBALS.YES;
2560: END IF;
2561:
2562: END IF;
2563:

Line 2574: IF l_result = OE_PC_GLOBALS.YES THEN

2570: (p_operation => l_operation
2571: ,p_record => l_rowtype_rec
2572: ,x_on_operation_action => l_on_operation_action
2573: );
2574: IF l_result = OE_PC_GLOBALS.YES THEN
2575: -- set OUT result to CONSTRAINED
2576: x_result := OE_PC_GLOBALS.YES;
2577: END IF;
2578:

Line 2576: x_result := OE_PC_GLOBALS.YES;

2572: ,x_on_operation_action => l_on_operation_action
2573: );
2574: IF l_result = OE_PC_GLOBALS.YES THEN
2575: -- set OUT result to CONSTRAINED
2576: x_result := OE_PC_GLOBALS.YES;
2577: END IF;
2578:
2579: END IF;
2580:

Line 2589: IF l_result = OE_PC_GLOBALS.YES THEN

2585: (p_operation => l_operation
2586: ,p_record => l_rowtype_rec
2587: ,x_on_operation_action => l_on_operation_action
2588: );
2589: IF l_result = OE_PC_GLOBALS.YES THEN
2590: -- set OUT result to CONSTRAINED
2591: x_result := OE_PC_GLOBALS.YES;
2592: END IF;
2593:

Line 2591: x_result := OE_PC_GLOBALS.YES;

2587: ,x_on_operation_action => l_on_operation_action
2588: );
2589: IF l_result = OE_PC_GLOBALS.YES THEN
2590: -- set OUT result to CONSTRAINED
2591: x_result := OE_PC_GLOBALS.YES;
2592: END IF;
2593:
2594: END IF;
2595:

Line 2604: IF l_result = OE_PC_GLOBALS.YES THEN

2600: (p_operation => l_operation
2601: ,p_record => l_rowtype_rec
2602: ,x_on_operation_action => l_on_operation_action
2603: );
2604: IF l_result = OE_PC_GLOBALS.YES THEN
2605: -- set OUT result to CONSTRAINED
2606: x_result := OE_PC_GLOBALS.YES;
2607: END IF;
2608:

Line 2606: x_result := OE_PC_GLOBALS.YES;

2602: ,x_on_operation_action => l_on_operation_action
2603: );
2604: IF l_result = OE_PC_GLOBALS.YES THEN
2605: -- set OUT result to CONSTRAINED
2606: x_result := OE_PC_GLOBALS.YES;
2607: END IF;
2608:
2609: END IF;
2610:

Line 2619: IF l_result = OE_PC_GLOBALS.YES THEN

2615: (p_operation => l_operation
2616: ,p_record => l_rowtype_rec
2617: ,x_on_operation_action => l_on_operation_action
2618: );
2619: IF l_result = OE_PC_GLOBALS.YES THEN
2620: -- set OUT result to CONSTRAINED
2621: x_result := OE_PC_GLOBALS.YES;
2622: END IF;
2623:

Line 2621: x_result := OE_PC_GLOBALS.YES;

2617: ,x_on_operation_action => l_on_operation_action
2618: );
2619: IF l_result = OE_PC_GLOBALS.YES THEN
2620: -- set OUT result to CONSTRAINED
2621: x_result := OE_PC_GLOBALS.YES;
2622: END IF;
2623:
2624: END IF;
2625:

Line 2634: IF l_result = OE_PC_GLOBALS.YES THEN

2630: (p_operation => l_operation
2631: ,p_record => l_rowtype_rec
2632: ,x_on_operation_action => l_on_operation_action
2633: );
2634: IF l_result = OE_PC_GLOBALS.YES THEN
2635: -- set OUT result to CONSTRAINED
2636: x_result := OE_PC_GLOBALS.YES;
2637: END IF;
2638:

Line 2636: x_result := OE_PC_GLOBALS.YES;

2632: ,x_on_operation_action => l_on_operation_action
2633: );
2634: IF l_result = OE_PC_GLOBALS.YES THEN
2635: -- set OUT result to CONSTRAINED
2636: x_result := OE_PC_GLOBALS.YES;
2637: END IF;
2638:
2639: END IF;
2640:

Line 2648: IF l_result = OE_PC_GLOBALS.YES THEN

2644: (p_operation => l_operation
2645: ,p_record => l_rowtype_rec
2646: ,x_on_operation_action => l_on_operation_action
2647: );
2648: IF l_result = OE_PC_GLOBALS.YES THEN
2649: -- set OUT result to CONSTRAINED
2650: x_result := OE_PC_GLOBALS.YES;
2651: END IF;
2652:

Line 2650: x_result := OE_PC_GLOBALS.YES;

2646: ,x_on_operation_action => l_on_operation_action
2647: );
2648: IF l_result = OE_PC_GLOBALS.YES THEN
2649: -- set OUT result to CONSTRAINED
2650: x_result := OE_PC_GLOBALS.YES;
2651: END IF;
2652:
2653: END IF;
2654:

Line 2663: IF l_result = OE_PC_GLOBALS.YES THEN

2659: (p_operation => l_operation
2660: ,p_record => l_rowtype_rec
2661: ,x_on_operation_action => l_on_operation_action
2662: );
2663: IF l_result = OE_PC_GLOBALS.YES THEN
2664: -- set OUT result to CONSTRAINED
2665: x_result := OE_PC_GLOBALS.YES;
2666: END IF;
2667:

Line 2665: x_result := OE_PC_GLOBALS.YES;

2661: ,x_on_operation_action => l_on_operation_action
2662: );
2663: IF l_result = OE_PC_GLOBALS.YES THEN
2664: -- set OUT result to CONSTRAINED
2665: x_result := OE_PC_GLOBALS.YES;
2666: END IF;
2667:
2668: END IF;
2669:

Line 2679: IF l_result = OE_PC_GLOBALS.YES THEN

2675: ,p_record => l_rowtype_rec
2676: ,x_on_operation_action => l_on_operation_action
2677: );
2678:
2679: IF l_result = OE_PC_GLOBALS.YES THEN
2680: -- set OUT result to CONSTRAINED
2681: x_result := OE_PC_GLOBALS.YES;
2682: END IF;
2683:

Line 2681: x_result := OE_PC_GLOBALS.YES;

2677: );
2678:
2679: IF l_result = OE_PC_GLOBALS.YES THEN
2680: -- set OUT result to CONSTRAINED
2681: x_result := OE_PC_GLOBALS.YES;
2682: END IF;
2683:
2684: END IF;
2685:

Line 2694: IF l_result = OE_PC_GLOBALS.YES THEN

2690: ,p_record => l_rowtype_rec
2691: ,x_on_operation_action => l_on_operation_action
2692: );
2693:
2694: IF l_result = OE_PC_GLOBALS.YES THEN
2695: -- set OUT result to CONSTRAINED
2696: x_result := OE_PC_GLOBALS.YES;
2697: END IF;
2698:

Line 2696: x_result := OE_PC_GLOBALS.YES;

2692: );
2693:
2694: IF l_result = OE_PC_GLOBALS.YES THEN
2695: -- set OUT result to CONSTRAINED
2696: x_result := OE_PC_GLOBALS.YES;
2697: END IF;
2698:
2699: END IF;
2700:

Line 2710: IF l_result = OE_PC_GLOBALS.YES THEN

2706: ,p_record => l_rowtype_rec
2707: ,x_on_operation_action => l_on_operation_action
2708: );
2709:
2710: IF l_result = OE_PC_GLOBALS.YES THEN
2711: -- set OUT result to CONSTRAINED
2712: x_result := OE_PC_GLOBALS.YES;
2713: END IF;
2714:

Line 2712: x_result := OE_PC_GLOBALS.YES;

2708: );
2709:
2710: IF l_result = OE_PC_GLOBALS.YES THEN
2711: -- set OUT result to CONSTRAINED
2712: x_result := OE_PC_GLOBALS.YES;
2713: END IF;
2714:
2715: END IF;
2716:

Line 2724: IF l_result = OE_PC_GLOBALS.YES THEN

2720: (p_operation => l_operation
2721: ,p_record => l_rowtype_rec
2722: ,x_on_operation_action => l_on_operation_action
2723: );
2724: IF l_result = OE_PC_GLOBALS.YES THEN
2725: -- set OUT result to CONSTRAINED
2726: x_result := OE_PC_GLOBALS.YES;
2727: END IF;
2728:

Line 2726: x_result := OE_PC_GLOBALS.YES;

2722: ,x_on_operation_action => l_on_operation_action
2723: );
2724: IF l_result = OE_PC_GLOBALS.YES THEN
2725: -- set OUT result to CONSTRAINED
2726: x_result := OE_PC_GLOBALS.YES;
2727: END IF;
2728:
2729: END IF;
2730:

Line 2740: IF l_result = OE_PC_GLOBALS.YES THEN

2736: ,p_record => l_rowtype_rec
2737: ,x_on_operation_action => l_on_operation_action
2738: );
2739:
2740: IF l_result = OE_PC_GLOBALS.YES THEN
2741: -- set OUT result to CONSTRAINED
2742: x_result := OE_PC_GLOBALS.YES;
2743: END IF;
2744:

Line 2742: x_result := OE_PC_GLOBALS.YES;

2738: );
2739:
2740: IF l_result = OE_PC_GLOBALS.YES THEN
2741: -- set OUT result to CONSTRAINED
2742: x_result := OE_PC_GLOBALS.YES;
2743: END IF;
2744:
2745: END IF;
2746:

Line 2755: IF l_result = OE_PC_GLOBALS.YES THEN

2751: ,p_record => l_rowtype_rec
2752: ,x_on_operation_action => l_on_operation_action
2753: );
2754:
2755: IF l_result = OE_PC_GLOBALS.YES THEN
2756: -- set OUT result to CONSTRAINED
2757: x_result := OE_PC_GLOBALS.YES;
2758: END IF;
2759:

Line 2757: x_result := OE_PC_GLOBALS.YES;

2753: );
2754:
2755: IF l_result = OE_PC_GLOBALS.YES THEN
2756: -- set OUT result to CONSTRAINED
2757: x_result := OE_PC_GLOBALS.YES;
2758: END IF;
2759:
2760: END IF;
2761:

Line 2770: IF l_result = OE_PC_GLOBALS.YES THEN

2766: ,p_record => l_rowtype_rec
2767: ,x_on_operation_action => l_on_operation_action
2768: );
2769:
2770: IF l_result = OE_PC_GLOBALS.YES THEN
2771: -- set OUT result to CONSTRAINED
2772: x_result := OE_PC_GLOBALS.YES;
2773: END IF;
2774:

Line 2772: x_result := OE_PC_GLOBALS.YES;

2768: );
2769:
2770: IF l_result = OE_PC_GLOBALS.YES THEN
2771: -- set OUT result to CONSTRAINED
2772: x_result := OE_PC_GLOBALS.YES;
2773: END IF;
2774:
2775: END IF;
2776:

Line 2785: IF l_result = OE_PC_GLOBALS.YES THEN

2781: ,p_record => l_rowtype_rec
2782: ,x_on_operation_action => l_on_operation_action
2783: );
2784:
2785: IF l_result = OE_PC_GLOBALS.YES THEN
2786: -- set OUT result to CONSTRAINED
2787: x_result := OE_PC_GLOBALS.YES;
2788: END IF;
2789:

Line 2787: x_result := OE_PC_GLOBALS.YES;

2783: );
2784:
2785: IF l_result = OE_PC_GLOBALS.YES THEN
2786: -- set OUT result to CONSTRAINED
2787: x_result := OE_PC_GLOBALS.YES;
2788: END IF;
2789:
2790: END IF;
2791:

Line 2800: IF l_result = OE_PC_GLOBALS.YES THEN

2796: ,p_record => l_rowtype_rec
2797: ,x_on_operation_action => l_on_operation_action
2798: );
2799:
2800: IF l_result = OE_PC_GLOBALS.YES THEN
2801: -- set OUT result to CONSTRAINED
2802: x_result := OE_PC_GLOBALS.YES;
2803: END IF;
2804:

Line 2802: x_result := OE_PC_GLOBALS.YES;

2798: );
2799:
2800: IF l_result = OE_PC_GLOBALS.YES THEN
2801: -- set OUT result to CONSTRAINED
2802: x_result := OE_PC_GLOBALS.YES;
2803: END IF;
2804:
2805: END IF;
2806:

Line 2815: IF l_result = OE_PC_GLOBALS.YES THEN

2811: ,p_record => l_rowtype_rec
2812: ,x_on_operation_action => l_on_operation_action
2813: );
2814:
2815: IF l_result = OE_PC_GLOBALS.YES THEN
2816: -- set OUT result to CONSTRAINED
2817: x_result := OE_PC_GLOBALS.YES;
2818: END IF;
2819:

Line 2817: x_result := OE_PC_GLOBALS.YES;

2813: );
2814:
2815: IF l_result = OE_PC_GLOBALS.YES THEN
2816: -- set OUT result to CONSTRAINED
2817: x_result := OE_PC_GLOBALS.YES;
2818: END IF;
2819:
2820: END IF;
2821:

Line 2830: IF l_result = OE_PC_GLOBALS.YES THEN

2826: ,p_record => l_rowtype_rec
2827: ,x_on_operation_action => l_on_operation_action
2828: );
2829:
2830: IF l_result = OE_PC_GLOBALS.YES THEN
2831: -- set OUT result to CONSTRAINED
2832: x_result := OE_PC_GLOBALS.YES;
2833: END IF;
2834:

Line 2832: x_result := OE_PC_GLOBALS.YES;

2828: );
2829:
2830: IF l_result = OE_PC_GLOBALS.YES THEN
2831: -- set OUT result to CONSTRAINED
2832: x_result := OE_PC_GLOBALS.YES;
2833: END IF;
2834:
2835: END IF;
2836:

Line 2844: IF l_result = OE_PC_GLOBALS.YES THEN

2840: (p_operation => l_operation
2841: ,p_record => l_rowtype_rec
2842: ,x_on_operation_action => l_on_operation_action
2843: );
2844: IF l_result = OE_PC_GLOBALS.YES THEN
2845: -- set OUT result to CONSTRAINED
2846: x_result := OE_PC_GLOBALS.YES;
2847: END IF;
2848:

Line 2846: x_result := OE_PC_GLOBALS.YES;

2842: ,x_on_operation_action => l_on_operation_action
2843: );
2844: IF l_result = OE_PC_GLOBALS.YES THEN
2845: -- set OUT result to CONSTRAINED
2846: x_result := OE_PC_GLOBALS.YES;
2847: END IF;
2848:
2849: END IF;
2850:

Line 2860: IF l_result = OE_PC_GLOBALS.YES THEN

2856: ,p_record => l_rowtype_rec
2857: ,x_on_operation_action => l_on_operation_action
2858: );
2859:
2860: IF l_result = OE_PC_GLOBALS.YES THEN
2861: -- set OUT result to CONSTRAINED
2862: x_result := OE_PC_GLOBALS.YES;
2863: END IF;
2864:

Line 2862: x_result := OE_PC_GLOBALS.YES;

2858: );
2859:
2860: IF l_result = OE_PC_GLOBALS.YES THEN
2861: -- set OUT result to CONSTRAINED
2862: x_result := OE_PC_GLOBALS.YES;
2863: END IF;
2864:
2865: END IF;
2866:

Line 2876: IF l_result = OE_PC_GLOBALS.YES THEN

2872: ,x_on_operation_action => l_on_operation_action
2873: );
2874:
2875:
2876: IF l_result = OE_PC_GLOBALS.YES THEN
2877: -- set OUT result to CONSTRAINED
2878: x_result := OE_PC_GLOBALS.YES;
2879: END IF;
2880:

Line 2878: x_result := OE_PC_GLOBALS.YES;

2874:
2875:
2876: IF l_result = OE_PC_GLOBALS.YES THEN
2877: -- set OUT result to CONSTRAINED
2878: x_result := OE_PC_GLOBALS.YES;
2879: END IF;
2880:
2881: END IF;
2882:

Line 2894: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN

2890: -- updated and profile was set to 'N', global at the end should
2891: -- be re-set to 'Y' - this indicates to process order that no
2892: -- constrainable attributes were updated and thus, it would
2893: -- suppress entity level security check also.
2894: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
2895: l_check_all_cols_constraint := g_check_all_cols_constraint;
2896: g_check_all_cols_constraint := 'N';
2897: END IF;
2898:

Line 2899: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN

2895: l_check_all_cols_constraint := g_check_all_cols_constraint;
2896: g_check_all_cols_constraint := 'N';
2897: END IF;
2898:
2899: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
2900: IF l_debug_level > 0 THEN
2901: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
2902: END IF;
2903: g_check_all_cols_constraint := l_check_all_cols_constraint;

Line 2934: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

2930:
2931: END Attributes;
2932:
2933: FUNCTION ON_HOLD_FLAG
2934: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
2935: , p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
2936: , x_on_operation_action OUT NOCOPY NUMBER
2937: ) RETURN NUMBER
2938: IS