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

1374: ,p_record => l_rowtype_rec
1375: ,x_on_operation_action => l_on_operation_action
1376: );
1377:
1378: IF l_result = OE_PC_GLOBALS.YES THEN
1379: -- set OUT result to CONSTRAINED
1380: x_result := OE_PC_GLOBALS.YES;
1381: END IF;
1382:

Line 1380: x_result := OE_PC_GLOBALS.YES;

1376: );
1377:
1378: IF l_result = OE_PC_GLOBALS.YES THEN
1379: -- set OUT result to CONSTRAINED
1380: x_result := OE_PC_GLOBALS.YES;
1381: END IF;
1382:
1383: END IF;
1384:

Line 1394: IF l_result = OE_PC_GLOBALS.YES THEN

1390: ,p_record => l_rowtype_rec
1391: ,x_on_operation_action => l_on_operation_action
1392: );
1393:
1394: IF l_result = OE_PC_GLOBALS.YES THEN
1395: -- set OUT result to CONSTRAINED
1396: x_result := OE_PC_GLOBALS.YES;
1397: END IF;
1398:

Line 1396: x_result := OE_PC_GLOBALS.YES;

1392: );
1393:
1394: IF l_result = OE_PC_GLOBALS.YES THEN
1395: -- set OUT result to CONSTRAINED
1396: x_result := OE_PC_GLOBALS.YES;
1397: END IF;
1398:
1399: END IF;
1400:

Line 1410: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1412: x_result := OE_PC_GLOBALS.YES;

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

Line 1426: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1428: x_result := OE_PC_GLOBALS.YES;

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

Line 1442: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1444: x_result := OE_PC_GLOBALS.YES;

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

Line 1458: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1460: x_result := OE_PC_GLOBALS.YES;

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

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

1472: -- updated and profile was set to 'N', global at the end should
1473: -- be re-set to 'Y' - this indicates to process order that no
1474: -- constrainable attributes were updated and thus, it would
1475: -- suppress entity level security check also.
1476: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1477: l_check_all_cols_constraint := g_check_all_cols_constraint;
1478: g_check_all_cols_constraint := 'N';
1479: END IF;
1480:

Line 1490: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 1492: x_result := OE_PC_GLOBALS.YES;

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

Line 1506: IF l_result = OE_PC_GLOBALS.YES THEN

1502: ,p_record => l_rowtype_rec
1503: ,x_on_operation_action => l_on_operation_action
1504: );
1505:
1506: IF l_result = OE_PC_GLOBALS.YES THEN
1507: -- set OUT result to CONSTRAINED
1508: x_result := OE_PC_GLOBALS.YES;
1509: END IF;
1510:

Line 1508: x_result := OE_PC_GLOBALS.YES;

1504: );
1505:
1506: IF l_result = OE_PC_GLOBALS.YES THEN
1507: -- set OUT result to CONSTRAINED
1508: x_result := OE_PC_GLOBALS.YES;
1509: END IF;
1510:
1511: END IF;
1512:

Line 1522: IF l_result = OE_PC_GLOBALS.YES THEN

1518: ,p_record => l_rowtype_rec
1519: ,x_on_operation_action => l_on_operation_action
1520: );
1521:
1522: IF l_result = OE_PC_GLOBALS.YES THEN
1523: -- set OUT result to CONSTRAINED
1524: x_result := OE_PC_GLOBALS.YES;
1525: END IF;
1526:

Line 1524: x_result := OE_PC_GLOBALS.YES;

1520: );
1521:
1522: IF l_result = OE_PC_GLOBALS.YES THEN
1523: -- set OUT result to CONSTRAINED
1524: x_result := OE_PC_GLOBALS.YES;
1525: END IF;
1526:
1527: END IF;
1528:

Line 1538: IF l_result = OE_PC_GLOBALS.YES THEN

1534: ,p_record => l_rowtype_rec
1535: ,x_on_operation_action => l_on_operation_action
1536: );
1537:
1538: IF l_result = OE_PC_GLOBALS.YES THEN
1539: -- set OUT result to CONSTRAINED
1540: x_result := OE_PC_GLOBALS.YES;
1541: END IF;
1542:

Line 1540: x_result := OE_PC_GLOBALS.YES;

1536: );
1537:
1538: IF l_result = OE_PC_GLOBALS.YES THEN
1539: -- set OUT result to CONSTRAINED
1540: x_result := OE_PC_GLOBALS.YES;
1541: END IF;
1542:
1543: END IF;
1544:

Line 1554: IF l_result = OE_PC_GLOBALS.YES THEN

