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

Line 47: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE_ADJ

43: ( p_responsibility_id => nvl(fnd_global.resp_id, -1)
44: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
45: , p_operation => p_operation
46: , p_qualifier_attribute => l_transaction_phase_code
47: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE_ADJ
48: , p_column_name => p_column_name
49: , p_check_all_cols_constraint => g_check_all_cols_constraint
50: , p_is_caller_defaulting => g_is_caller_defaulting
51: , x_constraint_id => l_constraint_id

Line 56: if l_result = OE_PC_GLOBALS.YES then

52: , x_constraining_conditions_grp => l_grp
53: , x_on_operation_action => x_on_operation_action
54: );
55:
56: if l_result = OE_PC_GLOBALS.YES then
57:
58: IF g_check_all_cols_constraint = 'Y'
59: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
60: OR p_operation = OE_PC_GLOBALS.CREATE_OP)

Line 59: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP

55:
56: if l_result = OE_PC_GLOBALS.YES then
57:
58: IF g_check_all_cols_constraint = 'Y'
59: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
60: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
61: AND x_on_operation_action = 0
62: AND p_column_name IS NOT NULL THEN
63: SELECT column_name

Line 60: OR p_operation = OE_PC_GLOBALS.CREATE_OP)

56: if l_result = OE_PC_GLOBALS.YES then
57:
58: IF g_check_all_cols_constraint = 'Y'
59: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
60: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
61: AND x_on_operation_action = 0
62: AND p_column_name IS NOT NULL THEN
63: SELECT column_name
64: INTO l_constrained_column

Line 72: elsif l_result = OE_PC_GLOBALS.ERROR then

68: RAISE FND_API.G_EXC_ERROR;
69: end if;
70: END IF;
71:
72: elsif l_result = OE_PC_GLOBALS.ERROR then
73:
74: raise FND_API.G_EXC_UNEXPECTED_ERROR;
75:
76: end if;

Line 101: IF l_result = OE_PC_GLOBALS.YES THEN

97: OPEN IS_ORDER_BOOKED (p_record.header_id);
98: FETCH IS_ORDER_BOOKED INTO l_order_booked_flag;
99: CLOSE IS_ORDER_BOOKED;
100: IF l_order_booked_flag = 'Y' THEN
101: IF l_result = OE_PC_GLOBALS.YES THEN
102: IF x_on_operation_action = 1 THEN
103: -- set OUT result to NOT CONSTRAINED
104: IF l_debug_level > 0 THEN
105: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;

Line 121: IF l_result = OE_PC_GLOBALS.YES THEN

117: END IF;
118: END IF;
119: END IF;
120: ELSE -- capture audit trail for all orders
121: IF l_result = OE_PC_GLOBALS.YES THEN
122: IF x_on_operation_action = 1 THEN
123: -- set OUT result to NOT CONSTRAINED
124: IF l_debug_level > 0 THEN
125: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;

Line 144: l_result := OE_PC_GLOBALS.NO;

140: END IF;
141: END IF;
142: /* End AuditTrail */
143: IF x_on_operation_action > 0 THEN
144: l_result := OE_PC_GLOBALS.NO;
145: END IF;
146:
147: RETURN l_result;
148:

Line 156: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

152: -- PUBLIC PROCEDURES
153:
154:
155: FUNCTION ATTRIBUTE1
156: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
157: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
158: , x_on_operation_action OUT NOCOPY NUMBER
159:
160: ) RETURN NUMBER

Line 181: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

177: END ATTRIBUTE1;
178:
179:
180: FUNCTION ATTRIBUTE10
181: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
182: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
183: , x_on_operation_action OUT NOCOPY NUMBER
184:
185: ) RETURN NUMBER

Line 206: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

202: END ATTRIBUTE10;
203:
204:
205: FUNCTION ATTRIBUTE11
206: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
207: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
208: , x_on_operation_action OUT NOCOPY NUMBER
209:
210: ) RETURN NUMBER

Line 231: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

227: END ATTRIBUTE11;
228:
229:
230: FUNCTION ATTRIBUTE12
231: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
232: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
233: , x_on_operation_action OUT NOCOPY NUMBER
234:
235: ) RETURN NUMBER

Line 256: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

