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_GLOBALS

Line 106: not OE_GLOBALS.G_HEADER_CREATED THEN

102: -- Audit Trail Not Disabled
103: IF g_is_caller_defaulting = 'N' THEN
104: IF l_code_level >= '110508' and nvl(l_audit_trail_enabled,'D') <> 'D' and
105: nvl(l_transaction_phase_code,'F') = 'F' and
106: not OE_GLOBALS.G_HEADER_CREATED THEN
107: IF l_audit_trail_enabled = 'B' THEN -- capture only for booked orders
108: OPEN IS_ORDER_BOOKED (p_record.header_id);
109: FETCH IS_ORDER_BOOKED INTO l_order_booked_flag;
110: CLOSE IS_ORDER_BOOKED;

Line 118: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

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 ) ;
117: END IF;
118: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
119: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
120: ELSIF x_on_operation_action = 2 THEN
121: -- set OUT result to NOT CONSTRAINED
122: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

Line 119: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add( 'HEADER SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
117: END IF;
118: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
119: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
120: ELSIF x_on_operation_action = 2 THEN
121: -- set OUT result to NOT CONSTRAINED
122: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
123: IF l_debug_level > 0 THEN

Line 122: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

118: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
119: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
120: ELSIF x_on_operation_action = 2 THEN
121: -- set OUT result to NOT CONSTRAINED
122: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'HEADER SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
125: END IF;
126: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

Line 126: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

122: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'HEADER SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
125: END IF;
126: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
127: END IF;
128: END IF;
129: END IF;
130: END IF;

Line 138: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

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 ) ;
137: END IF;
138: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
139: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
140: ELSIF x_on_operation_action = 2 THEN
141: -- set OUT result to NOT CONSTRAINED
142: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

Line 139: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

135: IF l_debug_level > 0 THEN
136: oe_debug_pub.add( 'HEADER SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
137: END IF;
138: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
139: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
140: ELSIF x_on_operation_action = 2 THEN
141: -- set OUT result to NOT CONSTRAINED
142: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
143: IF l_debug_level > 0 THEN

Line 142: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

138: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
139: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
140: ELSIF x_on_operation_action = 2 THEN
141: -- set OUT result to NOT CONSTRAINED
142: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
143: IF l_debug_level > 0 THEN
144: oe_debug_pub.add( 'HEADER SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
145: END IF;
146: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

Line 146: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

142: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
143: IF l_debug_level > 0 THEN
144: oe_debug_pub.add( 'HEADER SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
145: END IF;
146: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
147: END IF;
148: END IF;
149: END IF;
150: END IF;

Line 740: IF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

736:
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

Line 742: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

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;
746: ELSE

Line 744: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

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
748: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

Line 812: IF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

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:
814: l_operation := OE_PC_GLOBALS.CREATE_OP;
815:
816: -- Bug 1755817: if there are no attribute-specific insert

Line 829: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

825: THEN
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 ) ;

Line 849: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.percent,p_old_header_scredit_rec.percent) THEN

845: -- Compare the new and old entity records and
846: -- check constraints for all the changed attributes.
847:
848: IF p_header_scredit_rec.percent = FND_API.G_MISS_NUM THEN NULL;
849: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.percent,p_old_header_scredit_rec.percent) THEN
850:
851: l_result := PERCENT
852: (p_operation => l_operation
853: ,p_record => l_rowtype_rec

Line 865: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.salesrep_id,p_old_header_scredit_rec.salesrep_id) THEN

861:
862: END IF;
863:
864: IF p_header_scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
865: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.salesrep_id,p_old_header_scredit_rec.salesrep_id) THEN
866:
867: l_result := SALESREP
868: (p_operation => l_operation
869: ,p_record => l_rowtype_rec

Line 881: ELSIF NOT OE_GLOBALS.Equal(p_header_scredit_rec.dw_update_advice_flag, p_old_header_scredit_rec.dw_update_advice_flag) THEN

877:
878: END IF;
879:
880: IF p_header_scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN NULL;
881: ELSIF NOT OE_GLOBALS.Equal(p_header_scredit_rec.dw_update_advice_flag, p_old_header_scredit_rec.dw_update_advice_flag) THEN
882:
883: l_result := DW_UPDATE_ADVICE
884: (p_operation => l_operation
885: ,p_record => l_rowtype_rec

Line 897: ELSIF NOT OE_GLOBALS.Equal(p_header_scredit_rec.wh_update_date, p_old_header_scredit_rec.wh_update_date) THEN

893: END IF;
894:
895:
896: IF p_header_scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN NULL;
897: ELSIF NOT OE_GLOBALS.Equal(p_header_scredit_rec.wh_update_date, p_old_header_scredit_rec.wh_update_date) THEN
898:
899: l_result := WH_UPDATE_DATE
900: (p_operation => l_operation
901: ,p_record => l_rowtype_rec

Line 929: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.context,p_old_header_scredit_rec.context) THEN

925: g_check_all_cols_constraint := 'N';
926: END IF;
927:
928: IF p_header_scredit_rec.context = FND_API.G_MISS_CHAR THEN NULL;
929: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.context,p_old_header_scredit_rec.context) THEN
930:
931: l_result := CONTEXT
932: (p_operation => l_operation
933: ,p_record => l_rowtype_rec

Line 945: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute1,p_old_header_scredit_rec.attribute1) THEN

941:
942: END IF;
943:
944: IF p_header_scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
945: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute1,p_old_header_scredit_rec.attribute1) THEN
946:
947: l_result := ATTRIBUTE1
948: (p_operation => l_operation
949: ,p_record => l_rowtype_rec

Line 961: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute10,p_old_header_scredit_rec.attribute10) THEN

