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_GLOBALS

Line 96: not OE_GLOBALS.G_HEADER_CREATED THEN

92: -- Audit Trail Not Disabled
93: IF g_is_caller_defaulting = 'N' THEN
94: IF l_code_level >= '110508' and nvl(l_audit_trail_enabled,'D') <> 'D' and
95: nvl(l_transaction_phase_code,'F') = 'F' and
96: not OE_GLOBALS.G_HEADER_CREATED THEN
97: IF l_audit_trail_enabled = 'B' THEN -- capture only for booked orders
98: OPEN IS_ORDER_BOOKED (p_record.header_id);
99: FETCH IS_ORDER_BOOKED INTO l_order_booked_flag;
100: CLOSE IS_ORDER_BOOKED;

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

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 ) ;
107: END IF;
108: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
109: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
110: ELSIF x_on_operation_action = 2 THEN
111: -- set OUT result to NOT CONSTRAINED
112: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

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

105: IF l_debug_level > 0 THEN
106: oe_debug_pub.add( 'LINE SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
107: END IF;
108: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
109: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
110: ELSIF x_on_operation_action = 2 THEN
111: -- set OUT result to NOT CONSTRAINED
112: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
113: IF l_debug_level > 0 THEN

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

108: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
109: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
110: ELSIF x_on_operation_action = 2 THEN
111: -- set OUT result to NOT CONSTRAINED
112: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
113: IF l_debug_level > 0 THEN
114: oe_debug_pub.add( 'LINE SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
115: END IF;
116: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

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

112: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
113: IF l_debug_level > 0 THEN
114: oe_debug_pub.add( 'LINE SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
115: END IF;
116: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
117: END IF;
118: END IF;
119: END IF;
120: END IF;

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

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 ) ;
127: END IF;
128: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
129: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
130: ELSIF x_on_operation_action = 2 THEN
131: -- set OUT result to NOT CONSTRAINED
132: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

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

125: IF l_debug_level > 0 THEN
126: oe_debug_pub.add( 'LINE SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
127: END IF;
128: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
129: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
130: ELSIF x_on_operation_action = 2 THEN
131: -- set OUT result to NOT CONSTRAINED
132: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
133: IF l_debug_level > 0 THEN

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

128: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
129: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
130: ELSIF x_on_operation_action = 2 THEN
131: -- set OUT result to NOT CONSTRAINED
132: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
133: IF l_debug_level > 0 THEN
134: oe_debug_pub.add( 'LINE SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
135: END IF;
136: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

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

132: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
133: IF l_debug_level > 0 THEN
134: oe_debug_pub.add( 'LINE SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
135: END IF;
136: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
137: END IF;
138: END IF;
139: END IF;
140: END IF;

Line 730: IF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

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

Line 732: ELSIF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

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

Line 734: ELSIF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

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

Line 802: IF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

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

Line 819: ELSIF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

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

Line 840: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.percent,p_old_line_scredit_rec.percent) THEN

836: -- check constraints for all the changed attributes.
837:
838:
839: IF p_line_scredit_rec.percent = FND_API.G_MISS_NUM THEN NULL;
840: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.percent,p_old_line_scredit_rec.percent) THEN
841:
842: l_result := PERCENT
843: (p_operation => l_operation
844: ,p_record => l_rowtype_rec

Line 856: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.salesrep_id,p_old_line_scredit_rec.salesrep_id) THEN

852:
853: END IF;
854:
855: IF p_line_scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
856: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.salesrep_id,p_old_line_scredit_rec.salesrep_id) THEN
857:
858: l_result := SALESREP
859: (p_operation => l_operation
860: ,p_record => l_rowtype_rec

Line 872: ELSIF NOT OE_GLOBALS.Equal(p_line_scredit_rec.dw_update_advice_flag, p_old_line_scredit_rec.dw_update_advice_flag) THEN

868:
869: END IF;
870:
871: IF p_line_scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN NULL;
872: ELSIF NOT OE_GLOBALS.Equal(p_line_scredit_rec.dw_update_advice_flag, p_old_line_scredit_rec.dw_update_advice_flag) THEN
873:
874: l_result := DW_UPDATE_ADVICE
875: (p_operation => l_operation
876: ,p_record => l_rowtype_rec

Line 887: ELSIF NOT OE_GLOBALS.Equal(p_line_scredit_rec.wh_update_date, p_old_line_scredit_rec.wh_update_date) THEN

883:
884: END IF;
885:
886: IF p_line_scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN NULL;
887: ELSIF NOT OE_GLOBALS.Equal(p_line_scredit_rec.wh_update_date, p_old_line_scredit_rec.wh_update_date) THEN
888:
889: l_result := WH_UPDATE_DATE
890: (p_operation => l_operation
891: ,p_record => l_rowtype_rec

Line 919: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.context,p_old_line_scredit_rec.context) THEN

915: g_check_all_cols_constraint := 'N';
916: END IF;
917:
918: IF p_line_scredit_rec.context = FND_API.G_MISS_CHAR THEN NULL;
919: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.context,p_old_line_scredit_rec.context) THEN
920:
921: l_result := CONTEXT
922: (p_operation => l_operation
923: ,p_record => l_rowtype_rec

Line 935: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute1,p_old_line_scredit_rec.attribute1) THEN

931:
932: END IF;
933:
934: IF p_line_scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
935: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute1,p_old_line_scredit_rec.attribute1) THEN
936:
937: l_result := ATTRIBUTE1
938: (p_operation => l_operation
939: ,p_record => l_rowtype_rec

Line 951: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute10,p_old_line_scredit_rec.attribute10) THEN

947:
948: END IF;
949:
950: IF p_line_scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
951: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute10,p_old_line_scredit_rec.attribute10) THEN
952:
953: l_result := ATTRIBUTE10
954: (p_operation => l_operation
955: ,p_record => l_rowtype_rec

Line 967: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute11,p_old_line_scredit_rec.attribute11) THEN

963:
964: END IF;
965:
966: IF p_line_scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
967: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute11,p_old_line_scredit_rec.attribute11) THEN
968:
969: l_result := ATTRIBUTE11
970: (p_operation => l_operation
971: ,p_record => l_rowtype_rec

Line 983: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute12,p_old_line_scredit_rec.attribute12) THEN

