DBA Data[Home] [Help]

APPS.OE_HEADER_PAYMENT_SECURITY dependencies on OE_GLOBALS

Line 879: IF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

875:
876: -- Initializing return status to SUCCESS
877: x_return_status := FND_API.G_RET_STS_SUCCESS;
878:
879: IF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
880: l_operation := OE_PC_GLOBALS.CREATE_OP;
881: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
882: l_operation := OE_PC_GLOBALS.UPDATE_OP;
883: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

Line 881: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

877: x_return_status := FND_API.G_RET_STS_SUCCESS;
878:
879: IF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
880: l_operation := OE_PC_GLOBALS.CREATE_OP;
881: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
882: l_operation := OE_PC_GLOBALS.UPDATE_OP;
883: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
884: l_operation := OE_PC_GLOBALS.DELETE_OP;
885: ELSE

Line 883: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

879: IF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
880: l_operation := OE_PC_GLOBALS.CREATE_OP;
881: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
882: l_operation := OE_PC_GLOBALS.UPDATE_OP;
883: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
884: l_operation := OE_PC_GLOBALS.DELETE_OP;
885: ELSE
886: IF l_debug_level > 0 THEN
887: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

Line 951: IF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

947: -- Initializing out result to NOT CONSTRAINED
948: x_result := OE_PC_GLOBALS.NO;
949:
950: -- Get the operation code to be passed to the security framework API
951: IF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
952:
953: l_operation := OE_PC_GLOBALS.CREATE_OP;
954:
955: -- Bug 1755817: if there are no attribute-specific insert

Line 968: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

964: THEN
965: RETURN;
966: END IF;
967:
968: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
969: l_operation := OE_PC_GLOBALS.UPDATE_OP;
970: ELSE
971: IF l_debug_level > 0 THEN
972: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

Line 988: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.payment_level_code,p_old_header_payment_rec.payment_level_code) THEN

984: -- Compare the new and old entity records and
985: -- check constraints for all the changed attributes.
986:
987: IF p_header_payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN NULL;
988: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.payment_level_code,p_old_header_payment_rec.payment_level_code) THEN
989:
990: l_result := PAYMENT_LEVEL_CODE
991: (p_operation => l_operation
992: ,p_record => l_rowtype_rec

Line 1004: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.commitment_applied_amount,p_old_header_payment_rec.commitment_applied_amount) THEN

1000:
1001: END IF;
1002:
1003: IF p_header_payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN NULL;
1004: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.commitment_applied_amount,p_old_header_payment_rec.commitment_applied_amount) THEN
1005:
1006: l_result := COMMITMENT_APPLIED_AMOUNT
1007: (p_operation => l_operation
1008: ,p_record => l_rowtype_rec

Line 1020: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_code,p_old_header_payment_rec.credit_card_code) THEN

1016:
1017: END IF;
1018:
1019: IF p_header_payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN NULL;
1020: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_code,p_old_header_payment_rec.credit_card_code) THEN
1021:
1022: l_result := CREDIT_CARD
1023: (p_operation => l_operation
1024: ,p_record => l_rowtype_rec

Line 1040: ELSIF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_payment_rec.credit_card_number,

1036: --the function same credit card to determine whether the old
1037: --and new card numbers are equal.
1038:
1039: IF p_header_payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN NULL;
1040: ELSIF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_payment_rec.credit_card_number,
1041: p_header_payment_rec.credit_card_number,
1042: p_old_header_payment_rec.cc_instrument_id,
1043: p_header_payment_rec.cc_instrument_id)
1044: THEN

Line 1059: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_holder_name,p_old_header_payment_rec.credit_card_holder_name) THEN

1055:
1056: END IF;
1057:
1058: IF p_header_payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN NULL;
1059: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_holder_name,p_old_header_payment_rec.credit_card_holder_name) THEN
1060:
1061: l_result := CREDIT_CARD_HOLDER_NAME
1062: (p_operation => l_operation
1063: ,p_record => l_rowtype_rec

Line 1075: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_expiration_date,p_old_header_payment_rec.credit_card_expiration_date) THEN

1071:
1072: END IF;
1073:
1074: IF p_header_payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN NULL;
1075: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_expiration_date,p_old_header_payment_rec.credit_card_expiration_date) THEN
1076:
1077: l_result := CREDIT_CARD_EXPIRATION_DATE
1078: (p_operation => l_operation
1079: ,p_record => l_rowtype_rec

Line 1091: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_approval_code,p_old_header_payment_rec.credit_card_approval_code) THEN

1087:
1088: END IF;
1089:
1090: IF p_header_payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN NULL;
1091: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_approval_code,p_old_header_payment_rec.credit_card_approval_code) THEN
1092:
1093: l_result := CREDIT_CARD_APPROVAL
1094: (p_operation => l_operation
1095: ,p_record => l_rowtype_rec

Line 1107: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_approval_date,p_old_header_payment_rec.credit_card_approval_date) THEN

