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

Line 57: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_ADJ

53: ( p_responsibility_id => nvl(fnd_global.resp_id, -1)
54: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
55: , p_operation => p_operation
56: , p_qualifier_attribute => l_transaction_phase_code
57: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_ADJ
58: , p_column_name => p_column_name
59: , p_check_all_cols_constraint => g_check_all_cols_constraint
60: , p_is_caller_defaulting => g_is_caller_defaulting
61: , p_use_cached_results => 'Y'

Line 67: if l_result = OE_PC_GLOBALS.YES then

63: , x_constraining_conditions_grp => l_grp
64: , x_on_operation_action => x_on_operation_action
65: );
66:
67: if l_result = OE_PC_GLOBALS.YES then
68:
69: IF g_check_all_cols_constraint = 'Y'
70: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
71: OR p_operation = OE_PC_GLOBALS.CREATE_OP)

Line 70: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP

66:
67: if l_result = OE_PC_GLOBALS.YES then
68:
69: IF g_check_all_cols_constraint = 'Y'
70: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
71: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
72: AND x_on_operation_action = 0
73: AND p_column_name IS NOT NULL THEN
74: SELECT column_name

Line 71: OR p_operation = OE_PC_GLOBALS.CREATE_OP)

67: if l_result = OE_PC_GLOBALS.YES then
68:
69: IF g_check_all_cols_constraint = 'Y'
70: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
71: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
72: AND x_on_operation_action = 0
73: AND p_column_name IS NOT NULL THEN
74: SELECT column_name
75: INTO l_constrained_column

Line 83: elsif l_result = OE_PC_GLOBALS.ERROR then

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;

Line 112: IF l_result = OE_PC_GLOBALS.YES THEN

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 ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;

Line 132: IF l_result = OE_PC_GLOBALS.YES THEN

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 ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;

Line 155: l_result := OE_PC_GLOBALS.NO;

151: END IF;
152: END IF;
153: /* End AuditTrail */
154: IF x_on_operation_action > 0 THEN
155: l_result := OE_PC_GLOBALS.NO;
156: END IF;
157:
158: RETURN l_result;
159:

Line 167: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

163: -- PUBLIC PROCEDURES
164:
165:
166: FUNCTION ATTRIBUTE1
167: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
168: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
169: , x_on_operation_action OUT NOCOPY NUMBER
170:
171: ) RETURN NUMBER

Line 192: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

188: END ATTRIBUTE1;
189:
190:
191: FUNCTION ATTRIBUTE10
192: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
193: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
194: , x_on_operation_action OUT NOCOPY NUMBER
195:
196: ) RETURN NUMBER

Line 217: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

213: END ATTRIBUTE10;
214:
215:
216: FUNCTION ATTRIBUTE11
217: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
218: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
219: , x_on_operation_action OUT NOCOPY NUMBER
220:
221: ) RETURN NUMBER

Line 242: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

238: END ATTRIBUTE11;
239:
240:
241: FUNCTION ATTRIBUTE12
242: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
243: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
244: , x_on_operation_action OUT NOCOPY NUMBER
245:
246: ) RETURN NUMBER

Line 267: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

263: END ATTRIBUTE12;
264:
265:
266: FUNCTION ATTRIBUTE13
267: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
268: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
269: , x_on_operation_action OUT NOCOPY NUMBER
270:
271: ) RETURN NUMBER

Line 292: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

288: END ATTRIBUTE13;
289:
290:
291: FUNCTION ATTRIBUTE14
292: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
293: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
294: , x_on_operation_action OUT NOCOPY NUMBER
295:
296: ) RETURN NUMBER

Line 317: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

313: END ATTRIBUTE14;
314:
315:
316: FUNCTION ATTRIBUTE15
317: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
318: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
319: , x_on_operation_action OUT NOCOPY NUMBER
320:
321: ) RETURN NUMBER

Line 342: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

338: END ATTRIBUTE15;
339:
340:
341: FUNCTION ATTRIBUTE2
342: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
343: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
344: , x_on_operation_action OUT NOCOPY NUMBER
345:
346: ) RETURN NUMBER

Line 367: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