1550: ,p_record => l_rowtype_rec
1551: ,x_on_operation_action => l_on_operation_action
1552: );
1553:
1554: IF l_result = OE_PC_GLOBALS.YES THEN
1555: -- set OUT result to CONSTRAINED
1556: x_result := OE_PC_GLOBALS.YES;
1557: END IF;
1558:

Line 1556: x_result := OE_PC_GLOBALS.YES;

1552: );
1553:
1554: IF l_result = OE_PC_GLOBALS.YES THEN
1555: -- set OUT result to CONSTRAINED
1556: x_result := OE_PC_GLOBALS.YES;
1557: END IF;
1558:
1559: END IF;
1560:

Line 1570: IF l_result = OE_PC_GLOBALS.YES THEN

1566: ,p_record => l_rowtype_rec
1567: ,x_on_operation_action => l_on_operation_action
1568: );
1569:
1570: IF l_result = OE_PC_GLOBALS.YES THEN
1571: -- set OUT result to CONSTRAINED
1572: x_result := OE_PC_GLOBALS.YES;
1573: END IF;
1574:

Line 1572: x_result := OE_PC_GLOBALS.YES;

1568: );
1569:
1570: IF l_result = OE_PC_GLOBALS.YES THEN
1571: -- set OUT result to CONSTRAINED
1572: x_result := OE_PC_GLOBALS.YES;
1573: END IF;
1574:
1575: END IF;
1576:

Line 1586: IF l_result = OE_PC_GLOBALS.YES THEN

1582: ,p_record => l_rowtype_rec
1583: ,x_on_operation_action => l_on_operation_action
1584: );
1585:
1586: IF l_result = OE_PC_GLOBALS.YES THEN
1587: -- set OUT result to CONSTRAINED
1588: x_result := OE_PC_GLOBALS.YES;
1589: END IF;
1590:

Line 1588: x_result := OE_PC_GLOBALS.YES;

1584: );
1585:
1586: IF l_result = OE_PC_GLOBALS.YES THEN
1587: -- set OUT result to CONSTRAINED
1588: x_result := OE_PC_GLOBALS.YES;
1589: END IF;
1590:
1591: END IF;
1592:

Line 1602: IF l_result = OE_PC_GLOBALS.YES THEN

1598: ,p_record => l_rowtype_rec
1599: ,x_on_operation_action => l_on_operation_action
1600: );
1601:
1602: IF l_result = OE_PC_GLOBALS.YES THEN
1603: -- set OUT result to CONSTRAINED
1604: x_result := OE_PC_GLOBALS.YES;
1605: END IF;
1606:

Line 1604: x_result := OE_PC_GLOBALS.YES;

1600: );
1601:
1602: IF l_result = OE_PC_GLOBALS.YES THEN
1603: -- set OUT result to CONSTRAINED
1604: x_result := OE_PC_GLOBALS.YES;
1605: END IF;
1606:
1607: END IF;
1608:

Line 1618: IF l_result = OE_PC_GLOBALS.YES THEN

1614: ,p_record => l_rowtype_rec
1615: ,x_on_operation_action => l_on_operation_action
1616: );
1617:
1618: IF l_result = OE_PC_GLOBALS.YES THEN
1619: -- set OUT result to CONSTRAINED
1620: x_result := OE_PC_GLOBALS.YES;
1621: END IF;
1622:

Line 1620: x_result := OE_PC_GLOBALS.YES;

1616: );
1617:
1618: IF l_result = OE_PC_GLOBALS.YES THEN
1619: -- set OUT result to CONSTRAINED
1620: x_result := OE_PC_GLOBALS.YES;
1621: END IF;
1622:
1623: END IF;
1624:

Line 1634: IF l_result = OE_PC_GLOBALS.YES THEN

1630: ,p_record => l_rowtype_rec
1631: ,x_on_operation_action => l_on_operation_action
1632: );
1633:
1634: IF l_result = OE_PC_GLOBALS.YES THEN
1635: -- set OUT result to CONSTRAINED
1636: x_result := OE_PC_GLOBALS.YES;
1637: END IF;
1638:

Line 1636: x_result := OE_PC_GLOBALS.YES;

1632: );
1633:
1634: IF l_result = OE_PC_GLOBALS.YES THEN
1635: -- set OUT result to CONSTRAINED
1636: x_result := OE_PC_GLOBALS.YES;
1637: END IF;
1638:
1639: END IF;
1640:

Line 1650: IF l_result = OE_PC_GLOBALS.YES THEN

