52: ( p_responsibility_id => nvl(fnd_global.resp_id, -1)
53: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
54: , p_operation => p_operation
55: , p_qualifier_attribute => l_transaction_phase_code
56: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_SCREDIT
57: , p_column_name => p_column_name
58: , p_check_all_cols_constraint => g_check_all_cols_constraint
59: , p_is_caller_defaulting => g_is_caller_defaulting
60: , p_use_cached_results => 'Y'
62: , x_constraining_conditions_grp => l_grp
63: , x_on_operation_action => x_on_operation_action
64: );
65:
66: if l_result = OE_PC_GLOBALS.YES then
67:
68: IF g_check_all_cols_constraint = 'Y'
69: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
70: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
65:
66: if l_result = OE_PC_GLOBALS.YES then
67:
68: IF g_check_all_cols_constraint = 'Y'
69: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
70: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
71: AND x_on_operation_action = 0
72: AND p_column_name IS NOT NULL THEN
73: SELECT column_name
66: if l_result = OE_PC_GLOBALS.YES then
67:
68: IF g_check_all_cols_constraint = 'Y'
69: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
70: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
71: AND x_on_operation_action = 0
72: AND p_column_name IS NOT NULL THEN
73: SELECT column_name
74: INTO l_constrained_column
79: RAISE FND_API.G_EXC_ERROR;
80: end if;
81: END IF;
82:
83: elsif l_result = OE_PC_GLOBALS.ERROR then
84:
85: raise FND_API.G_EXC_UNEXPECTED_ERROR;
86:
87: end if;
108: OPEN IS_ORDER_BOOKED (p_record.header_id);
109: FETCH IS_ORDER_BOOKED INTO l_order_booked_flag;
110: CLOSE IS_ORDER_BOOKED;
111: IF l_order_booked_flag = 'Y' THEN
112: IF l_result = OE_PC_GLOBALS.YES THEN
113: IF x_on_operation_action = 1 THEN
114: -- set OUT result to NOT CONSTRAINED
115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add( 'HEADER SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
128: END IF;
129: END IF;
130: END IF;
131: ELSE -- capture audit trail for all orders
132: IF l_result = OE_PC_GLOBALS.YES THEN
133: IF x_on_operation_action = 1 THEN
134: -- set OUT result to NOT CONSTRAINED
135: IF l_debug_level > 0 THEN
136: oe_debug_pub.add( 'HEADER SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
152: END IF;
153: /* End AuditTrail */
154:
155: IF x_on_operation_action > 0 THEN
156: l_result := OE_PC_GLOBALS.NO;
157: END IF;
158:
159: RETURN l_result;
160:
165:
166: -- Start of fix #1459428 for function definition
167:
168: FUNCTION ATTRIBUTE1
169: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
170: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
171: , x_on_operation_action OUT NOCOPY NUMBER
172:
173: ) RETURN NUMBER
190: END ATTRIBUTE1;
191:
192:
193: FUNCTION ATTRIBUTE10
194: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
195: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
196: , x_on_operation_action OUT NOCOPY NUMBER
197:
198: ) RETURN NUMBER
215: END ATTRIBUTE10;
216:
217:
218: FUNCTION ATTRIBUTE11
219: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
220: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
221: , x_on_operation_action OUT NOCOPY NUMBER
222:
223: ) RETURN NUMBER
240: END ATTRIBUTE11;
241:
242:
243: FUNCTION ATTRIBUTE12
244: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
245: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
246: , x_on_operation_action OUT NOCOPY NUMBER
247:
248: ) RETURN NUMBER
265: END ATTRIBUTE12;
266:
267:
268: FUNCTION ATTRIBUTE13
269: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
270: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
271: , x_on_operation_action OUT NOCOPY NUMBER
272:
273: ) RETURN NUMBER
290: END ATTRIBUTE13;
291:
292:
293: FUNCTION ATTRIBUTE14
294: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
295: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
296: , x_on_operation_action OUT NOCOPY NUMBER
297:
298: ) RETURN NUMBER
315: END ATTRIBUTE14;
316:
317:
318: FUNCTION ATTRIBUTE15
319: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
320: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
321: , x_on_operation_action OUT NOCOPY NUMBER
322:
323: ) RETURN NUMBER
340: END ATTRIBUTE15;
341:
342:
343: FUNCTION ATTRIBUTE2
344: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
345: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
346: , x_on_operation_action OUT NOCOPY NUMBER
347:
348: ) RETURN NUMBER
365: END ATTRIBUTE2;
366:
367:
368: FUNCTION ATTRIBUTE3
369: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
370: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
371: , x_on_operation_action OUT NOCOPY NUMBER
372:
373: ) RETURN NUMBER
390: END ATTRIBUTE3;
391:
392:
393: FUNCTION ATTRIBUTE4
394: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
395: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
396: , x_on_operation_action OUT NOCOPY NUMBER
397:
398: ) RETURN NUMBER
415: END ATTRIBUTE4;
416:
417:
418: FUNCTION ATTRIBUTE5
419: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
420: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
421: , x_on_operation_action OUT NOCOPY NUMBER
422:
423: ) RETURN NUMBER
440: END ATTRIBUTE5;
441:
442:
443: FUNCTION ATTRIBUTE6
444: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
445: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
446: , x_on_operation_action OUT NOCOPY NUMBER
447:
448: ) RETURN NUMBER
465: END ATTRIBUTE6;
466:
467:
468: FUNCTION ATTRIBUTE7
469: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
470: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
471: , x_on_operation_action OUT NOCOPY NUMBER
472:
473: ) RETURN NUMBER
490: END ATTRIBUTE7;
491:
492:
493: FUNCTION ATTRIBUTE8
494: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
495: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
496: , x_on_operation_action OUT NOCOPY NUMBER
497:
498: ) RETURN NUMBER
515: END ATTRIBUTE8;
516:
517:
518: FUNCTION ATTRIBUTE9
519: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
520: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
521: , x_on_operation_action OUT NOCOPY NUMBER
522:
523: ) RETURN NUMBER
540: END ATTRIBUTE9;
541:
542:
543: FUNCTION CONTEXT
544: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
545: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
546: , x_on_operation_action OUT NOCOPY NUMBER
547:
548: ) RETURN NUMBER
566:
567: -- End of fix #1459428 for function definition
568:
569: FUNCTION CREATED_BY
570: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
571: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
572: , x_on_operation_action OUT NOCOPY NUMBER
573:
574: ) RETURN NUMBER
591: END CREATED_BY;
592:
593:
594: FUNCTION DW_UPDATE_ADVICE
595: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
596: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
597: , x_on_operation_action OUT NOCOPY NUMBER
598:
599: ) RETURN NUMBER
616: END DW_UPDATE_ADVICE;
617:
618:
619: FUNCTION PERCENT
620: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
621: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
622: , x_on_operation_action OUT NOCOPY NUMBER
623:
624: ) RETURN NUMBER
642:
643:
644:
645: FUNCTION SALESREP
646: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
647: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
648: , x_on_operation_action OUT NOCOPY NUMBER
649:
650: ) RETURN NUMBER
666:
667: END SALESREP;
668:
669: FUNCTION sales_credit_type
670: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
671: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
672: , x_on_operation_action OUT NOCOPY NUMBER
673:
674: ) RETURN NUMBER
690:
691: END sales_credit_type;
692:
693: FUNCTION WH_UPDATE_DATE
694: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
695: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
696: , x_on_operation_action OUT NOCOPY NUMBER
697:
698: ) RETURN NUMBER
737: -- Initializing return status to SUCCESS
738: x_return_status := FND_API.G_RET_STS_SUCCESS;
739:
740: IF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
741: l_operation := OE_PC_GLOBALS.CREATE_OP;
742: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
743: l_operation := OE_PC_GLOBALS.UPDATE_OP;
744: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
745: l_operation := OE_PC_GLOBALS.DELETE_OP;
739:
740: IF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
741: l_operation := OE_PC_GLOBALS.CREATE_OP;
742: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
743: l_operation := OE_PC_GLOBALS.UPDATE_OP;
744: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
745: l_operation := OE_PC_GLOBALS.DELETE_OP;
746: ELSE
747: IF l_debug_level > 0 THEN
741: l_operation := OE_PC_GLOBALS.CREATE_OP;
742: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
743: l_operation := OE_PC_GLOBALS.UPDATE_OP;
744: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
745: l_operation := OE_PC_GLOBALS.DELETE_OP;
746: ELSE
747: IF l_debug_level > 0 THEN
748: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
749: END IF;
805: -- Initializing return status to SUCCESS
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: -- Initializing out result to NOT CONSTRAINED
809: x_result := OE_PC_GLOBALS.NO;
810:
811: -- Get the operation code to be passed to the security framework API
812: IF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
813:
810:
811: -- Get the operation code to be passed to the security framework API
812: IF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
813:
814: l_operation := OE_PC_GLOBALS.CREATE_OP;
815:
816: -- Bug 1755817: if there are no attribute-specific insert
817: -- constraints, then no need to go further. Entity level
818: -- security check for CREATE will be called again from
817: -- constraints, then no need to go further. Entity level
818: -- security check for CREATE will be called again from
819: -- process order after defaulting.
820: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
821: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_SCREDIT
822: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
823: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
824: )
825: THEN
826: RETURN;
827: END IF;
828:
829: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
830: l_operation := OE_PC_GLOBALS.UPDATE_OP;
831: ELSE
832: IF l_debug_level > 0 THEN
833: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
834: END IF;
853: ,p_record => l_rowtype_rec
854: ,x_on_operation_action => l_on_operation_action
855: );
856:
857: IF l_result = OE_PC_GLOBALS.YES THEN
858: -- set OUT result to CONSTRAINED
859: x_result := OE_PC_GLOBALS.YES;
860: END IF;
861:
855: );
856:
857: IF l_result = OE_PC_GLOBALS.YES THEN
858: -- set OUT result to CONSTRAINED
859: x_result := OE_PC_GLOBALS.YES;
860: END IF;
861:
862: END IF;
863:
869: ,p_record => l_rowtype_rec
870: ,x_on_operation_action => l_on_operation_action
871: );
872:
873: IF l_result = OE_PC_GLOBALS.YES THEN
874: -- set OUT result to CONSTRAINED
875: x_result := OE_PC_GLOBALS.YES;
876: END IF;
877:
871: );
872:
873: IF l_result = OE_PC_GLOBALS.YES THEN
874: -- set OUT result to CONSTRAINED
875: x_result := OE_PC_GLOBALS.YES;
876: END IF;
877:
878: END IF;
879:
884: (p_operation => l_operation
885: ,p_record => l_rowtype_rec
886: ,x_on_operation_action => l_on_operation_action
887: );
888: IF l_result = OE_PC_GLOBALS.YES THEN
889: -- set OUT result to CONSTRAINED
890: x_result := OE_PC_GLOBALS.YES;
891: END IF;
892:
886: ,x_on_operation_action => l_on_operation_action
887: );
888: IF l_result = OE_PC_GLOBALS.YES THEN
889: -- set OUT result to CONSTRAINED
890: x_result := OE_PC_GLOBALS.YES;
891: END IF;
892:
893: END IF;
894:
900: (p_operation => l_operation
901: ,p_record => l_rowtype_rec
902: ,x_on_operation_action => l_on_operation_action
903: );
904: IF l_result = OE_PC_GLOBALS.YES THEN
905: -- set OUT result to CONSTRAINED
906: x_result := OE_PC_GLOBALS.YES;
907: END IF;
908:
902: ,x_on_operation_action => l_on_operation_action
903: );
904: IF l_result = OE_PC_GLOBALS.YES THEN
905: -- set OUT result to CONSTRAINED
906: x_result := OE_PC_GLOBALS.YES;
907: END IF;
908:
909: END IF;
910:
919: -- updated and profile was set to 'N', global at the end should
920: -- be re-set to 'Y' - this indicates to process order that no
921: -- constrainable attributes were updated and thus, it would
922: -- suppress entity level security check also.
923: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
924: l_check_all_cols_constraint := g_check_all_cols_constraint;
925: g_check_all_cols_constraint := 'N';
926: END IF;
927:
933: ,p_record => l_rowtype_rec
934: ,x_on_operation_action => l_on_operation_action
935: );
936:
937: IF l_result = OE_PC_GLOBALS.YES THEN
938: -- set OUT result to CONSTRAINED
939: x_result := OE_PC_GLOBALS.YES;
940: END IF;
941:
935: );
936:
937: IF l_result = OE_PC_GLOBALS.YES THEN
938: -- set OUT result to CONSTRAINED
939: x_result := OE_PC_GLOBALS.YES;
940: END IF;
941:
942: END IF;
943:
949: ,p_record => l_rowtype_rec
950: ,x_on_operation_action => l_on_operation_action
951: );
952:
953: IF l_result = OE_PC_GLOBALS.YES THEN
954: -- set OUT result to CONSTRAINED
955: x_result := OE_PC_GLOBALS.YES;
956: END IF;
957:
951: );
952:
953: IF l_result = OE_PC_GLOBALS.YES THEN
954: -- set OUT result to CONSTRAINED
955: x_result := OE_PC_GLOBALS.YES;
956: END IF;
957:
958: END IF;
959:
965: ,p_record => l_rowtype_rec
966: ,x_on_operation_action => l_on_operation_action
967: );
968:
969: IF l_result = OE_PC_GLOBALS.YES THEN
970: -- set OUT result to CONSTRAINED
971: x_result := OE_PC_GLOBALS.YES;
972: END IF;
973:
967: );
968:
969: IF l_result = OE_PC_GLOBALS.YES THEN
970: -- set OUT result to CONSTRAINED
971: x_result := OE_PC_GLOBALS.YES;
972: END IF;
973:
974: END IF;
975:
981: ,p_record => l_rowtype_rec
982: ,x_on_operation_action => l_on_operation_action
983: );
984:
985: IF l_result = OE_PC_GLOBALS.YES THEN
986: -- set OUT result to CONSTRAINED
987: x_result := OE_PC_GLOBALS.YES;
988: END IF;
989:
983: );
984:
985: IF l_result = OE_PC_GLOBALS.YES THEN
986: -- set OUT result to CONSTRAINED
987: x_result := OE_PC_GLOBALS.YES;
988: END IF;
989:
990: END IF;
991:
997: ,p_record => l_rowtype_rec
998: ,x_on_operation_action => l_on_operation_action
999: );
1000:
1001: IF l_result = OE_PC_GLOBALS.YES THEN
1002: -- set OUT result to CONSTRAINED
1003: x_result := OE_PC_GLOBALS.YES;
1004: END IF;
1005:
999: );
1000:
1001: IF l_result = OE_PC_GLOBALS.YES THEN
1002: -- set OUT result to CONSTRAINED
1003: x_result := OE_PC_GLOBALS.YES;
1004: END IF;
1005:
1006: END IF;
1007:
1013: ,p_record => l_rowtype_rec
1014: ,x_on_operation_action => l_on_operation_action
1015: );
1016:
1017: IF l_result = OE_PC_GLOBALS.YES THEN
1018: -- set OUT result to CONSTRAINED
1019: x_result := OE_PC_GLOBALS.YES;
1020: END IF;
1021:
1015: );
1016:
1017: IF l_result = OE_PC_GLOBALS.YES THEN
1018: -- set OUT result to CONSTRAINED
1019: x_result := OE_PC_GLOBALS.YES;
1020: END IF;
1021:
1022: END IF;
1023:
1029: ,p_record => l_rowtype_rec
1030: ,x_on_operation_action => l_on_operation_action
1031: );
1032:
1033: IF l_result = OE_PC_GLOBALS.YES THEN
1034: -- set OUT result to CONSTRAINED
1035: x_result := OE_PC_GLOBALS.YES;
1036: END IF;
1037:
1031: );
1032:
1033: IF l_result = OE_PC_GLOBALS.YES THEN
1034: -- set OUT result to CONSTRAINED
1035: x_result := OE_PC_GLOBALS.YES;
1036: END IF;
1037:
1038: END IF;
1039:
1045: ,p_record => l_rowtype_rec
1046: ,x_on_operation_action => l_on_operation_action
1047: );
1048:
1049: IF l_result = OE_PC_GLOBALS.YES THEN
1050: -- set OUT result to CONSTRAINED
1051: x_result := OE_PC_GLOBALS.YES;
1052: END IF;
1053:
1047: );
1048:
1049: IF l_result = OE_PC_GLOBALS.YES THEN
1050: -- set OUT result to CONSTRAINED
1051: x_result := OE_PC_GLOBALS.YES;
1052: END IF;
1053:
1054: END IF;
1055:
1061: ,p_record => l_rowtype_rec
1062: ,x_on_operation_action => l_on_operation_action
1063: );
1064:
1065: IF l_result = OE_PC_GLOBALS.YES THEN
1066: -- set OUT result to CONSTRAINED
1067: x_result := OE_PC_GLOBALS.YES;
1068: END IF;
1069:
1063: );
1064:
1065: IF l_result = OE_PC_GLOBALS.YES THEN
1066: -- set OUT result to CONSTRAINED
1067: x_result := OE_PC_GLOBALS.YES;
1068: END IF;
1069:
1070: END IF;
1071:
1077: ,p_record => l_rowtype_rec
1078: ,x_on_operation_action => l_on_operation_action
1079: );
1080:
1081: IF l_result = OE_PC_GLOBALS.YES THEN
1082: -- set OUT result to CONSTRAINED
1083: x_result := OE_PC_GLOBALS.YES;
1084: END IF;
1085:
1079: );
1080:
1081: IF l_result = OE_PC_GLOBALS.YES THEN
1082: -- set OUT result to CONSTRAINED
1083: x_result := OE_PC_GLOBALS.YES;
1084: END IF;
1085:
1086: END IF;
1087:
1093: ,p_record => l_rowtype_rec
1094: ,x_on_operation_action => l_on_operation_action
1095: );
1096:
1097: IF l_result = OE_PC_GLOBALS.YES THEN
1098: -- set OUT result to CONSTRAINED
1099: x_result := OE_PC_GLOBALS.YES;
1100: END IF;
1101:
1095: );
1096:
1097: IF l_result = OE_PC_GLOBALS.YES THEN
1098: -- set OUT result to CONSTRAINED
1099: x_result := OE_PC_GLOBALS.YES;
1100: END IF;
1101:
1102: END IF;
1103:
1109: ,p_record => l_rowtype_rec
1110: ,x_on_operation_action => l_on_operation_action
1111: );
1112:
1113: IF l_result = OE_PC_GLOBALS.YES THEN
1114: -- set OUT result to CONSTRAINED
1115: x_result := OE_PC_GLOBALS.YES;
1116: END IF;
1117:
1111: );
1112:
1113: IF l_result = OE_PC_GLOBALS.YES THEN
1114: -- set OUT result to CONSTRAINED
1115: x_result := OE_PC_GLOBALS.YES;
1116: END IF;
1117:
1118: END IF;
1119:
1125: ,p_record => l_rowtype_rec
1126: ,x_on_operation_action => l_on_operation_action
1127: );
1128:
1129: IF l_result = OE_PC_GLOBALS.YES THEN
1130: -- set OUT result to CONSTRAINED
1131: x_result := OE_PC_GLOBALS.YES;
1132: END IF;
1133:
1127: );
1128:
1129: IF l_result = OE_PC_GLOBALS.YES THEN
1130: -- set OUT result to CONSTRAINED
1131: x_result := OE_PC_GLOBALS.YES;
1132: END IF;
1133:
1134: END IF;
1135:
1141: ,p_record => l_rowtype_rec
1142: ,x_on_operation_action => l_on_operation_action
1143: );
1144:
1145: IF l_result = OE_PC_GLOBALS.YES THEN
1146: -- set OUT result to CONSTRAINED
1147: x_result := OE_PC_GLOBALS.YES;
1148: END IF;
1149:
1143: );
1144:
1145: IF l_result = OE_PC_GLOBALS.YES THEN
1146: -- set OUT result to CONSTRAINED
1147: x_result := OE_PC_GLOBALS.YES;
1148: END IF;
1149:
1150: END IF;
1151:
1157: ,p_record => l_rowtype_rec
1158: ,x_on_operation_action => l_on_operation_action
1159: );
1160:
1161: IF l_result = OE_PC_GLOBALS.YES THEN
1162: -- set OUT result to CONSTRAINED
1163: x_result := OE_PC_GLOBALS.YES;
1164: END IF;
1165:
1159: );
1160:
1161: IF l_result = OE_PC_GLOBALS.YES THEN
1162: -- set OUT result to CONSTRAINED
1163: x_result := OE_PC_GLOBALS.YES;
1164: END IF;
1165:
1166: END IF;
1167:
1173: ,p_record => l_rowtype_rec
1174: ,x_on_operation_action => l_on_operation_action
1175: );
1176:
1177: IF l_result = OE_PC_GLOBALS.YES THEN
1178: -- set OUT result to CONSTRAINED
1179: x_result := OE_PC_GLOBALS.YES;
1180: END IF;
1181:
1175: );
1176:
1177: IF l_result = OE_PC_GLOBALS.YES THEN
1178: -- set OUT result to CONSTRAINED
1179: x_result := OE_PC_GLOBALS.YES;
1180: END IF;
1181:
1182: END IF;
1183:
1189: ,p_record => l_rowtype_rec
1190: ,x_on_operation_action => l_on_operation_action
1191: );
1192:
1193: IF l_result = OE_PC_GLOBALS.YES THEN
1194: -- set OUT result to CONSTRAINED
1195: x_result := OE_PC_GLOBALS.YES;
1196: END IF;
1197:
1191: );
1192:
1193: IF l_result = OE_PC_GLOBALS.YES THEN
1194: -- set OUT result to CONSTRAINED
1195: x_result := OE_PC_GLOBALS.YES;
1196: END IF;
1197:
1198: END IF;
1199:
1196: END IF;
1197:
1198: END IF;
1199:
1200: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1201: IF l_debug_level > 0 THEN
1202: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1203: END IF;
1204: g_check_all_cols_constraint := l_check_all_cols_constraint;