363: END ATTRIBUTE2;
364:
365:
366: FUNCTION ATTRIBUTE3
367: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
368: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
369: , x_on_operation_action OUT NOCOPY NUMBER
370:
371: ) RETURN NUMBER

Line 392: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

388: END ATTRIBUTE3;
389:
390:
391: FUNCTION ATTRIBUTE4
392: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
393: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
394: , x_on_operation_action OUT NOCOPY NUMBER
395:
396: ) RETURN NUMBER

Line 417: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

413: END ATTRIBUTE4;
414:
415:
416: FUNCTION ATTRIBUTE5
417: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
418: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
419: , x_on_operation_action OUT NOCOPY NUMBER
420:
421: ) RETURN NUMBER

Line 442: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 467: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

463: END ATTRIBUTE6;
464:
465:
466: FUNCTION ATTRIBUTE7
467: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
468: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
469: , x_on_operation_action OUT NOCOPY NUMBER
470:
471: ) RETURN NUMBER

Line 492: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

488: END ATTRIBUTE7;
489:
490:
491: FUNCTION ATTRIBUTE8
492: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
493: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
494: , x_on_operation_action OUT NOCOPY NUMBER
495:
496: ) RETURN NUMBER

Line 517: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

513: END ATTRIBUTE8;
514:
515:
516: FUNCTION ATTRIBUTE9
517: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
518: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
519: , x_on_operation_action OUT NOCOPY NUMBER
520:
521: ) RETURN NUMBER

Line 542: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

538: END ATTRIBUTE9;
539:
540:
541: FUNCTION AUTOMATIC
542: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
543: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
544: , x_on_operation_action OUT NOCOPY NUMBER
545:
546: ) RETURN NUMBER

Line 567: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

563: END AUTOMATIC;
564:
565:
566: FUNCTION CONTEXT
567: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
568: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
569: , x_on_operation_action OUT NOCOPY NUMBER
570:
571: ) RETURN NUMBER

Line 592: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

588: END CONTEXT;
589:
590:
591: FUNCTION CREATED_BY
592: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
593: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
594: , x_on_operation_action OUT NOCOPY NUMBER
595:
596: ) RETURN NUMBER

Line 617: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 642: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

638: END CREATION_DATE;
639:
640:
641: FUNCTION DISCOUNT
642: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
643: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
644: , x_on_operation_action OUT NOCOPY NUMBER
645:
646: ) RETURN NUMBER

Line 666: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

662:
663: END DISCOUNT;
664:
665: FUNCTION OPERAND
666: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
667: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
668: , x_on_operation_action OUT NOCOPY NUMBER
669:
670: ) RETURN NUMBER

Line 690: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

686:
687: END OPERAND;
688:
689: FUNCTION DISCOUNT_LINE
690: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
691: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
692: , x_on_operation_action OUT NOCOPY NUMBER
693:
694: ) RETURN NUMBER

Line 715: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

711: END DISCOUNT_LINE;
712:
713:
714: FUNCTION HEADER
715: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
716: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
717: , x_on_operation_action OUT NOCOPY NUMBER
718:
719: ) RETURN NUMBER

Line 740: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

736: END HEADER;
737:
738:
739: FUNCTION LAST_UPDATED_BY
740: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
741: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
742: , x_on_operation_action OUT NOCOPY NUMBER
743:
744: ) RETURN NUMBER

Line 765: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

761: END LAST_UPDATED_BY;
762:
763:
764: FUNCTION LAST_UPDATE_DATE
765: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
766: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
767: , x_on_operation_action OUT NOCOPY NUMBER
768:
769: ) RETURN NUMBER

Line 790: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

786: END LAST_UPDATE_DATE;
787:
788:
789: FUNCTION LAST_UPDATE_LOGIN
790: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
791: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
792: , x_on_operation_action OUT NOCOPY NUMBER
793:
794: ) RETURN NUMBER

Line 815: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

811: END LAST_UPDATE_LOGIN;
812:
813:
814: FUNCTION LINE
815: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
816: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
817: , x_on_operation_action OUT NOCOPY NUMBER
818:
819: ) RETURN NUMBER

Line 840: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

