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

Line 47: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE_SCREDIT

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_SCREDIT
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 73: elsif l_result = OE_PC_GLOBALS.ERROR then

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

Line 102: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 122: IF l_result = OE_PC_GLOBALS.YES THEN

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

Line 146: l_result := OE_PC_GLOBALS.NO;

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

Line 159: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

155:
156: -- Start of fix #1459428 for function definition
157:
158: FUNCTION ATTRIBUTE1
159: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
160: , p_record IN OE_AK_LINE_SCREDITS_V%ROWTYPE
161: , x_on_operation_action OUT NOCOPY NUMBER
162:
163: ) RETURN NUMBER

Line 184: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

180: END ATTRIBUTE1;
181:
182:
183: FUNCTION ATTRIBUTE10
184: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
185: , p_record IN OE_AK_LINE_SCREDITS_V%ROWTYPE
186: , x_on_operation_action OUT NOCOPY NUMBER
187:
188: ) RETURN NUMBER

Line 208: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 233: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 258: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 283: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 308: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 333: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 358: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 383: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 408: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 433: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 459: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

455: END ATTRIBUTE6;
456:
457:
458: FUNCTION ATTRIBUTE7
459: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
460: , p_record IN OE_AK_LINE_SCREDITS_V%ROWTYPE
461: , x_on_operation_action OUT NOCOPY NUMBER
462:
463: ) RETURN NUMBER

Line 484: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

480: END ATTRIBUTE7;
481:
482:
483: FUNCTION ATTRIBUTE8
484: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
485: , p_record IN OE_AK_LINE_SCREDITS_V%ROWTYPE
486: , x_on_operation_action OUT NOCOPY NUMBER
487:
488: ) RETURN NUMBER

Line 509: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

505: END ATTRIBUTE8;
506:
507:
508: FUNCTION ATTRIBUTE9
509: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
510: , p_record IN OE_AK_LINE_SCREDITS_V%ROWTYPE
511: , x_on_operation_action OUT NOCOPY NUMBER
512:
513: ) RETURN NUMBER

Line 532: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 558: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

554:
555: -- End of fix #1459428 for function definition
556:
557: FUNCTION CREATED_BY
558: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
559: , p_record IN OE_AK_LINE_SCREDITS_V%ROWTYPE
560: , x_on_operation_action OUT NOCOPY NUMBER
561:
562: ) RETURN NUMBER

Line 583: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

579: END CREATED_BY;
580:
581:
582: FUNCTION DW_UPDATE_ADVICE
583: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
584: , p_record IN OE_AK_LINE_SCREDITS_V%ROWTYPE
585: , x_on_operation_action OUT NOCOPY NUMBER
586:
587: ) RETURN NUMBER

Line 608: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

604: END DW_UPDATE_ADVICE;
605:
606:
607: FUNCTION PERCENT
608: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
609: , p_record IN OE_AK_LINE_SCREDITS_V%ROWTYPE
610: , x_on_operation_action OUT NOCOPY NUMBER
611:
612: ) RETURN NUMBER

Line 634: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

630:
631:
632:
633: FUNCTION Sales_Credit_Type
634: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
635: , p_record IN OE_AK_LINE_SCREDITS_V%ROWTYPE
636: , x_on_operation_action OUT NOCOPY NUMBER
637:
638: ) RETURN NUMBER

Line 659: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

655: END Sales_Credit_Type;
656:
657:
658: FUNCTION SALESREP
659: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
660: , p_record IN OE_AK_LINE_SCREDITS_V%ROWTYPE
661: , x_on_operation_action OUT NOCOPY NUMBER
662:
663: ) RETURN NUMBER

Line 684: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

680: END SALESREP;
681:
682:
683: FUNCTION WH_UPDATE_DATE
684: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
685: , p_record IN OE_AK_LINE_SCREDITS_V%ROWTYPE
686: , x_on_operation_action OUT NOCOPY NUMBER
687:
688: ) RETURN NUMBER

Line 731: l_operation := OE_PC_GLOBALS.CREATE_OP;

727: -- Initializing return status to SUCCESS
728: x_return_status := FND_API.G_RET_STS_SUCCESS;
729:
730: IF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
731: l_operation := OE_PC_GLOBALS.CREATE_OP;
732: ELSIF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
733: l_operation := OE_PC_GLOBALS.UPDATE_OP;
734: ELSIF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
735: l_operation := OE_PC_GLOBALS.DELETE_OP;

Line 733: l_operation := OE_PC_GLOBALS.UPDATE_OP;