252: END ATTRIBUTE12;
253:
254:
255: FUNCTION ATTRIBUTE13
256: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
257: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
258: , x_on_operation_action OUT NOCOPY NUMBER
259:
260: ) RETURN NUMBER

Line 281: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

277: END ATTRIBUTE13;
278:
279:
280: FUNCTION ATTRIBUTE14
281: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
282: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
283: , x_on_operation_action OUT NOCOPY NUMBER
284:
285: ) RETURN NUMBER

Line 306: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

302: END ATTRIBUTE14;
303:
304:
305: FUNCTION ATTRIBUTE15
306: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
307: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
308: , x_on_operation_action OUT NOCOPY NUMBER
309:
310: ) RETURN NUMBER

Line 331: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

327: END ATTRIBUTE15;
328:
329:
330: FUNCTION ATTRIBUTE2
331: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
332: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
333: , x_on_operation_action OUT NOCOPY NUMBER
334:
335: ) RETURN NUMBER

Line 356: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

352: END ATTRIBUTE2;
353:
354:
355: FUNCTION ATTRIBUTE3
356: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
357: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
358: , x_on_operation_action OUT NOCOPY NUMBER
359:
360: ) RETURN NUMBER

Line 381: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

377: END ATTRIBUTE3;
378:
379:
380: FUNCTION ATTRIBUTE4
381: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
382: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
383: , x_on_operation_action OUT NOCOPY NUMBER
384:
385: ) RETURN NUMBER

Line 406: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

402: END ATTRIBUTE4;
403:
404:
405: FUNCTION ATTRIBUTE5
406: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
407: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
408: , x_on_operation_action OUT NOCOPY NUMBER
409:
410: ) RETURN NUMBER

Line 431: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

427: END ATTRIBUTE5;
428:
429:
430: FUNCTION ATTRIBUTE6
431: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
432: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
433: , x_on_operation_action OUT NOCOPY NUMBER
434:
435: ) RETURN NUMBER

Line 456: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

452: END ATTRIBUTE6;
453:
454:
455: FUNCTION ATTRIBUTE7
456: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
457: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
458: , x_on_operation_action OUT NOCOPY NUMBER
459:
460: ) RETURN NUMBER

Line 481: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

477: END ATTRIBUTE7;
478:
479:
480: FUNCTION ATTRIBUTE8
481: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
482: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
483: , x_on_operation_action OUT NOCOPY NUMBER
484:
485: ) RETURN NUMBER

Line 506: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

502: END ATTRIBUTE8;
503:
504:
505: FUNCTION ATTRIBUTE9
506: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
507: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
508: , x_on_operation_action OUT NOCOPY NUMBER
509:
510: ) RETURN NUMBER

Line 531: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

527: END ATTRIBUTE9;
528:
529:
530: FUNCTION AUTOMATIC
531: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
532: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
533: , x_on_operation_action OUT NOCOPY NUMBER
534:
535: ) RETURN NUMBER

Line 556: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

552: END AUTOMATIC;
553:
554:
555: FUNCTION CONTEXT
556: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
557: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
558: , x_on_operation_action OUT NOCOPY NUMBER
559:
560: ) RETURN NUMBER

Line 581: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

577: END CONTEXT;
578:
579:
580: FUNCTION CREATED_BY
581: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
582: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
583: , x_on_operation_action OUT NOCOPY NUMBER
584:
585: ) RETURN NUMBER

Line 606: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

602: END CREATED_BY;
603:
604:
605: FUNCTION CREATION_DATE
606: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
607: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
608: , x_on_operation_action OUT NOCOPY NUMBER
609:
610: ) RETURN NUMBER

Line 631: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

627: END CREATION_DATE;
628:
629:
630: FUNCTION DISCOUNT
631: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
632: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
633: , x_on_operation_action OUT NOCOPY NUMBER
634:
635: ) RETURN NUMBER

Line 655: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

651:
652: END DISCOUNT;
653:
654: FUNCTION OPERAND
655: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
656: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
657: , x_on_operation_action OUT NOCOPY NUMBER
658:
659: ) RETURN NUMBER

Line 679: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

675:
676: END OPERAND;
677:
678: FUNCTION DISCOUNT_LINE
679: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
680: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
681: , x_on_operation_action OUT NOCOPY NUMBER
682:
683: ) RETURN NUMBER

Line 704: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