1103:
1104: END IF;
1105:
1106: IF p_header_payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN NULL;
1107: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_approval_date,p_old_header_payment_rec.credit_card_approval_date) THEN
1108:
1109: l_result := CREDIT_CARD_APPROVAL_DATE
1110: (p_operation => l_operation
1111: ,p_record => l_rowtype_rec

Line 1123: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.payment_amount,p_old_header_payment_rec.payment_amount) THEN

1119:
1120: END IF;
1121:
1122: IF p_header_payment_rec.payment_amount = FND_API.G_MISS_NUM THEN NULL;
1123: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.payment_amount,p_old_header_payment_rec.payment_amount) THEN
1124:
1125: l_result := PAYMENT_AMOUNT
1126: (p_operation => l_operation
1127: ,p_record => l_rowtype_rec

Line 1139: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.payment_type_code,p_old_header_payment_rec.payment_type_code) THEN

1135:
1136: END IF;
1137:
1138: IF p_header_payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN NULL;
1139: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.payment_type_code,p_old_header_payment_rec.payment_type_code) THEN
1140:
1141: l_result := PAYMENT_TYPE_CODE
1142: (p_operation => l_operation
1143: ,p_record => l_rowtype_rec

Line 1155: ELSIF NOT OE_GLOBALS.Equal(p_header_payment_rec.payment_trx_id, p_old_header_payment_rec.payment_trx_id) THEN

1151:
1152: END IF;
1153:
1154: IF p_header_payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN NULL;
1155: ELSIF NOT OE_GLOBALS.Equal(p_header_payment_rec.payment_trx_id, p_old_header_payment_rec.payment_trx_id) THEN
1156:
1157: l_result := PAYMENT_TRX
1158: (p_operation => l_operation
1159: ,p_record => l_rowtype_rec

Line 1171: ELSIF NOT OE_GLOBALS.Equal(p_header_payment_rec.receipt_method_id, p_old_header_payment_rec.receipt_method_id) THEN

1167: END IF;
1168:
1169:
1170: IF p_header_payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN NULL;
1171: ELSIF NOT OE_GLOBALS.Equal(p_header_payment_rec.receipt_method_id, p_old_header_payment_rec.receipt_method_id) THEN
1172:
1173: l_result := RECEIPT_METHOD
1174: (p_operation => l_operation
1175: ,p_record => l_rowtype_rec

Line 1187: ELSIF NOT OE_GLOBALS.Equal(p_header_payment_rec.payment_collection_event, p_old_header_payment_rec.payment_collection_event) THEN

1183: END IF;
1184:
1185:
1186: IF p_header_payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN NULL;
1187: ELSIF NOT OE_GLOBALS.Equal(p_header_payment_rec.payment_collection_event, p_old_header_payment_rec.payment_collection_event) THEN
1188:
1189: l_result := PAYMENT_COLLECTION_EVENT
1190: (p_operation => l_operation
1191: ,p_record => l_rowtype_rec

Line 1202: ELSIF NOT OE_GLOBALS.Equal(p_header_payment_rec.check_number, p_old_header_payment_rec.check_number) THEN

1198:
1199: END IF;
1200:
1201: IF p_header_payment_rec.check_number = FND_API.G_MISS_CHAR THEN NULL;
1202: ELSIF NOT OE_GLOBALS.Equal(p_header_payment_rec.check_number, p_old_header_payment_rec.check_number) THEN
1203:
1204: l_result := CHECK_NUMBER
1205: (p_operation => l_operation
1206: ,p_record => l_rowtype_rec

Line 1233: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.context,p_old_header_payment_rec.context) THEN

1229: g_check_all_cols_constraint := 'N';
1230: END IF;
1231:
1232: IF p_header_payment_rec.context = FND_API.G_MISS_CHAR THEN NULL;
1233: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.context,p_old_header_payment_rec.context) THEN
1234:
1235: l_result := CONTEXT
1236: (p_operation => l_operation
1237: ,p_record => l_rowtype_rec

Line 1249: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute1,p_old_header_payment_rec.attribute1) THEN

1245:
1246: END IF;
1247:
1248: IF p_header_payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
1249: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute1,p_old_header_payment_rec.attribute1) THEN
1250:
1251: l_result := ATTRIBUTE1
1252: (p_operation => l_operation
1253: ,p_record => l_rowtype_rec

Line 1265: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute10,p_old_header_payment_rec.attribute10) THEN

1261:
1262: END IF;
1263:
1264: IF p_header_payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
1265: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute10,p_old_header_payment_rec.attribute10) THEN
1266:
1267: l_result := ATTRIBUTE10
1268: (p_operation => l_operation
1269: ,p_record => l_rowtype_rec

Line 1281: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute11,p_old_header_payment_rec.attribute11) THEN

1277:
1278: END IF;
1279:
1280: IF p_header_payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
1281: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute11,p_old_header_payment_rec.attribute11) THEN
1282:
1283: l_result := ATTRIBUTE11
1284: (p_operation => l_operation
1285: ,p_record => l_rowtype_rec

Line 1297: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute12,p_old_header_payment_rec.attribute12) THEN

