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 1387: IF l_result = OE_PC_GLOBALS.YES THEN

1383: ,p_record => l_rowtype_rec
1384: ,x_on_operation_action => l_on_operation_action
1385: );
1386:
1387: IF l_result = OE_PC_GLOBALS.YES THEN
1388: -- set OUT result to CONSTRAINED
1389: x_result := OE_PC_GLOBALS.YES;
1390: END IF;
1391:

Line 1389: x_result := OE_PC_GLOBALS.YES;

1385: );
1386:
1387: IF l_result = OE_PC_GLOBALS.YES THEN
1388: -- set OUT result to CONSTRAINED
1389: x_result := OE_PC_GLOBALS.YES;
1390: END IF;
1391:
1392: END IF;
1393:

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 1486: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN

1482: -- updated and profile was set to 'N', global at the end should
1483: -- be re-set to 'Y' - this indicates to process order that no
1484: -- constrainable attributes were updated and thus, it would
1485: -- suppress entity level security check also.
1486: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1487: l_check_all_cols_constraint := g_check_all_cols_constraint;
1488: g_check_all_cols_constraint := 'N';
1489: END IF;
1490:

Line 1500: IF l_result = OE_PC_GLOBALS.YES THEN

1496: ,p_record => l_rowtype_rec
1497: ,x_on_operation_action => l_on_operation_action
1498: );
1499:
1500: IF l_result = OE_PC_GLOBALS.YES THEN
1501: -- set OUT result to CONSTRAINED
1502: x_result := OE_PC_GLOBALS.YES;
1503: END IF;
1504:

Line 1502: x_result := OE_PC_GLOBALS.YES;

1498: );
1499:
1500: IF l_result = OE_PC_GLOBALS.YES THEN
1501: -- set OUT result to CONSTRAINED
1502: x_result := OE_PC_GLOBALS.YES;
1503: END IF;
1504:
1505: END IF;
1506:

Line 1516: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1518: x_result := OE_PC_GLOBALS.YES;

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

Line 1532: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1534: x_result := OE_PC_GLOBALS.YES;

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

Line 1548: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1550: x_result := OE_PC_GLOBALS.YES;

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

Line 1564: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1566: x_result := OE_PC_GLOBALS.YES;

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

Line 1580: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1582: x_result := OE_PC_GLOBALS.YES;

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

Line 1596: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1598: x_result := OE_PC_GLOBALS.YES;

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

Line 1612: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1614: x_result := OE_PC_GLOBALS.YES;

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

Line 1628: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1630: x_result := OE_PC_GLOBALS.YES;

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

Line 1644: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1646: x_result := OE_PC_GLOBALS.YES;

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

Line 1660: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1662: x_result := OE_PC_GLOBALS.YES;

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

Line 1676: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1678: x_result := OE_PC_GLOBALS.YES;

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

Line 1692: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1694: x_result := OE_PC_GLOBALS.YES;

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

Line 1708: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1710: x_result := OE_PC_GLOBALS.YES;

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

Line 1724: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1726: x_result := OE_PC_GLOBALS.YES;

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

Line 1740: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1742: x_result := OE_PC_GLOBALS.YES;

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

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

1743: END IF;
1744:
1745: END IF;
1746:
1747: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1748: IF l_debug_level > 0 THEN
1749: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1750: END IF;
1751: g_check_all_cols_constraint := l_check_all_cols_constraint;