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

Line 56: , p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_SCREDIT

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

Line 66: if l_result = OE_PC_GLOBALS.YES then

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

Line 69: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP

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

Line 70: OR p_operation = OE_PC_GLOBALS.CREATE_OP)

66: if l_result = OE_PC_GLOBALS.YES then
67:
68: IF g_check_all_cols_constraint = 'Y'
69: AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
70: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
71: AND x_on_operation_action = 0
72: AND p_column_name IS NOT NULL THEN
73: SELECT column_name
74: 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 SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;

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 SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;

Line 156: l_result := OE_PC_GLOBALS.NO;

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

Line 169: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

165:
166: -- Start of fix #1459428 for function definition
167:
168: FUNCTION ATTRIBUTE1
169: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
170: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
171: , x_on_operation_action OUT NOCOPY NUMBER
172:
173: ) RETURN NUMBER

Line 194: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 219: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 244: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 269: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 294: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 319: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 344: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 369: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 394: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 419: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 444: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 469: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 494: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 519: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

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

Line 544: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

540: END ATTRIBUTE9;
541:
542:
543: FUNCTION CONTEXT
544: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
545: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
546: , x_on_operation_action OUT NOCOPY NUMBER
547:
548: ) RETURN NUMBER

Line 570: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

566:
567: -- End of fix #1459428 for function definition
568:
569: FUNCTION CREATED_BY
570: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
571: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
572: , x_on_operation_action OUT NOCOPY NUMBER
573:
574: ) RETURN NUMBER

Line 595: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

591: END CREATED_BY;
592:
593:
594: FUNCTION DW_UPDATE_ADVICE
595: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
596: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
597: , x_on_operation_action OUT NOCOPY NUMBER
598:
599: ) RETURN NUMBER

Line 620: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

616: END DW_UPDATE_ADVICE;
617:
618:
619: FUNCTION PERCENT
620: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
621: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
622: , x_on_operation_action OUT NOCOPY NUMBER
623:
624: ) RETURN NUMBER

Line 646: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

642:
643:
644:
645: FUNCTION SALESREP
646: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
647: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
648: , x_on_operation_action OUT NOCOPY NUMBER
649:
650: ) RETURN NUMBER

Line 670: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

666:
667: END SALESREP;
668:
669: FUNCTION sales_credit_type
670: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
671: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
672: , x_on_operation_action OUT NOCOPY NUMBER
673:
674: ) RETURN NUMBER

Line 694: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP

690:
691: END sales_credit_type;
692:
693: FUNCTION WH_UPDATE_DATE
694: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
695: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
696: , x_on_operation_action OUT NOCOPY NUMBER
697:
698: ) RETURN NUMBER

Line 741: l_operation := OE_PC_GLOBALS.CREATE_OP;

737: -- Initializing return status to SUCCESS
738: x_return_status := FND_API.G_RET_STS_SUCCESS;
739:
740: IF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
741: l_operation := OE_PC_GLOBALS.CREATE_OP;
742: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
743: l_operation := OE_PC_GLOBALS.UPDATE_OP;
744: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
745: l_operation := OE_PC_GLOBALS.DELETE_OP;

Line 743: l_operation := OE_PC_GLOBALS.UPDATE_OP;

739:
740: IF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
741: l_operation := OE_PC_GLOBALS.CREATE_OP;
742: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
743: l_operation := OE_PC_GLOBALS.UPDATE_OP;
744: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
745: l_operation := OE_PC_GLOBALS.DELETE_OP;
746: ELSE
747: IF l_debug_level > 0 THEN

Line 745: l_operation := OE_PC_GLOBALS.DELETE_OP;

741: l_operation := OE_PC_GLOBALS.CREATE_OP;
742: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
743: l_operation := OE_PC_GLOBALS.UPDATE_OP;
744: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
745: l_operation := OE_PC_GLOBALS.DELETE_OP;
746: ELSE
747: IF l_debug_level > 0 THEN
748: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
749: END IF;

Line 809: x_result := OE_PC_GLOBALS.NO;

805: -- Initializing return status to SUCCESS
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: -- Initializing out result to NOT CONSTRAINED
809: x_result := OE_PC_GLOBALS.NO;
810:
811: -- Get the operation code to be passed to the security framework API
812: IF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
813:

Line 814: l_operation := OE_PC_GLOBALS.CREATE_OP;

810:
811: -- Get the operation code to be passed to the security framework API
812: IF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
813:
814: l_operation := OE_PC_GLOBALS.CREATE_OP;
815:
816: -- Bug 1755817: if there are no attribute-specific insert
817: -- constraints, then no need to go further. Entity level
818: -- security check for CREATE will be called again from

Line 821: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_SCREDIT

817: -- constraints, then no need to go further. Entity level
818: -- security check for CREATE will be called again from
819: -- process order after defaulting.
820: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
821: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_SCREDIT
822: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
823: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
824: )
825: THEN

Line 830: l_operation := OE_PC_GLOBALS.UPDATE_OP;

826: RETURN;
827: END IF;
828:
829: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
830: l_operation := OE_PC_GLOBALS.UPDATE_OP;
831: ELSE
832: IF l_debug_level > 0 THEN
833: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
834: END IF;

Line 857: IF l_result = OE_PC_GLOBALS.YES THEN

853: ,p_record => l_rowtype_rec
854: ,x_on_operation_action => l_on_operation_action
855: );
856:
857: IF l_result = OE_PC_GLOBALS.YES THEN
858: -- set OUT result to CONSTRAINED
859: x_result := OE_PC_GLOBALS.YES;
860: END IF;
861:

Line 859: x_result := OE_PC_GLOBALS.YES;

855: );
856:
857: IF l_result = OE_PC_GLOBALS.YES THEN
858: -- set OUT result to CONSTRAINED
859: x_result := OE_PC_GLOBALS.YES;
860: END IF;
861:
862: END IF;
863:

Line 873: IF l_result = OE_PC_GLOBALS.YES THEN

869: ,p_record => l_rowtype_rec
870: ,x_on_operation_action => l_on_operation_action
871: );
872:
873: IF l_result = OE_PC_GLOBALS.YES THEN
874: -- set OUT result to CONSTRAINED
875: x_result := OE_PC_GLOBALS.YES;
876: END IF;
877:

Line 875: x_result := OE_PC_GLOBALS.YES;

871: );
872:
873: IF l_result = OE_PC_GLOBALS.YES THEN
874: -- set OUT result to CONSTRAINED
875: x_result := OE_PC_GLOBALS.YES;
876: END IF;
877:
878: END IF;
879:

Line 888: IF l_result = OE_PC_GLOBALS.YES THEN

884: (p_operation => l_operation
885: ,p_record => l_rowtype_rec
886: ,x_on_operation_action => l_on_operation_action
887: );
888: IF l_result = OE_PC_GLOBALS.YES THEN
889: -- set OUT result to CONSTRAINED
890: x_result := OE_PC_GLOBALS.YES;
891: END IF;
892:

Line 890: x_result := OE_PC_GLOBALS.YES;

886: ,x_on_operation_action => l_on_operation_action
887: );
888: IF l_result = OE_PC_GLOBALS.YES THEN
889: -- set OUT result to CONSTRAINED
890: x_result := OE_PC_GLOBALS.YES;
891: END IF;
892:
893: END IF;
894:

Line 904: IF l_result = OE_PC_GLOBALS.YES THEN

900: (p_operation => l_operation
901: ,p_record => l_rowtype_rec
902: ,x_on_operation_action => l_on_operation_action
903: );
904: IF l_result = OE_PC_GLOBALS.YES THEN
905: -- set OUT result to CONSTRAINED
906: x_result := OE_PC_GLOBALS.YES;
907: END IF;
908:

Line 906: x_result := OE_PC_GLOBALS.YES;

902: ,x_on_operation_action => l_on_operation_action
903: );
904: IF l_result = OE_PC_GLOBALS.YES THEN
905: -- set OUT result to CONSTRAINED
906: x_result := OE_PC_GLOBALS.YES;
907: END IF;
908:
909: END IF;
910:

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

919: -- updated and profile was set to 'N', global at the end should
920: -- be re-set to 'Y' - this indicates to process order that no
921: -- constrainable attributes were updated and thus, it would
922: -- suppress entity level security check also.
923: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
924: l_check_all_cols_constraint := g_check_all_cols_constraint;
925: g_check_all_cols_constraint := 'N';
926: END IF;
927:

Line 937: IF l_result = OE_PC_GLOBALS.YES THEN

933: ,p_record => l_rowtype_rec
934: ,x_on_operation_action => l_on_operation_action
935: );
936:
937: IF l_result = OE_PC_GLOBALS.YES THEN
938: -- set OUT result to CONSTRAINED
939: x_result := OE_PC_GLOBALS.YES;
940: END IF;
941:

Line 939: x_result := OE_PC_GLOBALS.YES;

935: );
936:
937: IF l_result = OE_PC_GLOBALS.YES THEN
938: -- set OUT result to CONSTRAINED
939: x_result := OE_PC_GLOBALS.YES;
940: END IF;
941:
942: END IF;
943:

Line 953: IF l_result = OE_PC_GLOBALS.YES THEN

949: ,p_record => l_rowtype_rec
950: ,x_on_operation_action => l_on_operation_action
951: );
952:
953: IF l_result = OE_PC_GLOBALS.YES THEN
954: -- set OUT result to CONSTRAINED
955: x_result := OE_PC_GLOBALS.YES;
956: END IF;
957:

Line 955: x_result := OE_PC_GLOBALS.YES;

951: );
952:
953: IF l_result = OE_PC_GLOBALS.YES THEN
954: -- set OUT result to CONSTRAINED
955: x_result := OE_PC_GLOBALS.YES;
956: END IF;
957:
958: END IF;
959:

Line 969: IF l_result = OE_PC_GLOBALS.YES THEN

965: ,p_record => l_rowtype_rec
966: ,x_on_operation_action => l_on_operation_action
967: );
968:
969: IF l_result = OE_PC_GLOBALS.YES THEN
970: -- set OUT result to CONSTRAINED
971: x_result := OE_PC_GLOBALS.YES;
972: END IF;
973:

Line 971: x_result := OE_PC_GLOBALS.YES;

967: );
968:
969: IF l_result = OE_PC_GLOBALS.YES THEN
970: -- set OUT result to CONSTRAINED
971: x_result := OE_PC_GLOBALS.YES;
972: END IF;
973:
974: END IF;
975:

Line 985: IF l_result = OE_PC_GLOBALS.YES THEN

981: ,p_record => l_rowtype_rec
982: ,x_on_operation_action => l_on_operation_action
983: );
984:
985: IF l_result = OE_PC_GLOBALS.YES THEN
986: -- set OUT result to CONSTRAINED
987: x_result := OE_PC_GLOBALS.YES;
988: END IF;
989:

Line 987: x_result := OE_PC_GLOBALS.YES;

983: );
984:
985: IF l_result = OE_PC_GLOBALS.YES THEN
986: -- set OUT result to CONSTRAINED
987: x_result := OE_PC_GLOBALS.YES;
988: END IF;
989:
990: END IF;
991:

Line 1001: IF l_result = OE_PC_GLOBALS.YES THEN

997: ,p_record => l_rowtype_rec
998: ,x_on_operation_action => l_on_operation_action
999: );
1000:
1001: IF l_result = OE_PC_GLOBALS.YES THEN
1002: -- set OUT result to CONSTRAINED
1003: x_result := OE_PC_GLOBALS.YES;
1004: END IF;
1005:

Line 1003: x_result := OE_PC_GLOBALS.YES;

999: );
1000:
1001: IF l_result = OE_PC_GLOBALS.YES THEN
1002: -- set OUT result to CONSTRAINED
1003: x_result := OE_PC_GLOBALS.YES;
1004: END IF;
1005:
1006: END IF;
1007:

Line 1017: IF l_result = OE_PC_GLOBALS.YES THEN

1013: ,p_record => l_rowtype_rec
1014: ,x_on_operation_action => l_on_operation_action
1015: );
1016:
1017: IF l_result = OE_PC_GLOBALS.YES THEN
1018: -- set OUT result to CONSTRAINED
1019: x_result := OE_PC_GLOBALS.YES;
1020: END IF;
1021:

Line 1019: x_result := OE_PC_GLOBALS.YES;

1015: );
1016:
1017: IF l_result = OE_PC_GLOBALS.YES THEN
1018: -- set OUT result to CONSTRAINED
1019: x_result := OE_PC_GLOBALS.YES;
1020: END IF;
1021:
1022: END IF;
1023:

Line 1033: IF l_result = OE_PC_GLOBALS.YES THEN

1029: ,p_record => l_rowtype_rec
1030: ,x_on_operation_action => l_on_operation_action
1031: );
1032:
1033: IF l_result = OE_PC_GLOBALS.YES THEN
1034: -- set OUT result to CONSTRAINED
1035: x_result := OE_PC_GLOBALS.YES;
1036: END IF;
1037:

Line 1035: x_result := OE_PC_GLOBALS.YES;

1031: );
1032:
1033: IF l_result = OE_PC_GLOBALS.YES THEN
1034: -- set OUT result to CONSTRAINED
1035: x_result := OE_PC_GLOBALS.YES;
1036: END IF;
1037:
1038: END IF;
1039:

Line 1049: IF l_result = OE_PC_GLOBALS.YES THEN

1045: ,p_record => l_rowtype_rec
1046: ,x_on_operation_action => l_on_operation_action
1047: );
1048:
1049: IF l_result = OE_PC_GLOBALS.YES THEN
1050: -- set OUT result to CONSTRAINED
1051: x_result := OE_PC_GLOBALS.YES;
1052: END IF;
1053:

Line 1051: x_result := OE_PC_GLOBALS.YES;

1047: );
1048:
1049: IF l_result = OE_PC_GLOBALS.YES THEN
1050: -- set OUT result to CONSTRAINED
1051: x_result := OE_PC_GLOBALS.YES;
1052: END IF;
1053:
1054: END IF;
1055:

Line 1065: IF l_result = OE_PC_GLOBALS.YES THEN

1061: ,p_record => l_rowtype_rec
1062: ,x_on_operation_action => l_on_operation_action
1063: );
1064:
1065: IF l_result = OE_PC_GLOBALS.YES THEN
1066: -- set OUT result to CONSTRAINED
1067: x_result := OE_PC_GLOBALS.YES;
1068: END IF;
1069:

Line 1067: x_result := OE_PC_GLOBALS.YES;

1063: );
1064:
1065: IF l_result = OE_PC_GLOBALS.YES THEN
1066: -- set OUT result to CONSTRAINED
1067: x_result := OE_PC_GLOBALS.YES;
1068: END IF;
1069:
1070: END IF;
1071:

Line 1081: IF l_result = OE_PC_GLOBALS.YES THEN

1077: ,p_record => l_rowtype_rec
1078: ,x_on_operation_action => l_on_operation_action
1079: );
1080:
1081: IF l_result = OE_PC_GLOBALS.YES THEN
1082: -- set OUT result to CONSTRAINED
1083: x_result := OE_PC_GLOBALS.YES;
1084: END IF;
1085:

Line 1083: x_result := OE_PC_GLOBALS.YES;

1079: );
1080:
1081: IF l_result = OE_PC_GLOBALS.YES THEN
1082: -- set OUT result to CONSTRAINED
1083: x_result := OE_PC_GLOBALS.YES;
1084: END IF;
1085:
1086: END IF;
1087:

Line 1097: IF l_result = OE_PC_GLOBALS.YES THEN

1093: ,p_record => l_rowtype_rec
1094: ,x_on_operation_action => l_on_operation_action
1095: );
1096:
1097: IF l_result = OE_PC_GLOBALS.YES THEN
1098: -- set OUT result to CONSTRAINED
1099: x_result := OE_PC_GLOBALS.YES;
1100: END IF;
1101:

Line 1099: x_result := OE_PC_GLOBALS.YES;

1095: );
1096:
1097: IF l_result = OE_PC_GLOBALS.YES THEN
1098: -- set OUT result to CONSTRAINED
1099: x_result := OE_PC_GLOBALS.YES;
1100: END IF;
1101:
1102: END IF;
1103:

Line 1113: IF l_result = OE_PC_GLOBALS.YES THEN

1109: ,p_record => l_rowtype_rec
1110: ,x_on_operation_action => l_on_operation_action
1111: );
1112:
1113: IF l_result = OE_PC_GLOBALS.YES THEN
1114: -- set OUT result to CONSTRAINED
1115: x_result := OE_PC_GLOBALS.YES;
1116: END IF;
1117:

Line 1115: x_result := OE_PC_GLOBALS.YES;