836: END LINE;
837:
838:
839: FUNCTION PERCENT
840: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
841: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
842: , x_on_operation_action OUT NOCOPY NUMBER
843:
844: ) RETURN NUMBER

Line 865: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

861: END PERCENT;
862:
863:
864: FUNCTION PRICE_ADJUSTMENT
865: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
866: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
867: , x_on_operation_action OUT NOCOPY NUMBER
868:
869: ) RETURN NUMBER

Line 890: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

886: END PRICE_ADJUSTMENT;
887:
888:
889: FUNCTION PROGRAM_APPLICATION
890: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
891: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
892: , x_on_operation_action OUT NOCOPY NUMBER
893:
894: ) RETURN NUMBER

Line 915: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

911: END PROGRAM_APPLICATION;
912:
913:
914: FUNCTION PROGRAM
915: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
916: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
917: , x_on_operation_action OUT NOCOPY NUMBER
918:
919: ) RETURN NUMBER

Line 940: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

936: END PROGRAM;
937:
938:
939: FUNCTION PROGRAM_UPDATE_DATE
940: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
941: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
942: , x_on_operation_action OUT NOCOPY NUMBER
943:
944: ) RETURN NUMBER

Line 965: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

961: END PROGRAM_UPDATE_DATE;
962:
963:
964: FUNCTION REQUEST
965: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
966: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
967: , x_on_operation_action OUT NOCOPY NUMBER
968:
969: ) RETURN NUMBER

Line 990: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

986: END REQUEST;
987:
988:
989: FUNCTION list_header
990: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
991: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
992: , x_on_operation_action OUT NOCOPY NUMBER
993:
994: ) RETURN NUMBER

Line 1014: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1010:
1011: END list_header;
1012:
1013: FUNCTION list_line
1014: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1015: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
1016: , x_on_operation_action OUT NOCOPY NUMBER
1017:
1018: ) RETURN NUMBER

Line 1038: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1034:
1035: END list_line;
1036:
1037: FUNCTION line_type_code
1038: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1039: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
1040: , x_on_operation_action OUT NOCOPY NUMBER
1041:
1042: ) RETURN NUMBER

Line 1062: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1058:
1059: END line_type_code;
1060:
1061: FUNCTION modifier_mechanism
1062: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1063: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
1064: , x_on_operation_action OUT NOCOPY NUMBER
1065:
1066: ) RETURN NUMBER

Line 1086: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1082:
1083: END modifier_mechanism;
1084:
1085: FUNCTION modified_from
1086: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1087: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
1088: , x_on_operation_action OUT NOCOPY NUMBER
1089:
1090: ) RETURN NUMBER

Line 1110: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1106:
1107: END modified_from;
1108:
1109: FUNCTION modified_to
1110: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1111: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
1112: , x_on_operation_action OUT NOCOPY NUMBER
1113:
1114: ) RETURN NUMBER

Line 1134: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1130:
1131: END modified_to;
1132:
1133: FUNCTION updated_flag
1134: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1135: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
1136: , x_on_operation_action OUT NOCOPY NUMBER
1137:
1138: ) RETURN NUMBER

Line 1158: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1154:
1155: END updated_flag;
1156:
1157: FUNCTION update_allowed
1158: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1159: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
1160: , x_on_operation_action OUT NOCOPY NUMBER
1161:
1162: ) RETURN NUMBER

Line 1182: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1178:
1179: END update_allowed;
1180:
1181: FUNCTION applied_flag
1182: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1183: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
1184: , x_on_operation_action OUT NOCOPY NUMBER
1185:
1186: ) RETURN NUMBER

Line 1206: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1202:
1203: END applied_flag;
1204:
1205: FUNCTION change_code
1206: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1207: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
1208: , x_on_operation_action OUT NOCOPY NUMBER
1209:
1210: ) RETURN NUMBER

Line 1230: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1226:
1227: END change_code;
1228:
1229: FUNCTION change_text
1230: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1231: , p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
1232: , x_on_operation_action OUT NOCOPY NUMBER
1233:
1234: ) RETURN NUMBER

Line 1276: l_operation := OE_PC_GLOBALS.CREATE_OP;