979:
980: END IF;
981:
982: IF p_line_scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
983: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute12,p_old_line_scredit_rec.attribute12) THEN
984:
985: l_result := ATTRIBUTE12
986: (p_operation => l_operation
987: ,p_record => l_rowtype_rec

Line 999: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute13,p_old_line_scredit_rec.attribute13) THEN

995:
996: END IF;
997:
998: IF p_line_scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
999: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute13,p_old_line_scredit_rec.attribute13) THEN
1000:
1001: l_result := ATTRIBUTE13
1002: (p_operation => l_operation
1003: ,p_record => l_rowtype_rec

Line 1015: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute14,p_old_line_scredit_rec.attribute14) THEN

1011:
1012: END IF;
1013:
1014: IF p_line_scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
1015: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute14,p_old_line_scredit_rec.attribute14) THEN
1016:
1017: l_result := ATTRIBUTE14
1018: (p_operation => l_operation
1019: ,p_record => l_rowtype_rec

Line 1031: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute15,p_old_line_scredit_rec.attribute15) THEN

1027:
1028: END IF;
1029:
1030: IF p_line_scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
1031: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute15,p_old_line_scredit_rec.attribute15) THEN
1032:
1033: l_result := ATTRIBUTE15
1034: (p_operation => l_operation
1035: ,p_record => l_rowtype_rec

Line 1047: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute2,p_old_line_scredit_rec.attribute2) THEN

1043:
1044: END IF;
1045:
1046: IF p_line_scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
1047: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute2,p_old_line_scredit_rec.attribute2) THEN
1048:
1049: l_result := ATTRIBUTE2
1050: (p_operation => l_operation
1051: ,p_record => l_rowtype_rec

Line 1063: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute3,p_old_line_scredit_rec.attribute3) THEN

1059:
1060: END IF;
1061:
1062: IF p_line_scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
1063: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute3,p_old_line_scredit_rec.attribute3) THEN
1064:
1065: l_result := ATTRIBUTE3
1066: (p_operation => l_operation
1067: ,p_record => l_rowtype_rec

Line 1079: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute4,p_old_line_scredit_rec.attribute4) THEN

1075:
1076: END IF;
1077:
1078: IF p_line_scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
1079: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute4,p_old_line_scredit_rec.attribute4) THEN
1080:
1081: l_result := ATTRIBUTE4
1082: (p_operation => l_operation
1083: ,p_record => l_rowtype_rec

Line 1095: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute5,p_old_line_scredit_rec.attribute5) THEN

1091:
1092: END IF;
1093:
1094: IF p_line_scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
1095: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute5,p_old_line_scredit_rec.attribute5) THEN
1096:
1097: l_result := ATTRIBUTE5
1098: (p_operation => l_operation
1099: ,p_record => l_rowtype_rec

Line 1111: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute6,p_old_line_scredit_rec.attribute6) THEN

1107:
1108: END IF;
1109:
1110: IF p_line_scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
1111: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute6,p_old_line_scredit_rec.attribute6) THEN
1112:
1113: l_result := ATTRIBUTE6
1114: (p_operation => l_operation
1115: ,p_record => l_rowtype_rec

Line 1127: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute7,p_old_line_scredit_rec.attribute7) THEN

1123:
1124: END IF;
1125:
1126: IF p_line_scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
1127: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute7,p_old_line_scredit_rec.attribute7) THEN
1128:
1129: l_result := ATTRIBUTE7
1130: (p_operation => l_operation
1131: ,p_record => l_rowtype_rec

Line 1143: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute8,p_old_line_scredit_rec.attribute8) THEN

1139:
1140: END IF;
1141:
1142: IF p_line_scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
1143: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute8,p_old_line_scredit_rec.attribute8) THEN
1144:
1145: l_result := ATTRIBUTE8
1146: (p_operation => l_operation
1147: ,p_record => l_rowtype_rec

Line 1159: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute9,p_old_line_scredit_rec.attribute9) THEN

1155:
1156: END IF;
1157:
1158: IF p_line_scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
1159: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute9,p_old_line_scredit_rec.attribute9) THEN
1160:
1161: l_result := ATTRIBUTE9
1162: (p_operation => l_operation
1163: ,p_record => l_rowtype_rec

Line 1175: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.sales_credit_type_id,p_old_line_scredit_rec.sales_credit_type_id) THEN

1171:
1172: END IF;
1173:
1174: IF p_line_scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN NULL;
1175: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.sales_credit_type_id,p_old_line_scredit_rec.sales_credit_type_id) THEN
1176:
1177: l_result := SALES_CREDIT_TYPE
1178: (p_operation => l_operation
1179: ,p_record => l_rowtype_rec