1293:
1294: END IF;
1295:
1296: IF p_header_payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
1297: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute12,p_old_header_payment_rec.attribute12) THEN
1298:
1299: l_result := ATTRIBUTE12
1300: (p_operation => l_operation
1301: ,p_record => l_rowtype_rec

Line 1313: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute13,p_old_header_payment_rec.attribute13) THEN

1309:
1310: END IF;
1311:
1312: IF p_header_payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
1313: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute13,p_old_header_payment_rec.attribute13) THEN
1314:
1315: l_result := ATTRIBUTE13
1316: (p_operation => l_operation
1317: ,p_record => l_rowtype_rec

Line 1329: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute14,p_old_header_payment_rec.attribute14) THEN

1325:
1326: END IF;
1327:
1328: IF p_header_payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
1329: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute14,p_old_header_payment_rec.attribute14) THEN
1330:
1331: l_result := ATTRIBUTE14
1332: (p_operation => l_operation
1333: ,p_record => l_rowtype_rec

Line 1345: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute15,p_old_header_payment_rec.attribute15) THEN

1341:
1342: END IF;
1343:
1344: IF p_header_payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
1345: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute15,p_old_header_payment_rec.attribute15) THEN
1346:
1347: l_result := ATTRIBUTE15
1348: (p_operation => l_operation
1349: ,p_record => l_rowtype_rec

Line 1361: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute2,p_old_header_payment_rec.attribute2) THEN

1357:
1358: END IF;
1359:
1360: IF p_header_payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
1361: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute2,p_old_header_payment_rec.attribute2) THEN
1362:
1363: l_result := ATTRIBUTE2
1364: (p_operation => l_operation
1365: ,p_record => l_rowtype_rec

Line 1377: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute3,p_old_header_payment_rec.attribute3) THEN

1373:
1374: END IF;
1375:
1376: IF p_header_payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
1377: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute3,p_old_header_payment_rec.attribute3) THEN
1378:
1379: l_result := ATTRIBUTE3
1380: (p_operation => l_operation
1381: ,p_record => l_rowtype_rec

Line 1393: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute4,p_old_header_payment_rec.attribute4) THEN

1389:
1390: END IF;
1391:
1392: IF p_header_payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
1393: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute4,p_old_header_payment_rec.attribute4) THEN
1394:
1395: l_result := ATTRIBUTE4
1396: (p_operation => l_operation
1397: ,p_record => l_rowtype_rec

Line 1409: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute5,p_old_header_payment_rec.attribute5) THEN

1405:
1406: END IF;
1407:
1408: IF p_header_payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
1409: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute5,p_old_header_payment_rec.attribute5) THEN
1410:
1411: l_result := ATTRIBUTE5
1412: (p_operation => l_operation
1413: ,p_record => l_rowtype_rec

Line 1425: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute6,p_old_header_payment_rec.attribute6) THEN

1421:
1422: END IF;
1423:
1424: IF p_header_payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
1425: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute6,p_old_header_payment_rec.attribute6) THEN
1426:
1427: l_result := ATTRIBUTE6
1428: (p_operation => l_operation
1429: ,p_record => l_rowtype_rec

Line 1441: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute7,p_old_header_payment_rec.attribute7) THEN

1437:
1438: END IF;
1439:
1440: IF p_header_payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
1441: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute7,p_old_header_payment_rec.attribute7) THEN
1442:
1443: l_result := ATTRIBUTE7
1444: (p_operation => l_operation
1445: ,p_record => l_rowtype_rec

Line 1457: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute8,p_old_header_payment_rec.attribute8) THEN

1453:
1454: END IF;
1455:
1456: IF p_header_payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
1457: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute8,p_old_header_payment_rec.attribute8) THEN
1458:
1459: l_result := ATTRIBUTE8
1460: (p_operation => l_operation
1461: ,p_record => l_rowtype_rec

Line 1473: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute9,p_old_header_payment_rec.attribute9) THEN

1469:
1470: END IF;
1471:
1472: IF p_header_payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
1473: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute9,p_old_header_payment_rec.attribute9) THEN
1474:
1475: l_result := ATTRIBUTE9
1476: (p_operation => l_operation
1477: ,p_record => l_rowtype_rec