1272: -- Initializing return status to SUCCESS
1273: x_return_status := FND_API.G_RET_STS_SUCCESS;
1274:
1275: IF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1276: l_operation := OE_PC_GLOBALS.CREATE_OP;
1277: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1278: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1279: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1280: l_operation := OE_PC_GLOBALS.DELETE_OP;

Line 1278: l_operation := OE_PC_GLOBALS.UPDATE_OP;

1274:
1275: IF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1276: l_operation := OE_PC_GLOBALS.CREATE_OP;
1277: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1278: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1279: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1280: l_operation := OE_PC_GLOBALS.DELETE_OP;
1281: ELSE
1282: IF l_debug_level > 0 THEN

Line 1280: l_operation := OE_PC_GLOBALS.DELETE_OP;

1276: l_operation := OE_PC_GLOBALS.CREATE_OP;
1277: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1278: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1279: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1280: l_operation := OE_PC_GLOBALS.DELETE_OP;
1281: ELSE
1282: IF l_debug_level > 0 THEN
1283: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1284: END IF;

Line 1343: x_result := OE_PC_GLOBALS.NO;

1339: -- Initializing return status to SUCCESS
1340: x_return_status := FND_API.G_RET_STS_SUCCESS;
1341:
1342: -- Initializing out result to NOT CONSTRAINED
1343: x_result := OE_PC_GLOBALS.NO;
1344:
1345: -- Get the operation code to be passed to the security framework API
1346: IF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1347: l_operation := OE_PC_GLOBALS.CREATE_OP;

Line 1347: l_operation := OE_PC_GLOBALS.CREATE_OP;

1343: x_result := OE_PC_GLOBALS.NO;
1344:
1345: -- Get the operation code to be passed to the security framework API
1346: IF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1347: l_operation := OE_PC_GLOBALS.CREATE_OP;
1348: -- Bug 1755817: if there are no attribute-specific insert
1349: -- constraints, then no need to go further. Entity level
1350: -- security check for CREATE will be called again from
1351: -- process order after defaulting.

Line 1353: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_ADJ

1349: -- constraints, then no need to go further. Entity level
1350: -- security check for CREATE will be called again from
1351: -- process order after defaulting.
1352: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
1353: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_ADJ
1354: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
1355: ,p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
1356: )
1357: THEN

Line 1361: l_operation := OE_PC_GLOBALS.UPDATE_OP;

1357: THEN
1358: RETURN;
1359: END IF;
1360: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1361: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1362: ELSE
1363: IF l_debug_level > 0 THEN
1364: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1365: END IF;

Line 1389: x_result := Is_OP_constrained ( p_operation => OE_PC_GLOBALS.DELETE_OP

1385: --Automatic modifiers are not deleted, instead they are unapplied
1386: --That is, when deleted, applied_flag is updated as 'N'.
1387: --The operation code remains UPDATE in this case instead of DELETE so
1388: --this code is exclusively added for this case.
1389: x_result := Is_OP_constrained ( p_operation => OE_PC_GLOBALS.DELETE_OP
1390: , p_record => l_rowtype_rec
1391: , x_on_operation_action => l_on_operation_action
1392: );
1393: IF l_result = OE_PC_GLOBALS.YES THEN

Line 1393: IF l_result = OE_PC_GLOBALS.YES THEN

1389: x_result := Is_OP_constrained ( p_operation => OE_PC_GLOBALS.DELETE_OP
1390: , p_record => l_rowtype_rec
1391: , x_on_operation_action => l_on_operation_action
1392: );
1393: IF l_result = OE_PC_GLOBALS.YES THEN
1394: x_result := OE_PC_GLOBALS.YES;
1395: END IF;
1396: END IF;
1397: END IF;

Line 1394: x_result := OE_PC_GLOBALS.YES;

1390: , p_record => l_rowtype_rec
1391: , x_on_operation_action => l_on_operation_action
1392: );
1393: IF l_result = OE_PC_GLOBALS.YES THEN
1394: x_result := OE_PC_GLOBALS.YES;
1395: END IF;
1396: END IF;
1397: END IF;
1398: --Bug 9323560 ends

Line 1413: IF l_result = OE_PC_GLOBALS.YES THEN