1646: ,p_record => l_rowtype_rec
1647: ,x_on_operation_action => l_on_operation_action
1648: );
1649:
1650: IF l_result = OE_PC_GLOBALS.YES THEN
1651: -- set OUT result to CONSTRAINED
1652: x_result := OE_PC_GLOBALS.YES;
1653: END IF;
1654:

Line 1652: x_result := OE_PC_GLOBALS.YES;

1648: );
1649:
1650: IF l_result = OE_PC_GLOBALS.YES THEN
1651: -- set OUT result to CONSTRAINED
1652: x_result := OE_PC_GLOBALS.YES;
1653: END IF;
1654:
1655: END IF;
1656:

Line 1666: IF l_result = OE_PC_GLOBALS.YES THEN

1662: ,p_record => l_rowtype_rec
1663: ,x_on_operation_action => l_on_operation_action
1664: );
1665:
1666: IF l_result = OE_PC_GLOBALS.YES THEN
1667: -- set OUT result to CONSTRAINED
1668: x_result := OE_PC_GLOBALS.YES;
1669: END IF;
1670:

Line 1668: x_result := OE_PC_GLOBALS.YES;

1664: );
1665:
1666: IF l_result = OE_PC_GLOBALS.YES THEN
1667: -- set OUT result to CONSTRAINED
1668: x_result := OE_PC_GLOBALS.YES;
1669: END IF;
1670:
1671: END IF;
1672:

Line 1682: IF l_result = OE_PC_GLOBALS.YES THEN

1678: ,p_record => l_rowtype_rec
1679: ,x_on_operation_action => l_on_operation_action
1680: );
1681:
1682: IF l_result = OE_PC_GLOBALS.YES THEN
1683: -- set OUT result to CONSTRAINED
1684: x_result := OE_PC_GLOBALS.YES;
1685: END IF;
1686:

Line 1684: x_result := OE_PC_GLOBALS.YES;

1680: );
1681:
1682: IF l_result = OE_PC_GLOBALS.YES THEN
1683: -- set OUT result to CONSTRAINED
1684: x_result := OE_PC_GLOBALS.YES;
1685: END IF;
1686:
1687: END IF;
1688:

Line 1698: IF l_result = OE_PC_GLOBALS.YES THEN

1694: ,p_record => l_rowtype_rec
1695: ,x_on_operation_action => l_on_operation_action
1696: );
1697:
1698: IF l_result = OE_PC_GLOBALS.YES THEN
1699: -- set OUT result to CONSTRAINED
1700: x_result := OE_PC_GLOBALS.YES;
1701: END IF;
1702:

Line 1700: x_result := OE_PC_GLOBALS.YES;

1696: );
1697:
1698: IF l_result = OE_PC_GLOBALS.YES THEN
1699: -- set OUT result to CONSTRAINED
1700: x_result := OE_PC_GLOBALS.YES;
1701: END IF;
1702:
1703: END IF;
1704:

Line 1714: IF l_result = OE_PC_GLOBALS.YES THEN

1710: ,p_record => l_rowtype_rec
1711: ,x_on_operation_action => l_on_operation_action
1712: );
1713:
1714: IF l_result = OE_PC_GLOBALS.YES THEN
1715: -- set OUT result to CONSTRAINED
1716: x_result := OE_PC_GLOBALS.YES;
1717: END IF;
1718:

Line 1716: x_result := OE_PC_GLOBALS.YES;

1712: );
1713:
1714: IF l_result = OE_PC_GLOBALS.YES THEN
1715: -- set OUT result to CONSTRAINED
1716: x_result := OE_PC_GLOBALS.YES;
1717: END IF;
1718:
1719: END IF;
1720:

Line 1730: IF l_result = OE_PC_GLOBALS.YES THEN

1726: ,p_record => l_rowtype_rec
1727: ,x_on_operation_action => l_on_operation_action
1728: );
1729:
1730: IF l_result = OE_PC_GLOBALS.YES THEN
1731: -- set OUT result to CONSTRAINED
1732: x_result := OE_PC_GLOBALS.YES;
1733: END IF;
1734:

Line 1732: x_result := OE_PC_GLOBALS.YES;

1728: );
1729:
1730: IF l_result = OE_PC_GLOBALS.YES THEN
1731: -- set OUT result to CONSTRAINED
1732: x_result := OE_PC_GLOBALS.YES;
1733: END IF;
1734:
1735: END IF;
1736:

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

1733: END IF;
1734:
1735: END IF;
1736:
1737: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1738: IF l_debug_level > 0 THEN
1739: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1740: END IF;
1741: g_check_all_cols_constraint := l_check_all_cols_constraint;