700: END DISCOUNT_LINE;
701:
702:
703: FUNCTION HEADER
704: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
705: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
706: , x_on_operation_action OUT NOCOPY NUMBER
707:
708: ) RETURN NUMBER

Line 729: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

725: END HEADER;
726:
727:
728: FUNCTION LAST_UPDATED_BY
729: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
730: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
731: , x_on_operation_action OUT NOCOPY NUMBER
732:
733: ) RETURN NUMBER

Line 754: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

750: END LAST_UPDATED_BY;
751:
752:
753: FUNCTION LAST_UPDATE_DATE
754: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
755: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
756: , x_on_operation_action OUT NOCOPY NUMBER
757:
758: ) RETURN NUMBER

Line 779: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

775: END LAST_UPDATE_DATE;
776:
777:
778: FUNCTION LAST_UPDATE_LOGIN
779: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
780: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
781: , x_on_operation_action OUT NOCOPY NUMBER
782:
783: ) RETURN NUMBER

Line 804: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

800: END LAST_UPDATE_LOGIN;
801:
802:
803: FUNCTION LINE
804: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
805: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
806: , x_on_operation_action OUT NOCOPY NUMBER
807:
808: ) RETURN NUMBER

Line 829: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

825: END LINE;
826:
827:
828: FUNCTION PERCENT
829: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
830: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
831: , x_on_operation_action OUT NOCOPY NUMBER
832:
833: ) RETURN NUMBER

Line 854: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

850: END PERCENT;
851:
852:
853: FUNCTION PRICE_ADJUSTMENT
854: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
855: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
856: , x_on_operation_action OUT NOCOPY NUMBER
857:
858: ) RETURN NUMBER

Line 879: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

875: END PRICE_ADJUSTMENT;
876:
877:
878: FUNCTION PROGRAM_APPLICATION
879: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
880: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
881: , x_on_operation_action OUT NOCOPY NUMBER
882:
883: ) RETURN NUMBER

Line 904: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

900: END PROGRAM_APPLICATION;
901:
902:
903: FUNCTION PROGRAM
904: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
905: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
906: , x_on_operation_action OUT NOCOPY NUMBER
907:
908: ) RETURN NUMBER

Line 929: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

925: END PROGRAM;
926:
927:
928: FUNCTION PROGRAM_UPDATE_DATE
929: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
930: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
931: , x_on_operation_action OUT NOCOPY NUMBER
932:
933: ) RETURN NUMBER

Line 954: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

950: END PROGRAM_UPDATE_DATE;
951:
952:
953: FUNCTION REQUEST
954: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
955: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
956: , x_on_operation_action OUT NOCOPY NUMBER
957:
958: ) RETURN NUMBER

Line 978: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

974:
975: END REQUEST;
976:
977: FUNCTION list_header
978: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
979: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
980: , x_on_operation_action OUT NOCOPY NUMBER
981:
982: ) RETURN NUMBER

Line 1002: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

998:
999: END list_header;
1000:
1001: FUNCTION list_line
1002: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1003: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
1004: , x_on_operation_action OUT NOCOPY NUMBER
1005:
1006: ) RETURN NUMBER

Line 1026: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1022:
1023: END list_line;
1024:
1025: FUNCTION line_type_code
1026: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1027: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
1028: , x_on_operation_action OUT NOCOPY NUMBER
1029:
1030: ) RETURN NUMBER

Line 1050: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1046:
1047: END line_type_code;
1048:
1049: FUNCTION modifier_mechanism
1050: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1051: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
1052: , x_on_operation_action OUT NOCOPY NUMBER
1053:
1054: ) RETURN NUMBER

Line 1074: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1070:
1071: END modifier_mechanism;
1072:
1073: FUNCTION modified_from
1074: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1075: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
1076: , x_on_operation_action OUT NOCOPY NUMBER
1077:
1078: ) RETURN NUMBER

Line 1098: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1094:
1095: END modified_from;
1096:
1097: FUNCTION modified_to
1098: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1099: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
1100: , x_on_operation_action OUT NOCOPY NUMBER
1101:
1102: ) RETURN NUMBER

Line 1122: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1118:
1119: END modified_to;
1120:
1121: FUNCTION updated_flag
1122: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1123: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
1124: , x_on_operation_action OUT NOCOPY NUMBER
1125:
1126: ) RETURN NUMBER