1409: ,p_record => l_rowtype_rec
1410: ,x_on_operation_action => l_on_operation_action
1411: );
1412:
1413: IF l_result = OE_PC_GLOBALS.YES THEN
1414: -- set OUT result to CONSTRAINED
1415: x_result := OE_PC_GLOBALS.YES;
1416: END IF;
1417:

Line 1415: x_result := OE_PC_GLOBALS.YES;

1411: );
1412:
1413: IF l_result = OE_PC_GLOBALS.YES THEN
1414: -- set OUT result to CONSTRAINED
1415: x_result := OE_PC_GLOBALS.YES;
1416: END IF;
1417:
1418: END IF;
1419:

Line 1429: IF l_result = OE_PC_GLOBALS.YES THEN

1425: ,p_record => l_rowtype_rec
1426: ,x_on_operation_action => l_on_operation_action
1427: );
1428:
1429: IF l_result = OE_PC_GLOBALS.YES THEN
1430: -- set OUT result to CONSTRAINED
1431: x_result := OE_PC_GLOBALS.YES;
1432: END IF;
1433:

Line 1431: x_result := OE_PC_GLOBALS.YES;

1427: );
1428:
1429: IF l_result = OE_PC_GLOBALS.YES THEN
1430: -- set OUT result to CONSTRAINED
1431: x_result := OE_PC_GLOBALS.YES;
1432: END IF;
1433:
1434: END IF;
1435:

Line 1445: IF l_result = OE_PC_GLOBALS.YES THEN

1441: ,p_record => l_rowtype_rec
1442: ,x_on_operation_action => l_on_operation_action
1443: );
1444:
1445: IF l_result = OE_PC_GLOBALS.YES THEN
1446: -- set OUT result to CONSTRAINED
1447: x_result := OE_PC_GLOBALS.YES;
1448: END IF;
1449:

Line 1447: x_result := OE_PC_GLOBALS.YES;

1443: );
1444:
1445: IF l_result = OE_PC_GLOBALS.YES THEN
1446: -- set OUT result to CONSTRAINED
1447: x_result := OE_PC_GLOBALS.YES;
1448: END IF;
1449:
1450: END IF;
1451:

Line 1461: IF l_result = OE_PC_GLOBALS.YES THEN

1457: ,p_record => l_rowtype_rec
1458: ,x_on_operation_action => l_on_operation_action
1459: );
1460:
1461: IF l_result = OE_PC_GLOBALS.YES THEN
1462: -- set OUT result to CONSTRAINED
1463: x_result := OE_PC_GLOBALS.YES;
1464: END IF;
1465:

Line 1463: x_result := OE_PC_GLOBALS.YES;

1459: );
1460:
1461: IF l_result = OE_PC_GLOBALS.YES THEN
1462: -- set OUT result to CONSTRAINED
1463: x_result := OE_PC_GLOBALS.YES;
1464: END IF;
1465:
1466: END IF;
1467:

Line 1477: IF l_result = OE_PC_GLOBALS.YES THEN

1473: ,p_record => l_rowtype_rec
1474: ,x_on_operation_action => l_on_operation_action
1475: );
1476:
1477: IF l_result = OE_PC_GLOBALS.YES THEN
1478: -- set OUT result to CONSTRAINED
1479: x_result := OE_PC_GLOBALS.YES;
1480: END IF;
1481:

Line 1479: x_result := OE_PC_GLOBALS.YES;

1475: );
1476:
1477: IF l_result = OE_PC_GLOBALS.YES THEN
1478: -- set OUT result to CONSTRAINED
1479: x_result := OE_PC_GLOBALS.YES;
1480: END IF;
1481:
1482: END IF;
1483:

Line 1493: IF l_result = OE_PC_GLOBALS.YES THEN

1489: ,p_record => l_rowtype_rec
1490: ,x_on_operation_action => l_on_operation_action
1491: );
1492:
1493: IF l_result = OE_PC_GLOBALS.YES THEN
1494: -- set OUT result to CONSTRAINED
1495: x_result := OE_PC_GLOBALS.YES;
1496: END IF;
1497:

Line 1495: x_result := OE_PC_GLOBALS.YES;