729:
730: IF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
731: l_operation := OE_PC_GLOBALS.CREATE_OP;
732: ELSIF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
733: l_operation := OE_PC_GLOBALS.UPDATE_OP;
734: ELSIF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
735: l_operation := OE_PC_GLOBALS.DELETE_OP;
736: ELSE
737: IF l_debug_level > 0 THEN

Line 735: l_operation := OE_PC_GLOBALS.DELETE_OP;

731: l_operation := OE_PC_GLOBALS.CREATE_OP;
732: ELSIF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
733: l_operation := OE_PC_GLOBALS.UPDATE_OP;
734: ELSIF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
735: l_operation := OE_PC_GLOBALS.DELETE_OP;
736: ELSE
737: IF l_debug_level > 0 THEN
738: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
739: END IF;

Line 799: x_result := OE_PC_GLOBALS.NO;

795: -- Initializing return status to SUCCESS
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797:
798: -- Initializing out result to NOT CONSTRAINED
799: x_result := OE_PC_GLOBALS.NO;
800:
801: -- Get the operation code to be passed to the security framework API
802: IF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
803:

Line 804: l_operation := OE_PC_GLOBALS.CREATE_OP;

800:
801: -- Get the operation code to be passed to the security framework API
802: IF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
803:
804: l_operation := OE_PC_GLOBALS.CREATE_OP;
805:
806: -- Bug 1755817: if there are no attribute-specific insert
807: -- constraints, then no need to go further. Entity level
808: -- security check for CREATE will be called again from

Line 811: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE_SCREDIT

807: -- constraints, then no need to go further. Entity level
808: -- security check for CREATE will be called again from
809: -- process order after defaulting.
810: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
811: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE_SCREDIT
812: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
813: ,p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
814: )
815: THEN

Line 820: l_operation := OE_PC_GLOBALS.UPDATE_OP;

816: RETURN;
817: END IF;
818:
819: ELSIF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
820: l_operation := OE_PC_GLOBALS.UPDATE_OP;
821: ELSE
822: IF l_debug_level > 0 THEN
823: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
824: END IF;

Line 848: IF l_result = OE_PC_GLOBALS.YES THEN

844: ,p_record => l_rowtype_rec
845: ,x_on_operation_action => l_on_operation_action
846: );
847:
848: IF l_result = OE_PC_GLOBALS.YES THEN
849: -- set OUT result to CONSTRAINED
850: x_result := OE_PC_GLOBALS.YES;
851: END IF;
852:

Line 850: x_result := OE_PC_GLOBALS.YES;

846: );
847:
848: IF l_result = OE_PC_GLOBALS.YES THEN
849: -- set OUT result to CONSTRAINED
850: x_result := OE_PC_GLOBALS.YES;
851: END IF;
852:
853: END IF;
854:

Line 864: IF l_result = OE_PC_GLOBALS.YES THEN

860: ,p_record => l_rowtype_rec
861: ,x_on_operation_action => l_on_operation_action
862: );
863:
864: IF l_result = OE_PC_GLOBALS.YES THEN
865: -- set OUT result to CONSTRAINED
866: x_result := OE_PC_GLOBALS.YES;
867: END IF;
868:

Line 866: x_result := OE_PC_GLOBALS.YES;

862: );
863:
864: IF l_result = OE_PC_GLOBALS.YES THEN
865: -- set OUT result to CONSTRAINED
866: x_result := OE_PC_GLOBALS.YES;
867: END IF;
868:
869: END IF;
870:

Line 879: IF l_result = OE_PC_GLOBALS.YES THEN

875: (p_operation => l_operation
876: ,p_record => l_rowtype_rec
877: ,x_on_operation_action => l_on_operation_action
878: );
879: IF l_result = OE_PC_GLOBALS.YES THEN
880: -- set OUT result to CONSTRAINED
881: x_result := OE_PC_GLOBALS.YES;
882: END IF;
883:

Line 881: x_result := OE_PC_GLOBALS.YES;

877: ,x_on_operation_action => l_on_operation_action
878: );
879: IF l_result = OE_PC_GLOBALS.YES THEN
880: -- set OUT result to CONSTRAINED
881: x_result := OE_PC_GLOBALS.YES;
882: END IF;
883:
884: END IF;
885:

Line 894: IF l_result = OE_PC_GLOBALS.YES THEN

890: (p_operation => l_operation
891: ,p_record => l_rowtype_rec
892: ,x_on_operation_action => l_on_operation_action
893: );
894: IF l_result = OE_PC_GLOBALS.YES THEN
895: -- set OUT result to CONSTRAINED
896: x_result := OE_PC_GLOBALS.YES;
897: END IF;
898:

Line 896: x_result := OE_PC_GLOBALS.YES;

892: ,x_on_operation_action => l_on_operation_action
893: );
894: IF l_result = OE_PC_GLOBALS.YES THEN
895: -- set OUT result to CONSTRAINED
896: x_result := OE_PC_GLOBALS.YES;
897: END IF;
898:
899: END IF;
900:

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

909: -- updated and profile was set to 'N', global at the end should
910: -- be re-set to 'Y' - this indicates to process order that no
911: -- constrainable attributes were updated and thus, it would
912: -- suppress entity level security check also.
913: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
914: l_check_all_cols_constraint := g_check_all_cols_constraint;
915: g_check_all_cols_constraint := 'N';
916: END IF;
917:

Line 927: IF l_result = OE_PC_GLOBALS.YES THEN

923: ,p_record => l_rowtype_rec
924: ,x_on_operation_action => l_on_operation_action
925: );
926:
927: IF l_result = OE_PC_GLOBALS.YES THEN
928: -- set OUT result to CONSTRAINED
929: x_result := OE_PC_GLOBALS.YES;
930: END IF;
931:

Line 929: x_result := OE_PC_GLOBALS.YES;

925: );
926:
927: IF l_result = OE_PC_GLOBALS.YES THEN
928: -- set OUT result to CONSTRAINED
929: x_result := OE_PC_GLOBALS.YES;
930: END IF;
931:
932: END IF;
933:

Line 943: IF l_result = OE_PC_GLOBALS.YES THEN

939: ,p_record => l_rowtype_rec
940: ,x_on_operation_action => l_on_operation_action
941: );
942:
943: IF l_result = OE_PC_GLOBALS.YES THEN
944: -- set OUT result to CONSTRAINED
945: x_result := OE_PC_GLOBALS.YES;
946: END IF;
947:

Line 945: x_result := OE_PC_GLOBALS.YES;

941: );
942:
943: IF l_result = OE_PC_GLOBALS.YES THEN
944: -- set OUT result to CONSTRAINED
945: x_result := OE_PC_GLOBALS.YES;
946: END IF;
947:
948: END IF;
949:

Line 959: IF l_result = OE_PC_GLOBALS.YES THEN

955: ,p_record => l_rowtype_rec
956: ,x_on_operation_action => l_on_operation_action
957: );
958:
959: IF l_result = OE_PC_GLOBALS.YES THEN
960: -- set OUT result to CONSTRAINED
961: x_result := OE_PC_GLOBALS.YES;
962: END IF;
963:

Line 961: x_result := OE_PC_GLOBALS.YES;

957: );
958:
959: IF l_result = OE_PC_GLOBALS.YES THEN
960: -- set OUT result to CONSTRAINED
961: x_result := OE_PC_GLOBALS.YES;
962: END IF;
963:
964: END IF;
965:

Line 975: IF l_result = OE_PC_GLOBALS.YES THEN

971: ,p_record => l_rowtype_rec
972: ,x_on_operation_action => l_on_operation_action
973: );
974:
975: IF l_result = OE_PC_GLOBALS.YES THEN
976: -- set OUT result to CONSTRAINED
977: x_result := OE_PC_GLOBALS.YES;
978: END IF;
979:

Line 977: x_result := OE_PC_GLOBALS.YES;

973: );
974:
975: IF l_result = OE_PC_GLOBALS.YES THEN
976: -- set OUT result to CONSTRAINED
977: x_result := OE_PC_GLOBALS.YES;
978: END IF;
979:
980: END IF;
981:

Line 991: IF l_result = OE_PC_GLOBALS.YES THEN

987: ,p_record => l_rowtype_rec
988: ,x_on_operation_action => l_on_operation_action
989: );
990:
991: IF l_result = OE_PC_GLOBALS.YES THEN
992: -- set OUT result to CONSTRAINED
993: x_result := OE_PC_GLOBALS.YES;
994: END IF;
995:

Line 993: x_result := OE_PC_GLOBALS.YES;

989: );
990:
991: IF l_result = OE_PC_GLOBALS.YES THEN
992: -- set OUT result to CONSTRAINED
993: x_result := OE_PC_GLOBALS.YES;
994: END IF;
995:
996: END IF;
997:

Line 1007: IF l_result = OE_PC_GLOBALS.YES THEN