Line 1146: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1142:
1143: END updated_flag;
1144:
1145: FUNCTION update_allowed
1146: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1147: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
1148: , x_on_operation_action OUT NOCOPY NUMBER
1149:
1150: ) RETURN NUMBER

Line 1170: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1166:
1167: END update_allowed;
1168:
1169: FUNCTION applied_flag
1170: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1171: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
1172: , x_on_operation_action OUT NOCOPY NUMBER
1173:
1174: ) RETURN NUMBER

Line 1194: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 1218: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

1214:
1215: END change_code;
1216:
1217: FUNCTION change_text
1218: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
1219: , p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
1220: , x_on_operation_action OUT NOCOPY NUMBER
1221:
1222: ) RETURN NUMBER

Line 1264: l_operation := OE_PC_GLOBALS.CREATE_OP;

1260: -- Initializing return status to SUCCESS
1261: x_return_status := FND_API.G_RET_STS_SUCCESS;
1262:
1263: IF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1264: l_operation := OE_PC_GLOBALS.CREATE_OP;
1265: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1266: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1267: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1268: l_operation := OE_PC_GLOBALS.DELETE_OP;

Line 1266: l_operation := OE_PC_GLOBALS.UPDATE_OP;

1262:
1263: IF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1264: l_operation := OE_PC_GLOBALS.CREATE_OP;
1265: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1266: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1267: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1268: l_operation := OE_PC_GLOBALS.DELETE_OP;
1269: ELSE
1270: IF l_debug_level > 0 THEN

Line 1268: l_operation := OE_PC_GLOBALS.DELETE_OP;

1264: l_operation := OE_PC_GLOBALS.CREATE_OP;
1265: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1266: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1267: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1268: l_operation := OE_PC_GLOBALS.DELETE_OP;
1269: ELSE
1270: IF l_debug_level > 0 THEN
1271: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1272: END IF;

Line 1332: x_result := OE_PC_GLOBALS.NO;

1328: -- Initializing return status to SUCCESS
1329: x_return_status := FND_API.G_RET_STS_SUCCESS;
1330:
1331: -- Initializing out result to NOT CONSTRAINED
1332: x_result := OE_PC_GLOBALS.NO;
1333:
1334: -- Get the operation code to be passed to the security framework API
1335: IF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1336: l_operation := OE_PC_GLOBALS.CREATE_OP;

Line 1336: l_operation := OE_PC_GLOBALS.CREATE_OP;

1332: x_result := OE_PC_GLOBALS.NO;
1333:
1334: -- Get the operation code to be passed to the security framework API
1335: IF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1336: l_operation := OE_PC_GLOBALS.CREATE_OP;
1337: -- Bug 1755817: if there are no attribute-specific insert
1338: -- constraints, then no need to go further. Entity level
1339: -- security check for CREATE will be called again from
1340: -- process order after defaulting.

Line 1342: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE_ADJ

1338: -- constraints, then no need to go further. Entity level
1339: -- security check for CREATE will be called again from
1340: -- process order after defaulting.
1341: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
1342: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE_ADJ
1343: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
1344: ,p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
1345: )
1346: THEN

Line 1350: l_operation := OE_PC_GLOBALS.UPDATE_OP;

1346: THEN
1347: RETURN;
1348: END IF;
1349: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1350: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1351: ELSE
1352: IF l_debug_level > 0 THEN
1353: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1354: END IF;

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

1375: --Automatic modifiers are not deleted, instead they are unapplied
1376: --That is, when deleted, applied_flag is updated as 'N'.
1377: --The operation code remains UPDATE in this case instead of DELETE so
1378: --this code is exclusively added for this case.
1379: x_result := Is_OP_constrained ( p_operation => OE_PC_GLOBALS.DELETE_OP
1380: , p_record => l_rowtype_rec
1381: , x_on_operation_action => l_on_operation_action
1382: );
1383: IF l_result = OE_PC_GLOBALS.YES THEN

Line 1383: IF l_result = OE_PC_GLOBALS.YES THEN

1379: x_result := Is_OP_constrained ( p_operation => OE_PC_GLOBALS.DELETE_OP
1380: , p_record => l_rowtype_rec
1381: , x_on_operation_action => l_on_operation_action
1382: );
1383: IF l_result = OE_PC_GLOBALS.YES THEN
1384: x_result := OE_PC_GLOBALS.YES;
1385: END IF;
1386: END IF;
1387: END IF;