1111: );
1112:
1113: IF l_result = OE_PC_GLOBALS.YES THEN
1114: -- set OUT result to CONSTRAINED
1115: x_result := OE_PC_GLOBALS.YES;
1116: END IF;
1117:
1118: END IF;
1119:

Line 1129: IF l_result = OE_PC_GLOBALS.YES THEN

1125: ,p_record => l_rowtype_rec
1126: ,x_on_operation_action => l_on_operation_action
1127: );
1128:
1129: IF l_result = OE_PC_GLOBALS.YES THEN
1130: -- set OUT result to CONSTRAINED
1131: x_result := OE_PC_GLOBALS.YES;
1132: END IF;
1133:

Line 1131: x_result := OE_PC_GLOBALS.YES;

1127: );
1128:
1129: IF l_result = OE_PC_GLOBALS.YES THEN
1130: -- set OUT result to CONSTRAINED
1131: x_result := OE_PC_GLOBALS.YES;
1132: END IF;
1133:
1134: END IF;
1135:

Line 1145: IF l_result = OE_PC_GLOBALS.YES THEN

1141: ,p_record => l_rowtype_rec
1142: ,x_on_operation_action => l_on_operation_action
1143: );
1144:
1145: IF l_result = OE_PC_GLOBALS.YES THEN
1146: -- set OUT result to CONSTRAINED
1147: x_result := OE_PC_GLOBALS.YES;
1148: END IF;
1149:

Line 1147: x_result := OE_PC_GLOBALS.YES;

1143: );
1144:
1145: IF l_result = OE_PC_GLOBALS.YES THEN
1146: -- set OUT result to CONSTRAINED
1147: x_result := OE_PC_GLOBALS.YES;
1148: END IF;
1149:
1150: END IF;
1151:

Line 1161: IF l_result = OE_PC_GLOBALS.YES THEN

1157: ,p_record => l_rowtype_rec
1158: ,x_on_operation_action => l_on_operation_action
1159: );
1160:
1161: IF l_result = OE_PC_GLOBALS.YES THEN
1162: -- set OUT result to CONSTRAINED
1163: x_result := OE_PC_GLOBALS.YES;
1164: END IF;
1165:

Line 1163: x_result := OE_PC_GLOBALS.YES;

1159: );
1160:
1161: IF l_result = OE_PC_GLOBALS.YES THEN
1162: -- set OUT result to CONSTRAINED
1163: x_result := OE_PC_GLOBALS.YES;
1164: END IF;
1165:
1166: END IF;
1167:

Line 1177: IF l_result = OE_PC_GLOBALS.YES THEN

1173: ,p_record => l_rowtype_rec
1174: ,x_on_operation_action => l_on_operation_action
1175: );
1176:
1177: IF l_result = OE_PC_GLOBALS.YES THEN
1178: -- set OUT result to CONSTRAINED
1179: x_result := OE_PC_GLOBALS.YES;
1180: END IF;
1181:

Line 1179: x_result := OE_PC_GLOBALS.YES;

1175: );
1176:
1177: IF l_result = OE_PC_GLOBALS.YES THEN
1178: -- set OUT result to CONSTRAINED
1179: x_result := OE_PC_GLOBALS.YES;
1180: END IF;
1181:
1182: END IF;
1183:

Line 1193: IF l_result = OE_PC_GLOBALS.YES THEN

1189: ,p_record => l_rowtype_rec
1190: ,x_on_operation_action => l_on_operation_action
1191: );
1192:
1193: IF l_result = OE_PC_GLOBALS.YES THEN
1194: -- set OUT result to CONSTRAINED
1195: x_result := OE_PC_GLOBALS.YES;
1196: END IF;
1197:

Line 1195: x_result := OE_PC_GLOBALS.YES;

1191: );
1192:
1193: IF l_result = OE_PC_GLOBALS.YES THEN
1194: -- set OUT result to CONSTRAINED
1195: x_result := OE_PC_GLOBALS.YES;
1196: END IF;
1197:
1198: END IF;
1199:

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

1196: END IF;
1197:
1198: END IF;
1199:
1200: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1201: IF l_debug_level > 0 THEN
1202: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1203: END IF;
1204: g_check_all_cols_constraint := l_check_all_cols_constraint;