1003: ,p_record => l_rowtype_rec
1004: ,x_on_operation_action => l_on_operation_action
1005: );
1006:
1007: IF l_result = OE_PC_GLOBALS.YES THEN
1008: -- set OUT result to CONSTRAINED
1009: x_result := OE_PC_GLOBALS.YES;
1010: END IF;
1011:

Line 1009: x_result := OE_PC_GLOBALS.YES;

1005: );
1006:
1007: IF l_result = OE_PC_GLOBALS.YES THEN
1008: -- set OUT result to CONSTRAINED
1009: x_result := OE_PC_GLOBALS.YES;
1010: END IF;
1011:
1012: END IF;
1013:

Line 1023: IF l_result = OE_PC_GLOBALS.YES THEN

1019: ,p_record => l_rowtype_rec
1020: ,x_on_operation_action => l_on_operation_action
1021: );
1022:
1023: IF l_result = OE_PC_GLOBALS.YES THEN
1024: -- set OUT result to CONSTRAINED
1025: x_result := OE_PC_GLOBALS.YES;
1026: END IF;
1027:

Line 1025: x_result := OE_PC_GLOBALS.YES;

1021: );
1022:
1023: IF l_result = OE_PC_GLOBALS.YES THEN
1024: -- set OUT result to CONSTRAINED
1025: x_result := OE_PC_GLOBALS.YES;
1026: END IF;
1027:
1028: END IF;
1029:

Line 1039: IF l_result = OE_PC_GLOBALS.YES THEN

1035: ,p_record => l_rowtype_rec
1036: ,x_on_operation_action => l_on_operation_action
1037: );
1038:
1039: IF l_result = OE_PC_GLOBALS.YES THEN
1040: -- set OUT result to CONSTRAINED
1041: x_result := OE_PC_GLOBALS.YES;
1042: END IF;
1043:

Line 1041: x_result := OE_PC_GLOBALS.YES;

1037: );
1038:
1039: IF l_result = OE_PC_GLOBALS.YES THEN
1040: -- set OUT result to CONSTRAINED
1041: x_result := OE_PC_GLOBALS.YES;
1042: END IF;
1043:
1044: END IF;
1045:

Line 1055: IF l_result = OE_PC_GLOBALS.YES THEN

1051: ,p_record => l_rowtype_rec
1052: ,x_on_operation_action => l_on_operation_action
1053: );
1054:
1055: IF l_result = OE_PC_GLOBALS.YES THEN
1056: -- set OUT result to CONSTRAINED
1057: x_result := OE_PC_GLOBALS.YES;
1058: END IF;
1059:

Line 1057: x_result := OE_PC_GLOBALS.YES;

1053: );
1054:
1055: IF l_result = OE_PC_GLOBALS.YES THEN
1056: -- set OUT result to CONSTRAINED
1057: x_result := OE_PC_GLOBALS.YES;
1058: END IF;
1059:
1060: END IF;
1061:

Line 1071: IF l_result = OE_PC_GLOBALS.YES THEN

1067: ,p_record => l_rowtype_rec
1068: ,x_on_operation_action => l_on_operation_action
1069: );
1070:
1071: IF l_result = OE_PC_GLOBALS.YES THEN
1072: -- set OUT result to CONSTRAINED
1073: x_result := OE_PC_GLOBALS.YES;
1074: END IF;
1075:

Line 1073: x_result := OE_PC_GLOBALS.YES;

1069: );
1070:
1071: IF l_result = OE_PC_GLOBALS.YES THEN
1072: -- set OUT result to CONSTRAINED
1073: x_result := OE_PC_GLOBALS.YES;
1074: END IF;
1075:
1076: END IF;
1077:

Line 1087: IF l_result = OE_PC_GLOBALS.YES THEN

1083: ,p_record => l_rowtype_rec
1084: ,x_on_operation_action => l_on_operation_action
1085: );
1086:
1087: IF l_result = OE_PC_GLOBALS.YES THEN
1088: -- set OUT result to CONSTRAINED
1089: x_result := OE_PC_GLOBALS.YES;
1090: END IF;
1091:

Line 1089: x_result := OE_PC_GLOBALS.YES;

1085: );
1086:
1087: IF l_result = OE_PC_GLOBALS.YES THEN
1088: -- set OUT result to CONSTRAINED
1089: x_result := OE_PC_GLOBALS.YES;
1090: END IF;
1091:
1092: END IF;
1093:

Line 1103: IF l_result = OE_PC_GLOBALS.YES THEN