1491: );
1492:
1493: IF l_result = OE_PC_GLOBALS.YES THEN
1494: -- set OUT result to CONSTRAINED
1495: x_result := OE_PC_GLOBALS.YES;
1496: END IF;
1497:
1498: END IF;
1499:

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

1508: -- updated and profile was set to 'N', global at the end should
1509: -- be re-set to 'Y' - this indicates to process order that no
1510: -- constrainable attributes were updated and thus, it would
1511: -- suppress entity level security check also.
1512: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1513: l_check_all_cols_constraint := g_check_all_cols_constraint;
1514: g_check_all_cols_constraint := 'N';
1515: END IF;
1516:

Line 1526: IF l_result = OE_PC_GLOBALS.YES THEN

1522: ,p_record => l_rowtype_rec
1523: ,x_on_operation_action => l_on_operation_action
1524: );
1525:
1526: IF l_result = OE_PC_GLOBALS.YES THEN
1527: -- set OUT result to CONSTRAINED
1528: x_result := OE_PC_GLOBALS.YES;
1529: END IF;
1530:

Line 1528: x_result := OE_PC_GLOBALS.YES;

1524: );
1525:
1526: IF l_result = OE_PC_GLOBALS.YES THEN
1527: -- set OUT result to CONSTRAINED
1528: x_result := OE_PC_GLOBALS.YES;
1529: END IF;
1530:
1531: END IF;
1532:

Line 1542: IF l_result = OE_PC_GLOBALS.YES THEN

1538: ,p_record => l_rowtype_rec
1539: ,x_on_operation_action => l_on_operation_action
1540: );
1541:
1542: IF l_result = OE_PC_GLOBALS.YES THEN
1543: -- set OUT result to CONSTRAINED
1544: x_result := OE_PC_GLOBALS.YES;
1545: END IF;
1546:

Line 1544: x_result := OE_PC_GLOBALS.YES;

1540: );
1541:
1542: IF l_result = OE_PC_GLOBALS.YES THEN
1543: -- set OUT result to CONSTRAINED
1544: x_result := OE_PC_GLOBALS.YES;
1545: END IF;
1546:
1547: END IF;
1548:

Line 1558: IF l_result = OE_PC_GLOBALS.YES THEN

1554: ,p_record => l_rowtype_rec
1555: ,x_on_operation_action => l_on_operation_action
1556: );
1557:
1558: IF l_result = OE_PC_GLOBALS.YES THEN
1559: -- set OUT result to CONSTRAINED
1560: x_result := OE_PC_GLOBALS.YES;
1561: END IF;
1562:

Line 1560: x_result := OE_PC_GLOBALS.YES;

1556: );
1557:
1558: IF l_result = OE_PC_GLOBALS.YES THEN
1559: -- set OUT result to CONSTRAINED
1560: x_result := OE_PC_GLOBALS.YES;
1561: END IF;
1562:
1563: END IF;
1564:

Line 1574: IF l_result = OE_PC_GLOBALS.YES THEN

1570: ,p_record => l_rowtype_rec
1571: ,x_on_operation_action => l_on_operation_action
1572: );
1573:
1574: IF l_result = OE_PC_GLOBALS.YES THEN
1575: -- set OUT result to CONSTRAINED
1576: x_result := OE_PC_GLOBALS.YES;
1577: END IF;
1578:

Line 1576: x_result := OE_PC_GLOBALS.YES;

1572: );
1573:
1574: IF l_result = OE_PC_GLOBALS.YES THEN
1575: -- set OUT result to CONSTRAINED
1576: x_result := OE_PC_GLOBALS.YES;
1577: END IF;
1578:
1579: END IF;
1580:

Line 1590: IF l_result = OE_PC_GLOBALS.YES THEN

1586: ,p_record => l_rowtype_rec
1587: ,x_on_operation_action => l_on_operation_action
1588: );
1589:
1590: IF l_result = OE_PC_GLOBALS.YES THEN
1591: -- set OUT result to CONSTRAINED
1592: x_result := OE_PC_GLOBALS.YES;
1593: END IF;
1594:

Line 1592: x_result := OE_PC_GLOBALS.YES;