957:
958: END IF;
959:
960: IF p_header_scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
961: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute10,p_old_header_scredit_rec.attribute10) THEN
962:
963: l_result := ATTRIBUTE10
964: (p_operation => l_operation
965: ,p_record => l_rowtype_rec

Line 977: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute11,p_old_header_scredit_rec.attribute11) THEN

973:
974: END IF;
975:
976: IF p_header_scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
977: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute11,p_old_header_scredit_rec.attribute11) THEN
978:
979: l_result := ATTRIBUTE11
980: (p_operation => l_operation
981: ,p_record => l_rowtype_rec

Line 993: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute12,p_old_header_scredit_rec.attribute12) THEN

989:
990: END IF;
991:
992: IF p_header_scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
993: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute12,p_old_header_scredit_rec.attribute12) THEN
994:
995: l_result := ATTRIBUTE12
996: (p_operation => l_operation
997: ,p_record => l_rowtype_rec

Line 1009: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute13,p_old_header_scredit_rec.attribute13) THEN

1005:
1006: END IF;
1007:
1008: IF p_header_scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
1009: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute13,p_old_header_scredit_rec.attribute13) THEN
1010:
1011: l_result := ATTRIBUTE13
1012: (p_operation => l_operation
1013: ,p_record => l_rowtype_rec

Line 1025: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute14,p_old_header_scredit_rec.attribute14) THEN

1021:
1022: END IF;
1023:
1024: IF p_header_scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
1025: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute14,p_old_header_scredit_rec.attribute14) THEN
1026:
1027: l_result := ATTRIBUTE14
1028: (p_operation => l_operation
1029: ,p_record => l_rowtype_rec

Line 1041: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute15,p_old_header_scredit_rec.attribute15) THEN

1037:
1038: END IF;
1039:
1040: IF p_header_scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
1041: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute15,p_old_header_scredit_rec.attribute15) THEN
1042:
1043: l_result := ATTRIBUTE15
1044: (p_operation => l_operation
1045: ,p_record => l_rowtype_rec

Line 1057: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute2,p_old_header_scredit_rec.attribute2) THEN

1053:
1054: END IF;
1055:
1056: IF p_header_scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
1057: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute2,p_old_header_scredit_rec.attribute2) THEN
1058:
1059: l_result := ATTRIBUTE2
1060: (p_operation => l_operation
1061: ,p_record => l_rowtype_rec

Line 1073: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute3,p_old_header_scredit_rec.attribute3) THEN

1069:
1070: END IF;
1071:
1072: IF p_header_scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
1073: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute3,p_old_header_scredit_rec.attribute3) THEN
1074:
1075: l_result := ATTRIBUTE3
1076: (p_operation => l_operation
1077: ,p_record => l_rowtype_rec

Line 1089: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute4,p_old_header_scredit_rec.attribute4) THEN

1085:
1086: END IF;
1087:
1088: IF p_header_scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
1089: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute4,p_old_header_scredit_rec.attribute4) THEN
1090:
1091: l_result := ATTRIBUTE4
1092: (p_operation => l_operation
1093: ,p_record => l_rowtype_rec

Line 1105: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute5,p_old_header_scredit_rec.attribute5) THEN

1101:
1102: END IF;
1103:
1104: IF p_header_scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
1105: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute5,p_old_header_scredit_rec.attribute5) THEN
1106:
1107: l_result := ATTRIBUTE5
1108: (p_operation => l_operation
1109: ,p_record => l_rowtype_rec

Line 1121: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute6,p_old_header_scredit_rec.attribute6) THEN

1117:
1118: END IF;
1119:
1120: IF p_header_scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
1121: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute6,p_old_header_scredit_rec.attribute6) THEN
1122:
1123: l_result := ATTRIBUTE6
1124: (p_operation => l_operation
1125: ,p_record => l_rowtype_rec

Line 1137: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute7,p_old_header_scredit_rec.attribute7) THEN

1133:
1134: END IF;
1135:
1136: IF p_header_scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
1137: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute7,p_old_header_scredit_rec.attribute7) THEN
1138:
1139: l_result := ATTRIBUTE7
1140: (p_operation => l_operation
1141: ,p_record => l_rowtype_rec

Line 1153: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute8,p_old_header_scredit_rec.attribute8) THEN

1149:
1150: END IF;
1151:
1152: IF p_header_scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
1153: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute8,p_old_header_scredit_rec.attribute8) THEN
1154:
1155: l_result := ATTRIBUTE8
1156: (p_operation => l_operation
1157: ,p_record => l_rowtype_rec

Line 1169: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute9,p_old_header_scredit_rec.attribute9) THEN

1165:
1166: END IF;
1167:
1168: IF p_header_scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
1169: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute9,p_old_header_scredit_rec.attribute9) THEN
1170:
1171: l_result := ATTRIBUTE9
1172: (p_operation => l_operation
1173: ,p_record => l_rowtype_rec

Line 1185: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.sales_credit_type_id,p_old_header_scredit_rec.sales_credit_type_id) THEN

1181:
1182: END IF;
1183:
1184: IF p_header_scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN NULL;
1185: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.sales_credit_type_id,p_old_header_scredit_rec.sales_credit_type_id) THEN
1186:
1187: l_result := SALES_CREDIT_TYPE
1188: (p_operation => l_operation
1189: ,p_record => l_rowtype_rec