Line 1384: x_result := OE_PC_GLOBALS.YES;

1380: , p_record => l_rowtype_rec
1381: , x_on_operation_action => l_on_operation_action
1382: );
1383: IF l_result = OE_PC_GLOBALS.YES THEN
1384: x_result := OE_PC_GLOBALS.YES;
1385: END IF;
1386: END IF;
1387: END IF;
1388: --Bug 9323560 ends

Line 1403: IF l_result = OE_PC_GLOBALS.YES THEN

1399: ,p_record => l_rowtype_rec
1400: ,x_on_operation_action => l_on_operation_action
1401: );
1402:
1403: IF l_result = OE_PC_GLOBALS.YES THEN
1404: -- set OUT result to CONSTRAINED
1405: x_result := OE_PC_GLOBALS.YES;
1406: END IF;
1407:

Line 1405: x_result := OE_PC_GLOBALS.YES;

1401: );
1402:
1403: IF l_result = OE_PC_GLOBALS.YES THEN
1404: -- set OUT result to CONSTRAINED
1405: x_result := OE_PC_GLOBALS.YES;
1406: END IF;
1407:
1408: END IF;
1409:

Line 1419: IF l_result = OE_PC_GLOBALS.YES THEN

1415: ,p_record => l_rowtype_rec
1416: ,x_on_operation_action => l_on_operation_action
1417: );
1418:
1419: IF l_result = OE_PC_GLOBALS.YES THEN
1420: -- set OUT result to CONSTRAINED
1421: x_result := OE_PC_GLOBALS.YES;
1422: END IF;
1423:

Line 1421: x_result := OE_PC_GLOBALS.YES;

1417: );
1418:
1419: IF l_result = OE_PC_GLOBALS.YES THEN
1420: -- set OUT result to CONSTRAINED
1421: x_result := OE_PC_GLOBALS.YES;
1422: END IF;
1423:
1424: END IF;
1425:

Line 1435: IF l_result = OE_PC_GLOBALS.YES THEN

1431: ,p_record => l_rowtype_rec
1432: ,x_on_operation_action => l_on_operation_action
1433: );
1434:
1435: IF l_result = OE_PC_GLOBALS.YES THEN
1436: -- set OUT result to CONSTRAINED
1437: x_result := OE_PC_GLOBALS.YES;
1438: END IF;
1439:

Line 1437: x_result := OE_PC_GLOBALS.YES;

1433: );
1434:
1435: IF l_result = OE_PC_GLOBALS.YES THEN
1436: -- set OUT result to CONSTRAINED
1437: x_result := OE_PC_GLOBALS.YES;
1438: END IF;
1439:
1440: END IF;
1441:

Line 1451: IF l_result = OE_PC_GLOBALS.YES THEN

1447: ,p_record => l_rowtype_rec
1448: ,x_on_operation_action => l_on_operation_action
1449: );
1450:
1451: IF l_result = OE_PC_GLOBALS.YES THEN
1452: -- set OUT result to CONSTRAINED
1453: x_result := OE_PC_GLOBALS.YES;
1454: END IF;
1455:

Line 1453: x_result := OE_PC_GLOBALS.YES;

1449: );
1450:
1451: IF l_result = OE_PC_GLOBALS.YES THEN
1452: -- set OUT result to CONSTRAINED
1453: x_result := OE_PC_GLOBALS.YES;
1454: END IF;
1455:
1456: END IF;
1457:

Line 1467: IF l_result = OE_PC_GLOBALS.YES THEN

1463: ,p_record => l_rowtype_rec
1464: ,x_on_operation_action => l_on_operation_action
1465: );
1466:
1467: IF l_result = OE_PC_GLOBALS.YES THEN
1468: -- set OUT result to CONSTRAINED
1469: x_result := OE_PC_GLOBALS.YES;
1470: END IF;
1471:

Line 1469: x_result := OE_PC_GLOBALS.YES;

1465: );
1466:
1467: IF l_result = OE_PC_GLOBALS.YES THEN
1468: -- set OUT result to CONSTRAINED
1469: x_result := OE_PC_GLOBALS.YES;
1470: END IF;
1471:
1472: END IF;
1473:

Line 1483: IF l_result = OE_PC_GLOBALS.YES THEN