1099: ,p_record => l_rowtype_rec
1100: ,x_on_operation_action => l_on_operation_action
1101: );
1102:
1103: IF l_result = OE_PC_GLOBALS.YES THEN
1104: -- set OUT result to CONSTRAINED
1105: x_result := OE_PC_GLOBALS.YES;
1106: END IF;
1107:

Line 1105: x_result := OE_PC_GLOBALS.YES;

1101: );
1102:
1103: IF l_result = OE_PC_GLOBALS.YES THEN
1104: -- set OUT result to CONSTRAINED
1105: x_result := OE_PC_GLOBALS.YES;
1106: END IF;
1107:
1108: END IF;
1109:

Line 1119: IF l_result = OE_PC_GLOBALS.YES THEN

1115: ,p_record => l_rowtype_rec
1116: ,x_on_operation_action => l_on_operation_action
1117: );
1118:
1119: IF l_result = OE_PC_GLOBALS.YES THEN
1120: -- set OUT result to CONSTRAINED
1121: x_result := OE_PC_GLOBALS.YES;
1122: END IF;
1123:

Line 1121: x_result := OE_PC_GLOBALS.YES;

1117: );
1118:
1119: IF l_result = OE_PC_GLOBALS.YES THEN
1120: -- set OUT result to CONSTRAINED
1121: x_result := OE_PC_GLOBALS.YES;
1122: END IF;
1123:
1124: END IF;
1125:

Line 1135: IF l_result = OE_PC_GLOBALS.YES THEN

1131: ,p_record => l_rowtype_rec
1132: ,x_on_operation_action => l_on_operation_action
1133: );
1134:
1135: IF l_result = OE_PC_GLOBALS.YES THEN
1136: -- set OUT result to CONSTRAINED
1137: x_result := OE_PC_GLOBALS.YES;
1138: END IF;
1139:

Line 1137: x_result := OE_PC_GLOBALS.YES;

1133: );
1134:
1135: IF l_result = OE_PC_GLOBALS.YES THEN
1136: -- set OUT result to CONSTRAINED
1137: x_result := OE_PC_GLOBALS.YES;
1138: END IF;
1139:
1140: END IF;
1141:

Line 1151: IF l_result = OE_PC_GLOBALS.YES THEN

1147: ,p_record => l_rowtype_rec
1148: ,x_on_operation_action => l_on_operation_action
1149: );
1150:
1151: IF l_result = OE_PC_GLOBALS.YES THEN
1152: -- set OUT result to CONSTRAINED
1153: x_result := OE_PC_GLOBALS.YES;
1154: END IF;
1155:

Line 1153: x_result := OE_PC_GLOBALS.YES;

1149: );
1150:
1151: IF l_result = OE_PC_GLOBALS.YES THEN
1152: -- set OUT result to CONSTRAINED
1153: x_result := OE_PC_GLOBALS.YES;
1154: END IF;
1155:
1156: END IF;
1157:

Line 1167: IF l_result = OE_PC_GLOBALS.YES THEN

1163: ,p_record => l_rowtype_rec
1164: ,x_on_operation_action => l_on_operation_action
1165: );
1166:
1167: IF l_result = OE_PC_GLOBALS.YES THEN
1168: -- set OUT result to CONSTRAINED
1169: x_result := OE_PC_GLOBALS.YES;
1170: END IF;
1171:

Line 1169: x_result := OE_PC_GLOBALS.YES;

1165: );
1166:
1167: IF l_result = OE_PC_GLOBALS.YES THEN
1168: -- set OUT result to CONSTRAINED
1169: x_result := OE_PC_GLOBALS.YES;
1170: END IF;
1171:
1172: END IF;
1173:

Line 1183: IF l_result = OE_PC_GLOBALS.YES THEN

1179: ,p_record => l_rowtype_rec
1180: ,x_on_operation_action => l_on_operation_action
1181: );
1182:
1183: IF l_result = OE_PC_GLOBALS.YES THEN
1184: -- set OUT result to CONSTRAINED
1185: x_result := OE_PC_GLOBALS.YES;
1186: END IF;
1187:

Line 1185: x_result := OE_PC_GLOBALS.YES;

1181: );
1182:
1183: IF l_result = OE_PC_GLOBALS.YES THEN
1184: -- set OUT result to CONSTRAINED
1185: x_result := OE_PC_GLOBALS.YES;
1186: END IF;
1187:
1188: END IF;
1189:

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

1186: END IF;
1187:
1188: END IF;
1189:
1190: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1191: IF l_debug_level > 0 THEN
1192: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1193: END IF;
1194: g_check_all_cols_constraint := l_check_all_cols_constraint;