1588: );
1589:
1590: IF l_result = OE_PC_GLOBALS.YES THEN
1591: -- set OUT result to CONSTRAINED
1592: x_result := OE_PC_GLOBALS.YES;
1593: END IF;
1594:
1595: END IF;
1596:

Line 1606: IF l_result = OE_PC_GLOBALS.YES THEN

1602: ,p_record => l_rowtype_rec
1603: ,x_on_operation_action => l_on_operation_action
1604: );
1605:
1606: IF l_result = OE_PC_GLOBALS.YES THEN
1607: -- set OUT result to CONSTRAINED
1608: x_result := OE_PC_GLOBALS.YES;
1609: END IF;
1610:

Line 1608: x_result := OE_PC_GLOBALS.YES;

1604: );
1605:
1606: IF l_result = OE_PC_GLOBALS.YES THEN
1607: -- set OUT result to CONSTRAINED
1608: x_result := OE_PC_GLOBALS.YES;
1609: END IF;
1610:
1611: END IF;
1612:

Line 1622: IF l_result = OE_PC_GLOBALS.YES THEN

1618: ,p_record => l_rowtype_rec
1619: ,x_on_operation_action => l_on_operation_action
1620: );
1621:
1622: IF l_result = OE_PC_GLOBALS.YES THEN
1623: -- set OUT result to CONSTRAINED
1624: x_result := OE_PC_GLOBALS.YES;
1625: END IF;
1626:

Line 1624: x_result := OE_PC_GLOBALS.YES;

1620: );
1621:
1622: IF l_result = OE_PC_GLOBALS.YES THEN
1623: -- set OUT result to CONSTRAINED
1624: x_result := OE_PC_GLOBALS.YES;
1625: END IF;
1626:
1627: END IF;
1628:

Line 1638: IF l_result = OE_PC_GLOBALS.YES THEN

1634: ,p_record => l_rowtype_rec
1635: ,x_on_operation_action => l_on_operation_action
1636: );
1637:
1638: IF l_result = OE_PC_GLOBALS.YES THEN
1639: -- set OUT result to CONSTRAINED
1640: x_result := OE_PC_GLOBALS.YES;
1641: END IF;
1642:

Line 1640: x_result := OE_PC_GLOBALS.YES;

1636: );
1637:
1638: IF l_result = OE_PC_GLOBALS.YES THEN
1639: -- set OUT result to CONSTRAINED
1640: x_result := OE_PC_GLOBALS.YES;
1641: END IF;
1642:
1643: END IF;
1644:

Line 1654: IF l_result = OE_PC_GLOBALS.YES THEN

1650: ,p_record => l_rowtype_rec
1651: ,x_on_operation_action => l_on_operation_action
1652: );
1653:
1654: IF l_result = OE_PC_GLOBALS.YES THEN
1655: -- set OUT result to CONSTRAINED
1656: x_result := OE_PC_GLOBALS.YES;
1657: END IF;
1658:

Line 1656: x_result := OE_PC_GLOBALS.YES;

1652: );
1653:
1654: IF l_result = OE_PC_GLOBALS.YES THEN
1655: -- set OUT result to CONSTRAINED
1656: x_result := OE_PC_GLOBALS.YES;
1657: END IF;
1658:
1659: END IF;
1660:

Line 1670: IF l_result = OE_PC_GLOBALS.YES THEN

1666: ,p_record => l_rowtype_rec
1667: ,x_on_operation_action => l_on_operation_action
1668: );
1669:
1670: IF l_result = OE_PC_GLOBALS.YES THEN
1671: -- set OUT result to CONSTRAINED
1672: x_result := OE_PC_GLOBALS.YES;
1673: END IF;
1674:

Line 1672: x_result := OE_PC_GLOBALS.YES;

1668: );
1669:
1670: IF l_result = OE_PC_GLOBALS.YES THEN
1671: -- set OUT result to CONSTRAINED
1672: x_result := OE_PC_GLOBALS.YES;
1673: END IF;
1674:
1675: END IF;
1676:

Line 1686: IF l_result = OE_PC_GLOBALS.YES THEN