1479: ,p_record => l_rowtype_rec
1480: ,x_on_operation_action => l_on_operation_action
1481: );
1482:
1483: IF l_result = OE_PC_GLOBALS.YES THEN
1484: -- set OUT result to CONSTRAINED
1485: x_result := OE_PC_GLOBALS.YES;
1486: END IF;
1487:

Line 1485: x_result := OE_PC_GLOBALS.YES;

1481: );
1482:
1483: IF l_result = OE_PC_GLOBALS.YES THEN
1484: -- set OUT result to CONSTRAINED
1485: x_result := OE_PC_GLOBALS.YES;
1486: END IF;
1487:
1488: END IF;
1489:

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

1497: -- updated and profile was set to 'N', global at the end should
1498: -- be re-set to 'Y' - this indicates to process order that no
1499: -- constrainable attributes were updated and thus, it would
1500: -- suppress entity level security check also.
1501: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1502: l_check_all_cols_constraint := g_check_all_cols_constraint;
1503: g_check_all_cols_constraint := 'N';
1504: END IF;
1505:

Line 1515: IF l_result = OE_PC_GLOBALS.YES THEN

1511: ,p_record => l_rowtype_rec
1512: ,x_on_operation_action => l_on_operation_action
1513: );
1514:
1515: IF l_result = OE_PC_GLOBALS.YES THEN
1516: -- set OUT result to CONSTRAINED
1517: x_result := OE_PC_GLOBALS.YES;
1518: END IF;
1519:

Line 1517: x_result := OE_PC_GLOBALS.YES;

1513: );
1514:
1515: IF l_result = OE_PC_GLOBALS.YES THEN
1516: -- set OUT result to CONSTRAINED
1517: x_result := OE_PC_GLOBALS.YES;
1518: END IF;
1519:
1520: END IF;
1521:

Line 1531: IF l_result = OE_PC_GLOBALS.YES THEN

1527: ,p_record => l_rowtype_rec
1528: ,x_on_operation_action => l_on_operation_action
1529: );
1530:
1531: IF l_result = OE_PC_GLOBALS.YES THEN
1532: -- set OUT result to CONSTRAINED
1533: x_result := OE_PC_GLOBALS.YES;
1534: END IF;
1535:

Line 1533: x_result := OE_PC_GLOBALS.YES;

1529: );
1530:
1531: IF l_result = OE_PC_GLOBALS.YES THEN
1532: -- set OUT result to CONSTRAINED
1533: x_result := OE_PC_GLOBALS.YES;
1534: END IF;
1535:
1536: END IF;
1537:

Line 1547: IF l_result = OE_PC_GLOBALS.YES THEN

1543: ,p_record => l_rowtype_rec
1544: ,x_on_operation_action => l_on_operation_action
1545: );
1546:
1547: IF l_result = OE_PC_GLOBALS.YES THEN
1548: -- set OUT result to CONSTRAINED
1549: x_result := OE_PC_GLOBALS.YES;
1550: END IF;
1551:

Line 1549: x_result := OE_PC_GLOBALS.YES;

1545: );
1546:
1547: IF l_result = OE_PC_GLOBALS.YES THEN
1548: -- set OUT result to CONSTRAINED
1549: x_result := OE_PC_GLOBALS.YES;
1550: END IF;
1551:
1552: END IF;
1553:

Line 1563: IF l_result = OE_PC_GLOBALS.YES THEN

1559: ,p_record => l_rowtype_rec
1560: ,x_on_operation_action => l_on_operation_action
1561: );
1562:
1563: IF l_result = OE_PC_GLOBALS.YES THEN
1564: -- set OUT result to CONSTRAINED
1565: x_result := OE_PC_GLOBALS.YES;
1566: END IF;
1567:

Line 1565: x_result := OE_PC_GLOBALS.YES;

1561: );
1562:
1563: IF l_result = OE_PC_GLOBALS.YES THEN
1564: -- set OUT result to CONSTRAINED
1565: x_result := OE_PC_GLOBALS.YES;
1566: END IF;
1567:
1568: END IF;
1569:

Line 1579: IF l_result = OE_PC_GLOBALS.YES THEN