1682: ,p_record => l_rowtype_rec
1683: ,x_on_operation_action => l_on_operation_action
1684: );
1685:
1686: IF l_result = OE_PC_GLOBALS.YES THEN
1687: -- set OUT result to CONSTRAINED
1688: x_result := OE_PC_GLOBALS.YES;
1689: END IF;
1690:

Line 1688: x_result := OE_PC_GLOBALS.YES;

1684: );
1685:
1686: IF l_result = OE_PC_GLOBALS.YES THEN
1687: -- set OUT result to CONSTRAINED
1688: x_result := OE_PC_GLOBALS.YES;
1689: END IF;
1690:
1691: END IF;
1692:

Line 1702: IF l_result = OE_PC_GLOBALS.YES THEN

1698: ,p_record => l_rowtype_rec
1699: ,x_on_operation_action => l_on_operation_action
1700: );
1701:
1702: IF l_result = OE_PC_GLOBALS.YES THEN
1703: -- set OUT result to CONSTRAINED
1704: x_result := OE_PC_GLOBALS.YES;
1705: END IF;
1706:

Line 1704: x_result := OE_PC_GLOBALS.YES;

1700: );
1701:
1702: IF l_result = OE_PC_GLOBALS.YES THEN
1703: -- set OUT result to CONSTRAINED
1704: x_result := OE_PC_GLOBALS.YES;
1705: END IF;
1706:
1707: END IF;
1708:

Line 1718: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1720: x_result := OE_PC_GLOBALS.YES;

1716: );
1717:
1718: IF l_result = OE_PC_GLOBALS.YES THEN
1719: -- set OUT result to CONSTRAINED
1720: x_result := OE_PC_GLOBALS.YES;
1721: END IF;
1722:
1723: END IF;
1724:

Line 1734: IF l_result = OE_PC_GLOBALS.YES THEN

1730: ,p_record => l_rowtype_rec
1731: ,x_on_operation_action => l_on_operation_action
1732: );
1733:
1734: IF l_result = OE_PC_GLOBALS.YES THEN
1735: -- set OUT result to CONSTRAINED
1736: x_result := OE_PC_GLOBALS.YES;
1737: END IF;
1738:

Line 1736: x_result := OE_PC_GLOBALS.YES;

1732: );
1733:
1734: IF l_result = OE_PC_GLOBALS.YES THEN
1735: -- set OUT result to CONSTRAINED
1736: x_result := OE_PC_GLOBALS.YES;
1737: END IF;
1738:
1739: END IF;
1740:

Line 1750: IF l_result = OE_PC_GLOBALS.YES THEN

1746: ,p_record => l_rowtype_rec
1747: ,x_on_operation_action => l_on_operation_action
1748: );
1749:
1750: IF l_result = OE_PC_GLOBALS.YES THEN
1751: -- set OUT result to CONSTRAINED
1752: x_result := OE_PC_GLOBALS.YES;
1753: END IF;
1754:

Line 1752: x_result := OE_PC_GLOBALS.YES;

1748: );
1749:
1750: IF l_result = OE_PC_GLOBALS.YES THEN
1751: -- set OUT result to CONSTRAINED
1752: x_result := OE_PC_GLOBALS.YES;
1753: END IF;
1754:
1755: END IF;
1756:

Line 1766: IF l_result = OE_PC_GLOBALS.YES THEN

1762: ,p_record => l_rowtype_rec
1763: ,x_on_operation_action => l_on_operation_action
1764: );
1765:
1766: IF l_result = OE_PC_GLOBALS.YES THEN
1767: -- set OUT result to CONSTRAINED
1768: x_result := OE_PC_GLOBALS.YES;
1769: END IF;
1770:

Line 1768: x_result := OE_PC_GLOBALS.YES;

1764: );
1765:
1766: IF l_result = OE_PC_GLOBALS.YES THEN
1767: -- set OUT result to CONSTRAINED
1768: x_result := OE_PC_GLOBALS.YES;
1769: END IF;
1770:
1771: END IF;
1772:

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

1769: END IF;
1770:
1771: END IF;
1772:
1773: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1774: IF l_debug_level > 0 THEN
1775: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1776: END IF;
1777: g_check_all_cols_constraint := l_check_all_cols_constraint;