1575: ,p_record => l_rowtype_rec
1576: ,x_on_operation_action => l_on_operation_action
1577: );
1578:
1579: IF l_result = OE_PC_GLOBALS.YES THEN
1580: -- set OUT result to CONSTRAINED
1581: x_result := OE_PC_GLOBALS.YES;
1582: END IF;
1583:

Line 1581: x_result := OE_PC_GLOBALS.YES;

1577: );
1578:
1579: IF l_result = OE_PC_GLOBALS.YES THEN
1580: -- set OUT result to CONSTRAINED
1581: x_result := OE_PC_GLOBALS.YES;
1582: END IF;
1583:
1584: END IF;
1585:

Line 1595: IF l_result = OE_PC_GLOBALS.YES THEN

1591: ,p_record => l_rowtype_rec
1592: ,x_on_operation_action => l_on_operation_action
1593: );
1594:
1595: IF l_result = OE_PC_GLOBALS.YES THEN
1596: -- set OUT result to CONSTRAINED
1597: x_result := OE_PC_GLOBALS.YES;
1598: END IF;
1599:

Line 1597: x_result := OE_PC_GLOBALS.YES;

1593: );
1594:
1595: IF l_result = OE_PC_GLOBALS.YES THEN
1596: -- set OUT result to CONSTRAINED
1597: x_result := OE_PC_GLOBALS.YES;
1598: END IF;
1599:
1600: END IF;
1601:

Line 1611: IF l_result = OE_PC_GLOBALS.YES THEN

1607: ,p_record => l_rowtype_rec
1608: ,x_on_operation_action => l_on_operation_action
1609: );
1610:
1611: IF l_result = OE_PC_GLOBALS.YES THEN
1612: -- set OUT result to CONSTRAINED
1613: x_result := OE_PC_GLOBALS.YES;
1614: END IF;
1615:

Line 1613: x_result := OE_PC_GLOBALS.YES;

1609: );
1610:
1611: IF l_result = OE_PC_GLOBALS.YES THEN
1612: -- set OUT result to CONSTRAINED
1613: x_result := OE_PC_GLOBALS.YES;
1614: END IF;
1615:
1616: END IF;
1617:

Line 1627: IF l_result = OE_PC_GLOBALS.YES THEN

1623: ,p_record => l_rowtype_rec
1624: ,x_on_operation_action => l_on_operation_action
1625: );
1626:
1627: IF l_result = OE_PC_GLOBALS.YES THEN
1628: -- set OUT result to CONSTRAINED
1629: x_result := OE_PC_GLOBALS.YES;
1630: END IF;
1631:

Line 1629: x_result := OE_PC_GLOBALS.YES;

1625: );
1626:
1627: IF l_result = OE_PC_GLOBALS.YES THEN
1628: -- set OUT result to CONSTRAINED
1629: x_result := OE_PC_GLOBALS.YES;
1630: END IF;
1631:
1632: END IF;
1633:

Line 1643: IF l_result = OE_PC_GLOBALS.YES THEN

1639: ,p_record => l_rowtype_rec
1640: ,x_on_operation_action => l_on_operation_action
1641: );
1642:
1643: IF l_result = OE_PC_GLOBALS.YES THEN
1644: -- set OUT result to CONSTRAINED
1645: x_result := OE_PC_GLOBALS.YES;
1646: END IF;
1647:

Line 1645: x_result := OE_PC_GLOBALS.YES;

1641: );
1642:
1643: IF l_result = OE_PC_GLOBALS.YES THEN
1644: -- set OUT result to CONSTRAINED
1645: x_result := OE_PC_GLOBALS.YES;
1646: END IF;
1647:
1648: END IF;
1649:

Line 1659: IF l_result = OE_PC_GLOBALS.YES THEN

1655: ,p_record => l_rowtype_rec
1656: ,x_on_operation_action => l_on_operation_action
1657: );
1658:
1659: IF l_result = OE_PC_GLOBALS.YES THEN
1660: -- set OUT result to CONSTRAINED
1661: x_result := OE_PC_GLOBALS.YES;
1662: END IF;
1663:

Line 1661: x_result := OE_PC_GLOBALS.YES;

1657: );
1658:
1659: IF l_result = OE_PC_GLOBALS.YES THEN
1660: -- set OUT result to CONSTRAINED
1661: x_result := OE_PC_GLOBALS.YES;
1662: END IF;
1663:
1664: END IF;
1665:

Line 1675: IF l_result = OE_PC_GLOBALS.YES THEN

1671: ,p_record => l_rowtype_rec
1672: ,x_on_operation_action => l_on_operation_action
1673: );
1674:
1675: IF l_result = OE_PC_GLOBALS.YES THEN
1676: -- set OUT result to CONSTRAINED
1677: x_result := OE_PC_GLOBALS.YES;
1678: END IF;
1679:

Line 1677: x_result := OE_PC_GLOBALS.YES;

1673: );
1674:
1675: IF l_result = OE_PC_GLOBALS.YES THEN
1676: -- set OUT result to CONSTRAINED
1677: x_result := OE_PC_GLOBALS.YES;
1678: END IF;
1679:
1680: END IF;
1681:

Line 1691: IF l_result = OE_PC_GLOBALS.YES THEN

1687: ,p_record => l_rowtype_rec
1688: ,x_on_operation_action => l_on_operation_action
1689: );
1690:
1691: IF l_result = OE_PC_GLOBALS.YES THEN
1692: -- set OUT result to CONSTRAINED
1693: x_result := OE_PC_GLOBALS.YES;
1694: END IF;
1695:

Line 1693: x_result := OE_PC_GLOBALS.YES;

1689: );
1690:
1691: IF l_result = OE_PC_GLOBALS.YES THEN
1692: -- set OUT result to CONSTRAINED
1693: x_result := OE_PC_GLOBALS.YES;
1694: END IF;
1695:
1696: END IF;
1697:

Line 1707: IF l_result = OE_PC_GLOBALS.YES THEN

1703: ,p_record => l_rowtype_rec
1704: ,x_on_operation_action => l_on_operation_action
1705: );
1706:
1707: IF l_result = OE_PC_GLOBALS.YES THEN
1708: -- set OUT result to CONSTRAINED
1709: x_result := OE_PC_GLOBALS.YES;
1710: END IF;
1711:

Line 1709: x_result := OE_PC_GLOBALS.YES;

1705: );
1706:
1707: IF l_result = OE_PC_GLOBALS.YES THEN
1708: -- set OUT result to CONSTRAINED
1709: x_result := OE_PC_GLOBALS.YES;
1710: END IF;
1711:
1712: END IF;
1713:

Line 1723: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1725: x_result := OE_PC_GLOBALS.YES;

1721: );
1722:
1723: IF l_result = OE_PC_GLOBALS.YES THEN
1724: -- set OUT result to CONSTRAINED
1725: x_result := OE_PC_GLOBALS.YES;
1726: END IF;
1727:
1728: END IF;
1729:

Line 1739: IF l_result = OE_PC_GLOBALS.YES THEN

1735: ,p_record => l_rowtype_rec
1736: ,x_on_operation_action => l_on_operation_action
1737: );
1738:
1739: IF l_result = OE_PC_GLOBALS.YES THEN
1740: -- set OUT result to CONSTRAINED
1741: x_result := OE_PC_GLOBALS.YES;
1742: END IF;
1743:

Line 1741: x_result := OE_PC_GLOBALS.YES;

1737: );
1738:
1739: IF l_result = OE_PC_GLOBALS.YES THEN
1740: -- set OUT result to CONSTRAINED
1741: x_result := OE_PC_GLOBALS.YES;
1742: END IF;
1743:
1744: END IF;
1745:

Line 1755: IF l_result = OE_PC_GLOBALS.YES THEN

1751: ,p_record => l_rowtype_rec
1752: ,x_on_operation_action => l_on_operation_action
1753: );
1754:
1755: IF l_result = OE_PC_GLOBALS.YES THEN
1756: -- set OUT result to CONSTRAINED
1757: x_result := OE_PC_GLOBALS.YES;
1758: END IF;
1759:

Line 1757: x_result := OE_PC_GLOBALS.YES;

1753: );
1754:
1755: IF l_result = OE_PC_GLOBALS.YES THEN
1756: -- set OUT result to CONSTRAINED
1757: x_result := OE_PC_GLOBALS.YES;
1758: END IF;
1759:
1760: END IF;
1761:

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

1758: END IF;
1759:
1760: END IF;
1761:
1762: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1763: IF l_debug_level > 0 THEN
1764: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1765: END IF;
1766: g_check_all_cols_constraint := l_check_all_cols_constraint;