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.IBY_CREDITCARD_PKG dependencies on FND_API

Line 132: (FND_API.G_FALSE,l_site_use_rec,l_site_use_id,

128: l_site_use_rec.site_use_type := G_CC_BILLING_SITE_USE;
129: l_site_use_rec.created_by_module := 'TCA_V2_API';
130:
131: HZ_PARTY_SITE_V2PUB.Create_Party_Site_Use
132: (FND_API.G_FALSE,l_site_use_rec,l_site_use_id,
133: lx_return_status,lx_msg_count,lx_msg_data
134: );
135: END IF;
136: END IF;

Line 255: IF FND_API.To_Boolean(p_commit) THEN

251: fnd_global.login_id, 1
252: FROM iby_creditcard
253: WHERE (instrid = p_instr_id);
254:
255: IF FND_API.To_Boolean(p_commit) THEN
256: COMMIT;
257: END IF;
258: END Archive_Card;
259:

Line 500: (1.0, FND_API.G_FALSE, p_card_number,

496: RETURN;
497: END IF;
498:
499: iby_cc_validate.StripCC
500: (1.0, FND_API.G_FALSE, p_card_number,
501: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number
502: );
503:
504: IF( (lx_cc_number IS NULL) OR

Line 506: lx_return_status <> FND_API.G_RET_STS_SUCCESS) )

502: );
503:
504: IF( (lx_cc_number IS NULL) OR
505: (lx_return_status IS NULL OR
506: lx_return_status <> FND_API.G_RET_STS_SUCCESS) )
507: THEN
508: x_result_code := G_RC_INVALID_CCNUMBER;
509: RETURN;
510: END IF;

Line 573: IF (p_billing_address_id = FND_API.G_MISS_NUM ) THEN

569: -- If Site use id is already provied then no need to call get_billing address
570: /*IF (p_address_type = G_PARTY_SITE_USE_ID) AND (NOT (p_billing_address_id IS NULL)) THEN
571: l_billing_site := p_billing_address_id;
572: ELSE
573: IF (p_billing_address_id = FND_API.G_MISS_NUM ) THEN
574: l_billing_site := FND_API.G_MISS_NUM;
575: ELSIF (NOT (p_billing_address_id IS NULL)) THEN
576: l_billing_site := Get_Billing_Site(p_billing_address_id,p_owner_id);
577: IF (l_billing_site IS NULL) THEN

Line 574: l_billing_site := FND_API.G_MISS_NUM;

570: /*IF (p_address_type = G_PARTY_SITE_USE_ID) AND (NOT (p_billing_address_id IS NULL)) THEN
571: l_billing_site := p_billing_address_id;
572: ELSE
573: IF (p_billing_address_id = FND_API.G_MISS_NUM ) THEN
574: l_billing_site := FND_API.G_MISS_NUM;
575: ELSIF (NOT (p_billing_address_id IS NULL)) THEN
576: l_billing_site := Get_Billing_Site(p_billing_address_id,p_owner_id);
577: IF (l_billing_site IS NULL) THEN
578: x_result_code := G_RC_INVALID_ADDRESS;

Line 587: OR (p_billing_country = FND_API.G_MISS_CHAR) )

583: -- Bug 5153265 end
584:
585:
586: IF (NOT ( (p_billing_country IS NULL)
587: OR (p_billing_country = FND_API.G_MISS_CHAR) )
588: )
589: THEN
590: IF (NOT iby_utility_pvt.Validate_Territory(p_billing_country)) THEN
591: x_result_code := G_RC_INVALID_ADDRESS;

Line 627: (FND_API.G_FALSE,l_cc_ciphertext,iby_security_pkg.G_ENCODING_NUMERIC,

623: IF (NOT lx_cc_compressed IS NULL) THEN
624: l_cc_ciphertext :=
625: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_cc_compressed,TRUE));
626: IBY_SECURITY_PKG.Create_Segment
627: (FND_API.G_FALSE,l_cc_ciphertext,iby_security_pkg.G_ENCODING_NUMERIC,
628: p_sys_sec_key,lx_sec_segment_id);
629: END IF;
630: lx_cc_number := NVL(lx_unmasked_digits,'0');
631:

Line 739: IF FND_API.To_Boolean(p_commit) THEN

735: -- clear the error codes that might have got assigned to the x_result_code parameter
736: -- during invalid credit card registration
737: x_result_code := NULL;
738:
739: IF FND_API.To_Boolean(p_commit) THEN
740: COMMIT;
741: END IF;
742: END Create_Card;
743:

Line 862: IF (p_billing_address_id = FND_API.G_MISS_NUM ) THEN

858: -- If Site use id is already provied then no need to call get_billing address
859: IF (p_address_type = G_PARTY_SITE_USE_ID) AND (NOT (p_billing_address_id IS NULL)) THEN
860: l_billing_site := p_billing_address_id;
861: ELSE
862: IF (p_billing_address_id = FND_API.G_MISS_NUM ) THEN
863: l_billing_site := FND_API.G_MISS_NUM;
864: ELSIF (NOT (p_billing_address_id IS NULL)) THEN
865: l_billing_site := Get_Billing_Site(p_billing_address_id,p_owner_id);
866: IF (l_billing_site IS NULL) THEN

Line 863: l_billing_site := FND_API.G_MISS_NUM;

859: IF (p_address_type = G_PARTY_SITE_USE_ID) AND (NOT (p_billing_address_id IS NULL)) THEN
860: l_billing_site := p_billing_address_id;
861: ELSE
862: IF (p_billing_address_id = FND_API.G_MISS_NUM ) THEN
863: l_billing_site := FND_API.G_MISS_NUM;
864: ELSIF (NOT (p_billing_address_id IS NULL)) THEN
865: l_billing_site := Get_Billing_Site(p_billing_address_id,p_owner_id);
866: IF (l_billing_site IS NULL) THEN
867: x_result_code := G_RC_INVALID_ADDRESS;

Line 875: OR (p_billing_country = FND_API.G_MISS_CHAR) )

871: END IF;
872: -- Bug 5153265 end
873:
874: IF (NOT ( (p_billing_country IS NULL)
875: OR (p_billing_country = FND_API.G_MISS_CHAR) )
876: )
877: THEN
878: IF (NOT iby_utility_pvt.Validate_Territory(p_billing_country)) THEN
879: x_result_code := G_RC_INVALID_ADDRESS;

Line 887: IF(p_holder_name = FND_API.G_MISS_CHAR)THEN

883:
884: -- To be removed
885: /* iby_debug_pub.add('expiry date passed as:'||p_expiry_date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
886: iby_debug_pub.add('holder name:'||p_holder_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
887: IF(p_holder_name = FND_API.G_MISS_CHAR)THEN
888: iby_debug_pub.add('holder name is FND_API.G_MISS_CHAR.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
889: END IF;*/
890: ---------------------
891:

Line 888: iby_debug_pub.add('holder name is FND_API.G_MISS_CHAR.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

884: -- To be removed
885: /* iby_debug_pub.add('expiry date passed as:'||p_expiry_date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
886: iby_debug_pub.add('holder name:'||p_holder_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
887: IF(p_holder_name = FND_API.G_MISS_CHAR)THEN
888: iby_debug_pub.add('holder name is FND_API.G_MISS_CHAR.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
889: END IF;*/
890: ---------------------
891:
892: -- Bug 5479785 (Panaraya)

Line 951: IF (p_holder_name = FND_API.G_MISS_CHAR) THEN

947: l_expdate_sec_segment_id := null;
948: END IF;
949:
950: /*
951: IF (p_holder_name = FND_API.G_MISS_CHAR) THEN
952: iby_debug_pub.add('chname passed: G_MISS_CHAR',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
953: END IF;
954: iby_debug_pub.add('chname passed:'||p_holder_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
955: */

Line 960: ((p_holder_name IS NOT NULL) AND (p_holder_name <> FND_API.G_MISS_CHAR))

956:
957: -- No need for the http request if the expiry date and chname
958: -- are not expected to be updated
959: IF((l_expiry_date IS NOT NULL) OR
960: ((p_holder_name IS NOT NULL) AND (p_holder_name <> FND_API.G_MISS_CHAR))
961: ) THEN
962:
963: IBY_INSTRREG_PUB.SecureCardInfo(l_expiry_date,
964: l_expdate_sec_segment_id,

Line 974: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

970: l_msg_count,
971: l_msg_data,
972: l_resp_rec
973: );
974: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
975: iby_debug_pub.add('Error during http call out',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
976: x_result_code := FND_API.G_RET_STS_ERROR;
977: RETURN;
978: END IF;

Line 976: x_result_code := FND_API.G_RET_STS_ERROR;

972: l_resp_rec
973: );
974: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
975: iby_debug_pub.add('Error during http call out',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
976: x_result_code := FND_API.G_RET_STS_ERROR;
977: RETURN;
978: END IF;
979:
980: l_chname_sec_segment_id := l_resp_rec.ChnameSegmentId;

Line 1010: Archive_Card(FND_API.G_FALSE,p_instr_id,l_history_id);

1006: l_masked_chname := l_chname;
1007:
1008: END IF;
1009:
1010: Archive_Card(FND_API.G_FALSE,p_instr_id,l_history_id);
1011:
1012:
1013: UPDATE iby_creditcard
1014: SET chname = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL, NULL,chname, l_masked_chname),

Line 1014: SET chname = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL, NULL,chname, l_masked_chname),

1010: Archive_Card(FND_API.G_FALSE,p_instr_id,l_history_id);
1011:
1012:
1013: UPDATE iby_creditcard
1014: SET chname = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL, NULL,chname, l_masked_chname),
1015: chname_sec_segment_id = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,
1016: NULL,chname_sec_segment_id,l_chname_sec_segment_id),
1017: chname_mask_setting = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,
1018: NULL,chname_mask_setting,l_chname_mask_setting),

Line 1015: chname_sec_segment_id = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,

1011:
1012:
1013: UPDATE iby_creditcard
1014: SET chname = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL, NULL,chname, l_masked_chname),
1015: chname_sec_segment_id = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,
1016: NULL,chname_sec_segment_id,l_chname_sec_segment_id),
1017: chname_mask_setting = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,
1018: NULL,chname_mask_setting,l_chname_mask_setting),
1019: chname_unmask_length = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,

Line 1017: chname_mask_setting = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,

1013: UPDATE iby_creditcard
1014: SET chname = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL, NULL,chname, l_masked_chname),
1015: chname_sec_segment_id = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,
1016: NULL,chname_sec_segment_id,l_chname_sec_segment_id),
1017: chname_mask_setting = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,
1018: NULL,chname_mask_setting,l_chname_mask_setting),
1019: chname_unmask_length = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,
1020: NULL,chname_unmask_length,l_chname_unmask_len),
1021: card_owner_id = NVL(card_owner_id,p_owner_id),

Line 1019: chname_unmask_length = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,

1015: chname_sec_segment_id = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,
1016: NULL,chname_sec_segment_id,l_chname_sec_segment_id),
1017: chname_mask_setting = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,
1018: NULL,chname_mask_setting,l_chname_mask_setting),
1019: chname_unmask_length = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,
1020: NULL,chname_unmask_length,l_chname_unmask_len),
1021: card_owner_id = NVL(card_owner_id,p_owner_id),
1022: addressid = DECODE(l_billing_site, FND_API.G_MISS_NUM,NULL,
1023: NULL,addressid, l_billing_site),

Line 1022: addressid = DECODE(l_billing_site, FND_API.G_MISS_NUM,NULL,

1018: NULL,chname_mask_setting,l_chname_mask_setting),
1019: chname_unmask_length = DECODE(l_chname, FND_API.G_MISS_CHAR,NULL,
1020: NULL,chname_unmask_length,l_chname_unmask_len),
1021: card_owner_id = NVL(card_owner_id,p_owner_id),
1022: addressid = DECODE(l_billing_site, FND_API.G_MISS_NUM,NULL,
1023: NULL,addressid, l_billing_site),
1024: bill_addr_territory_code =
1025: DECODE(p_billing_country, FND_API.G_MISS_CHAR,NULL,
1026: NULL,bill_addr_territory_code, p_billing_country),

Line 1025: DECODE(p_billing_country, FND_API.G_MISS_CHAR,NULL,

1021: card_owner_id = NVL(card_owner_id,p_owner_id),
1022: addressid = DECODE(l_billing_site, FND_API.G_MISS_NUM,NULL,
1023: NULL,addressid, l_billing_site),
1024: bill_addr_territory_code =
1025: DECODE(p_billing_country, FND_API.G_MISS_CHAR,NULL,
1026: NULL,bill_addr_territory_code, p_billing_country),
1027: billing_addr_postal_code =
1028: DECODE(p_billing_zip, FND_API.G_MISS_CHAR,NULL,
1029: NULL,billing_addr_postal_code, p_billing_zip),

Line 1028: DECODE(p_billing_zip, FND_API.G_MISS_CHAR,NULL,

1024: bill_addr_territory_code =
1025: DECODE(p_billing_country, FND_API.G_MISS_CHAR,NULL,
1026: NULL,bill_addr_territory_code, p_billing_country),
1027: billing_addr_postal_code =
1028: DECODE(p_billing_zip, FND_API.G_MISS_CHAR,NULL,
1029: NULL,billing_addr_postal_code, p_billing_zip),
1030: -- expirydate = NVL(p_expiry_date, expirydate),
1031: expirydate = DECODE(p_expiry_date, NULL, expirydate, l_expiry_date),
1032: expiry_sec_segment_id = DECODE(p_expiry_date, NULL, expiry_sec_segment_id,

Line 1039: DECODE(p_pcard_type, FND_API.G_MISS_CHAR,NULL,

1035: encrypted = l_encrypted,
1036: instrument_type = NVL(p_instr_type, instrument_type),
1037: purchasecard_flag = NVL(p_pcard_flag, purchasecard_flag),
1038: purchasecard_subtype =
1039: DECODE(p_pcard_type, FND_API.G_MISS_CHAR,NULL,
1040: NULL,purchasecard_subtype, p_pcard_type),
1041: finame = DECODE(p_fi_name, FND_API.G_MISS_CHAR,NULL, NULL,finame, p_fi_name),
1042: single_use_flag = NVL(p_single_use, single_use_flag),
1043: information_only_flag = NVL(p_info_only, information_only_flag),

Line 1041: finame = DECODE(p_fi_name, FND_API.G_MISS_CHAR,NULL, NULL,finame, p_fi_name),

1037: purchasecard_flag = NVL(p_pcard_flag, purchasecard_flag),
1038: purchasecard_subtype =
1039: DECODE(p_pcard_type, FND_API.G_MISS_CHAR,NULL,
1040: NULL,purchasecard_subtype, p_pcard_type),
1041: finame = DECODE(p_fi_name, FND_API.G_MISS_CHAR,NULL, NULL,finame, p_fi_name),
1042: single_use_flag = NVL(p_single_use, single_use_flag),
1043: information_only_flag = NVL(p_info_only, information_only_flag),
1044: card_purpose = DECODE(p_purpose, FND_API.G_MISS_CHAR,NULL, NULL,card_purpose, p_purpose),
1045: description = DECODE(p_desc, FND_API.G_MISS_CHAR,NULL, NULL,description, p_desc),

Line 1044: card_purpose = DECODE(p_purpose, FND_API.G_MISS_CHAR,NULL, NULL,card_purpose, p_purpose),

1040: NULL,purchasecard_subtype, p_pcard_type),
1041: finame = DECODE(p_fi_name, FND_API.G_MISS_CHAR,NULL, NULL,finame, p_fi_name),
1042: single_use_flag = NVL(p_single_use, single_use_flag),
1043: information_only_flag = NVL(p_info_only, information_only_flag),
1044: card_purpose = DECODE(p_purpose, FND_API.G_MISS_CHAR,NULL, NULL,card_purpose, p_purpose),
1045: description = DECODE(p_desc, FND_API.G_MISS_CHAR,NULL, NULL,description, p_desc),
1046: active_flag = NVL(p_active_flag, active_flag),
1047: inactive_date = DECODE(p_inactive_date, FND_API.G_MISS_DATE,NULL,
1048: NULL,inactive_date, p_inactive_date),

Line 1045: description = DECODE(p_desc, FND_API.G_MISS_CHAR,NULL, NULL,description, p_desc),

1041: finame = DECODE(p_fi_name, FND_API.G_MISS_CHAR,NULL, NULL,finame, p_fi_name),
1042: single_use_flag = NVL(p_single_use, single_use_flag),
1043: information_only_flag = NVL(p_info_only, information_only_flag),
1044: card_purpose = DECODE(p_purpose, FND_API.G_MISS_CHAR,NULL, NULL,card_purpose, p_purpose),
1045: description = DECODE(p_desc, FND_API.G_MISS_CHAR,NULL, NULL,description, p_desc),
1046: active_flag = NVL(p_active_flag, active_flag),
1047: inactive_date = DECODE(p_inactive_date, FND_API.G_MISS_DATE,NULL,
1048: NULL,inactive_date, p_inactive_date),
1049: object_version_number = object_version_number + 1,

Line 1047: inactive_date = DECODE(p_inactive_date, FND_API.G_MISS_DATE,NULL,

1043: information_only_flag = NVL(p_info_only, information_only_flag),
1044: card_purpose = DECODE(p_purpose, FND_API.G_MISS_CHAR,NULL, NULL,card_purpose, p_purpose),
1045: description = DECODE(p_desc, FND_API.G_MISS_CHAR,NULL, NULL,description, p_desc),
1046: active_flag = NVL(p_active_flag, active_flag),
1047: inactive_date = DECODE(p_inactive_date, FND_API.G_MISS_DATE,NULL,
1048: NULL,inactive_date, p_inactive_date),
1049: object_version_number = object_version_number + 1,
1050: last_update_date = sysdate,
1051: last_updated_by = fnd_global.user_id,

Line 1054: attribute1 = DECODE(p_attribute1,FND_API.G_MISS_CHAR,NULL,NULL,attribute1, p_attribute1),

1050: last_update_date = sysdate,
1051: last_updated_by = fnd_global.user_id,
1052: last_update_login = fnd_global.login_id,
1053: attribute_category = p_Attribute_category,
1054: attribute1 = DECODE(p_attribute1,FND_API.G_MISS_CHAR,NULL,NULL,attribute1, p_attribute1),
1055: attribute2 = DECODE(p_attribute2,FND_API.G_MISS_CHAR,NULL,NULL,attribute2, p_attribute2),
1056: attribute3 = DECODE(p_attribute3,FND_API.G_MISS_CHAR,NULL,NULL,attribute3, p_attribute3),
1057: attribute4 = DECODE(p_attribute4,FND_API.G_MISS_CHAR,NULL,NULL,attribute4, p_attribute4),
1058: attribute5 = DECODE(p_attribute5,FND_API.G_MISS_CHAR,NULL,NULL,attribute5, p_attribute5),

Line 1055: attribute2 = DECODE(p_attribute2,FND_API.G_MISS_CHAR,NULL,NULL,attribute2, p_attribute2),

1051: last_updated_by = fnd_global.user_id,
1052: last_update_login = fnd_global.login_id,
1053: attribute_category = p_Attribute_category,
1054: attribute1 = DECODE(p_attribute1,FND_API.G_MISS_CHAR,NULL,NULL,attribute1, p_attribute1),
1055: attribute2 = DECODE(p_attribute2,FND_API.G_MISS_CHAR,NULL,NULL,attribute2, p_attribute2),
1056: attribute3 = DECODE(p_attribute3,FND_API.G_MISS_CHAR,NULL,NULL,attribute3, p_attribute3),
1057: attribute4 = DECODE(p_attribute4,FND_API.G_MISS_CHAR,NULL,NULL,attribute4, p_attribute4),
1058: attribute5 = DECODE(p_attribute5,FND_API.G_MISS_CHAR,NULL,NULL,attribute5, p_attribute5),
1059: attribute6 = DECODE(p_attribute6,FND_API.G_MISS_CHAR,NULL,NULL,attribute6, p_attribute6),

Line 1056: attribute3 = DECODE(p_attribute3,FND_API.G_MISS_CHAR,NULL,NULL,attribute3, p_attribute3),

1052: last_update_login = fnd_global.login_id,
1053: attribute_category = p_Attribute_category,
1054: attribute1 = DECODE(p_attribute1,FND_API.G_MISS_CHAR,NULL,NULL,attribute1, p_attribute1),
1055: attribute2 = DECODE(p_attribute2,FND_API.G_MISS_CHAR,NULL,NULL,attribute2, p_attribute2),
1056: attribute3 = DECODE(p_attribute3,FND_API.G_MISS_CHAR,NULL,NULL,attribute3, p_attribute3),
1057: attribute4 = DECODE(p_attribute4,FND_API.G_MISS_CHAR,NULL,NULL,attribute4, p_attribute4),
1058: attribute5 = DECODE(p_attribute5,FND_API.G_MISS_CHAR,NULL,NULL,attribute5, p_attribute5),
1059: attribute6 = DECODE(p_attribute6,FND_API.G_MISS_CHAR,NULL,NULL,attribute6, p_attribute6),
1060: attribute7 = DECODE(p_attribute7,FND_API.G_MISS_CHAR,NULL,NULL,attribute7, p_attribute7),

Line 1057: attribute4 = DECODE(p_attribute4,FND_API.G_MISS_CHAR,NULL,NULL,attribute4, p_attribute4),

1053: attribute_category = p_Attribute_category,
1054: attribute1 = DECODE(p_attribute1,FND_API.G_MISS_CHAR,NULL,NULL,attribute1, p_attribute1),
1055: attribute2 = DECODE(p_attribute2,FND_API.G_MISS_CHAR,NULL,NULL,attribute2, p_attribute2),
1056: attribute3 = DECODE(p_attribute3,FND_API.G_MISS_CHAR,NULL,NULL,attribute3, p_attribute3),
1057: attribute4 = DECODE(p_attribute4,FND_API.G_MISS_CHAR,NULL,NULL,attribute4, p_attribute4),
1058: attribute5 = DECODE(p_attribute5,FND_API.G_MISS_CHAR,NULL,NULL,attribute5, p_attribute5),
1059: attribute6 = DECODE(p_attribute6,FND_API.G_MISS_CHAR,NULL,NULL,attribute6, p_attribute6),
1060: attribute7 = DECODE(p_attribute7,FND_API.G_MISS_CHAR,NULL,NULL,attribute7, p_attribute7),
1061: attribute8 = DECODE(p_attribute8,FND_API.G_MISS_CHAR,NULL,NULL,attribute8, p_attribute8),

Line 1058: attribute5 = DECODE(p_attribute5,FND_API.G_MISS_CHAR,NULL,NULL,attribute5, p_attribute5),

1054: attribute1 = DECODE(p_attribute1,FND_API.G_MISS_CHAR,NULL,NULL,attribute1, p_attribute1),
1055: attribute2 = DECODE(p_attribute2,FND_API.G_MISS_CHAR,NULL,NULL,attribute2, p_attribute2),
1056: attribute3 = DECODE(p_attribute3,FND_API.G_MISS_CHAR,NULL,NULL,attribute3, p_attribute3),
1057: attribute4 = DECODE(p_attribute4,FND_API.G_MISS_CHAR,NULL,NULL,attribute4, p_attribute4),
1058: attribute5 = DECODE(p_attribute5,FND_API.G_MISS_CHAR,NULL,NULL,attribute5, p_attribute5),
1059: attribute6 = DECODE(p_attribute6,FND_API.G_MISS_CHAR,NULL,NULL,attribute6, p_attribute6),
1060: attribute7 = DECODE(p_attribute7,FND_API.G_MISS_CHAR,NULL,NULL,attribute7, p_attribute7),
1061: attribute8 = DECODE(p_attribute8,FND_API.G_MISS_CHAR,NULL,NULL,attribute8, p_attribute8),
1062: attribute9 = DECODE(p_attribute9,FND_API.G_MISS_CHAR,NULL,NULL,attribute9, p_attribute9),

Line 1059: attribute6 = DECODE(p_attribute6,FND_API.G_MISS_CHAR,NULL,NULL,attribute6, p_attribute6),

1055: attribute2 = DECODE(p_attribute2,FND_API.G_MISS_CHAR,NULL,NULL,attribute2, p_attribute2),
1056: attribute3 = DECODE(p_attribute3,FND_API.G_MISS_CHAR,NULL,NULL,attribute3, p_attribute3),
1057: attribute4 = DECODE(p_attribute4,FND_API.G_MISS_CHAR,NULL,NULL,attribute4, p_attribute4),
1058: attribute5 = DECODE(p_attribute5,FND_API.G_MISS_CHAR,NULL,NULL,attribute5, p_attribute5),
1059: attribute6 = DECODE(p_attribute6,FND_API.G_MISS_CHAR,NULL,NULL,attribute6, p_attribute6),
1060: attribute7 = DECODE(p_attribute7,FND_API.G_MISS_CHAR,NULL,NULL,attribute7, p_attribute7),
1061: attribute8 = DECODE(p_attribute8,FND_API.G_MISS_CHAR,NULL,NULL,attribute8, p_attribute8),
1062: attribute9 = DECODE(p_attribute9,FND_API.G_MISS_CHAR,NULL,NULL,attribute9, p_attribute9),
1063: attribute10 = DECODE(p_attribute10,FND_API.G_MISS_CHAR,NULL,NULL,attribute10, p_attribute10),

Line 1060: attribute7 = DECODE(p_attribute7,FND_API.G_MISS_CHAR,NULL,NULL,attribute7, p_attribute7),

1056: attribute3 = DECODE(p_attribute3,FND_API.G_MISS_CHAR,NULL,NULL,attribute3, p_attribute3),
1057: attribute4 = DECODE(p_attribute4,FND_API.G_MISS_CHAR,NULL,NULL,attribute4, p_attribute4),
1058: attribute5 = DECODE(p_attribute5,FND_API.G_MISS_CHAR,NULL,NULL,attribute5, p_attribute5),
1059: attribute6 = DECODE(p_attribute6,FND_API.G_MISS_CHAR,NULL,NULL,attribute6, p_attribute6),
1060: attribute7 = DECODE(p_attribute7,FND_API.G_MISS_CHAR,NULL,NULL,attribute7, p_attribute7),
1061: attribute8 = DECODE(p_attribute8,FND_API.G_MISS_CHAR,NULL,NULL,attribute8, p_attribute8),
1062: attribute9 = DECODE(p_attribute9,FND_API.G_MISS_CHAR,NULL,NULL,attribute9, p_attribute9),
1063: attribute10 = DECODE(p_attribute10,FND_API.G_MISS_CHAR,NULL,NULL,attribute10, p_attribute10),
1064: attribute11 = DECODE(p_attribute11,FND_API.G_MISS_CHAR,NULL,NULL,attribute11, p_attribute11),

Line 1061: attribute8 = DECODE(p_attribute8,FND_API.G_MISS_CHAR,NULL,NULL,attribute8, p_attribute8),

1057: attribute4 = DECODE(p_attribute4,FND_API.G_MISS_CHAR,NULL,NULL,attribute4, p_attribute4),
1058: attribute5 = DECODE(p_attribute5,FND_API.G_MISS_CHAR,NULL,NULL,attribute5, p_attribute5),
1059: attribute6 = DECODE(p_attribute6,FND_API.G_MISS_CHAR,NULL,NULL,attribute6, p_attribute6),
1060: attribute7 = DECODE(p_attribute7,FND_API.G_MISS_CHAR,NULL,NULL,attribute7, p_attribute7),
1061: attribute8 = DECODE(p_attribute8,FND_API.G_MISS_CHAR,NULL,NULL,attribute8, p_attribute8),
1062: attribute9 = DECODE(p_attribute9,FND_API.G_MISS_CHAR,NULL,NULL,attribute9, p_attribute9),
1063: attribute10 = DECODE(p_attribute10,FND_API.G_MISS_CHAR,NULL,NULL,attribute10, p_attribute10),
1064: attribute11 = DECODE(p_attribute11,FND_API.G_MISS_CHAR,NULL,NULL,attribute11, p_attribute11),
1065: attribute12 = DECODE(p_attribute12,FND_API.G_MISS_CHAR,NULL,NULL,attribute12, p_attribute12),

Line 1062: attribute9 = DECODE(p_attribute9,FND_API.G_MISS_CHAR,NULL,NULL,attribute9, p_attribute9),

1058: attribute5 = DECODE(p_attribute5,FND_API.G_MISS_CHAR,NULL,NULL,attribute5, p_attribute5),
1059: attribute6 = DECODE(p_attribute6,FND_API.G_MISS_CHAR,NULL,NULL,attribute6, p_attribute6),
1060: attribute7 = DECODE(p_attribute7,FND_API.G_MISS_CHAR,NULL,NULL,attribute7, p_attribute7),
1061: attribute8 = DECODE(p_attribute8,FND_API.G_MISS_CHAR,NULL,NULL,attribute8, p_attribute8),
1062: attribute9 = DECODE(p_attribute9,FND_API.G_MISS_CHAR,NULL,NULL,attribute9, p_attribute9),
1063: attribute10 = DECODE(p_attribute10,FND_API.G_MISS_CHAR,NULL,NULL,attribute10, p_attribute10),
1064: attribute11 = DECODE(p_attribute11,FND_API.G_MISS_CHAR,NULL,NULL,attribute11, p_attribute11),
1065: attribute12 = DECODE(p_attribute12,FND_API.G_MISS_CHAR,NULL,NULL,attribute12, p_attribute12),
1066: attribute13 = DECODE(p_attribute13,FND_API.G_MISS_CHAR,NULL,NULL,attribute13, p_attribute13),

Line 1063: attribute10 = DECODE(p_attribute10,FND_API.G_MISS_CHAR,NULL,NULL,attribute10, p_attribute10),

1059: attribute6 = DECODE(p_attribute6,FND_API.G_MISS_CHAR,NULL,NULL,attribute6, p_attribute6),
1060: attribute7 = DECODE(p_attribute7,FND_API.G_MISS_CHAR,NULL,NULL,attribute7, p_attribute7),
1061: attribute8 = DECODE(p_attribute8,FND_API.G_MISS_CHAR,NULL,NULL,attribute8, p_attribute8),
1062: attribute9 = DECODE(p_attribute9,FND_API.G_MISS_CHAR,NULL,NULL,attribute9, p_attribute9),
1063: attribute10 = DECODE(p_attribute10,FND_API.G_MISS_CHAR,NULL,NULL,attribute10, p_attribute10),
1064: attribute11 = DECODE(p_attribute11,FND_API.G_MISS_CHAR,NULL,NULL,attribute11, p_attribute11),
1065: attribute12 = DECODE(p_attribute12,FND_API.G_MISS_CHAR,NULL,NULL,attribute12, p_attribute12),
1066: attribute13 = DECODE(p_attribute13,FND_API.G_MISS_CHAR,NULL,NULL,attribute13, p_attribute13),
1067: attribute14 = DECODE(p_attribute14,FND_API.G_MISS_CHAR,NULL,NULL,attribute14, p_attribute14),

Line 1064: attribute11 = DECODE(p_attribute11,FND_API.G_MISS_CHAR,NULL,NULL,attribute11, p_attribute11),

1060: attribute7 = DECODE(p_attribute7,FND_API.G_MISS_CHAR,NULL,NULL,attribute7, p_attribute7),
1061: attribute8 = DECODE(p_attribute8,FND_API.G_MISS_CHAR,NULL,NULL,attribute8, p_attribute8),
1062: attribute9 = DECODE(p_attribute9,FND_API.G_MISS_CHAR,NULL,NULL,attribute9, p_attribute9),
1063: attribute10 = DECODE(p_attribute10,FND_API.G_MISS_CHAR,NULL,NULL,attribute10, p_attribute10),
1064: attribute11 = DECODE(p_attribute11,FND_API.G_MISS_CHAR,NULL,NULL,attribute11, p_attribute11),
1065: attribute12 = DECODE(p_attribute12,FND_API.G_MISS_CHAR,NULL,NULL,attribute12, p_attribute12),
1066: attribute13 = DECODE(p_attribute13,FND_API.G_MISS_CHAR,NULL,NULL,attribute13, p_attribute13),
1067: attribute14 = DECODE(p_attribute14,FND_API.G_MISS_CHAR,NULL,NULL,attribute14, p_attribute14),
1068: attribute15 = DECODE(p_attribute15,FND_API.G_MISS_CHAR,NULL,NULL,attribute15, p_attribute15),

Line 1065: attribute12 = DECODE(p_attribute12,FND_API.G_MISS_CHAR,NULL,NULL,attribute12, p_attribute12),

1061: attribute8 = DECODE(p_attribute8,FND_API.G_MISS_CHAR,NULL,NULL,attribute8, p_attribute8),
1062: attribute9 = DECODE(p_attribute9,FND_API.G_MISS_CHAR,NULL,NULL,attribute9, p_attribute9),
1063: attribute10 = DECODE(p_attribute10,FND_API.G_MISS_CHAR,NULL,NULL,attribute10, p_attribute10),
1064: attribute11 = DECODE(p_attribute11,FND_API.G_MISS_CHAR,NULL,NULL,attribute11, p_attribute11),
1065: attribute12 = DECODE(p_attribute12,FND_API.G_MISS_CHAR,NULL,NULL,attribute12, p_attribute12),
1066: attribute13 = DECODE(p_attribute13,FND_API.G_MISS_CHAR,NULL,NULL,attribute13, p_attribute13),
1067: attribute14 = DECODE(p_attribute14,FND_API.G_MISS_CHAR,NULL,NULL,attribute14, p_attribute14),
1068: attribute15 = DECODE(p_attribute15,FND_API.G_MISS_CHAR,NULL,NULL,attribute15, p_attribute15),
1069: attribute16 = DECODE(p_attribute16,FND_API.G_MISS_CHAR,NULL,NULL,attribute16, p_attribute16),

Line 1066: attribute13 = DECODE(p_attribute13,FND_API.G_MISS_CHAR,NULL,NULL,attribute13, p_attribute13),

1062: attribute9 = DECODE(p_attribute9,FND_API.G_MISS_CHAR,NULL,NULL,attribute9, p_attribute9),
1063: attribute10 = DECODE(p_attribute10,FND_API.G_MISS_CHAR,NULL,NULL,attribute10, p_attribute10),
1064: attribute11 = DECODE(p_attribute11,FND_API.G_MISS_CHAR,NULL,NULL,attribute11, p_attribute11),
1065: attribute12 = DECODE(p_attribute12,FND_API.G_MISS_CHAR,NULL,NULL,attribute12, p_attribute12),
1066: attribute13 = DECODE(p_attribute13,FND_API.G_MISS_CHAR,NULL,NULL,attribute13, p_attribute13),
1067: attribute14 = DECODE(p_attribute14,FND_API.G_MISS_CHAR,NULL,NULL,attribute14, p_attribute14),
1068: attribute15 = DECODE(p_attribute15,FND_API.G_MISS_CHAR,NULL,NULL,attribute15, p_attribute15),
1069: attribute16 = DECODE(p_attribute16,FND_API.G_MISS_CHAR,NULL,NULL,attribute16, p_attribute16),
1070: attribute17 = DECODE(p_attribute17,FND_API.G_MISS_CHAR,NULL,NULL,attribute17, p_attribute17),

Line 1067: attribute14 = DECODE(p_attribute14,FND_API.G_MISS_CHAR,NULL,NULL,attribute14, p_attribute14),

1063: attribute10 = DECODE(p_attribute10,FND_API.G_MISS_CHAR,NULL,NULL,attribute10, p_attribute10),
1064: attribute11 = DECODE(p_attribute11,FND_API.G_MISS_CHAR,NULL,NULL,attribute11, p_attribute11),
1065: attribute12 = DECODE(p_attribute12,FND_API.G_MISS_CHAR,NULL,NULL,attribute12, p_attribute12),
1066: attribute13 = DECODE(p_attribute13,FND_API.G_MISS_CHAR,NULL,NULL,attribute13, p_attribute13),
1067: attribute14 = DECODE(p_attribute14,FND_API.G_MISS_CHAR,NULL,NULL,attribute14, p_attribute14),
1068: attribute15 = DECODE(p_attribute15,FND_API.G_MISS_CHAR,NULL,NULL,attribute15, p_attribute15),
1069: attribute16 = DECODE(p_attribute16,FND_API.G_MISS_CHAR,NULL,NULL,attribute16, p_attribute16),
1070: attribute17 = DECODE(p_attribute17,FND_API.G_MISS_CHAR,NULL,NULL,attribute17, p_attribute17),
1071: attribute18 = DECODE(p_attribute18,FND_API.G_MISS_CHAR,NULL,NULL,attribute18, p_attribute18),

Line 1068: attribute15 = DECODE(p_attribute15,FND_API.G_MISS_CHAR,NULL,NULL,attribute15, p_attribute15),

1064: attribute11 = DECODE(p_attribute11,FND_API.G_MISS_CHAR,NULL,NULL,attribute11, p_attribute11),
1065: attribute12 = DECODE(p_attribute12,FND_API.G_MISS_CHAR,NULL,NULL,attribute12, p_attribute12),
1066: attribute13 = DECODE(p_attribute13,FND_API.G_MISS_CHAR,NULL,NULL,attribute13, p_attribute13),
1067: attribute14 = DECODE(p_attribute14,FND_API.G_MISS_CHAR,NULL,NULL,attribute14, p_attribute14),
1068: attribute15 = DECODE(p_attribute15,FND_API.G_MISS_CHAR,NULL,NULL,attribute15, p_attribute15),
1069: attribute16 = DECODE(p_attribute16,FND_API.G_MISS_CHAR,NULL,NULL,attribute16, p_attribute16),
1070: attribute17 = DECODE(p_attribute17,FND_API.G_MISS_CHAR,NULL,NULL,attribute17, p_attribute17),
1071: attribute18 = DECODE(p_attribute18,FND_API.G_MISS_CHAR,NULL,NULL,attribute18, p_attribute18),
1072: attribute19 = DECODE(p_attribute19,FND_API.G_MISS_CHAR,NULL,NULL,attribute19, p_attribute19),

Line 1069: attribute16 = DECODE(p_attribute16,FND_API.G_MISS_CHAR,NULL,NULL,attribute16, p_attribute16),

1065: attribute12 = DECODE(p_attribute12,FND_API.G_MISS_CHAR,NULL,NULL,attribute12, p_attribute12),
1066: attribute13 = DECODE(p_attribute13,FND_API.G_MISS_CHAR,NULL,NULL,attribute13, p_attribute13),
1067: attribute14 = DECODE(p_attribute14,FND_API.G_MISS_CHAR,NULL,NULL,attribute14, p_attribute14),
1068: attribute15 = DECODE(p_attribute15,FND_API.G_MISS_CHAR,NULL,NULL,attribute15, p_attribute15),
1069: attribute16 = DECODE(p_attribute16,FND_API.G_MISS_CHAR,NULL,NULL,attribute16, p_attribute16),
1070: attribute17 = DECODE(p_attribute17,FND_API.G_MISS_CHAR,NULL,NULL,attribute17, p_attribute17),
1071: attribute18 = DECODE(p_attribute18,FND_API.G_MISS_CHAR,NULL,NULL,attribute18, p_attribute18),
1072: attribute19 = DECODE(p_attribute19,FND_API.G_MISS_CHAR,NULL,NULL,attribute19, p_attribute19),
1073: attribute20 = DECODE(p_attribute20,FND_API.G_MISS_CHAR,NULL,NULL,attribute20, p_attribute20),

Line 1070: attribute17 = DECODE(p_attribute17,FND_API.G_MISS_CHAR,NULL,NULL,attribute17, p_attribute17),

1066: attribute13 = DECODE(p_attribute13,FND_API.G_MISS_CHAR,NULL,NULL,attribute13, p_attribute13),
1067: attribute14 = DECODE(p_attribute14,FND_API.G_MISS_CHAR,NULL,NULL,attribute14, p_attribute14),
1068: attribute15 = DECODE(p_attribute15,FND_API.G_MISS_CHAR,NULL,NULL,attribute15, p_attribute15),
1069: attribute16 = DECODE(p_attribute16,FND_API.G_MISS_CHAR,NULL,NULL,attribute16, p_attribute16),
1070: attribute17 = DECODE(p_attribute17,FND_API.G_MISS_CHAR,NULL,NULL,attribute17, p_attribute17),
1071: attribute18 = DECODE(p_attribute18,FND_API.G_MISS_CHAR,NULL,NULL,attribute18, p_attribute18),
1072: attribute19 = DECODE(p_attribute19,FND_API.G_MISS_CHAR,NULL,NULL,attribute19, p_attribute19),
1073: attribute20 = DECODE(p_attribute20,FND_API.G_MISS_CHAR,NULL,NULL,attribute20, p_attribute20),
1074: attribute21 = DECODE(p_attribute21,FND_API.G_MISS_CHAR,NULL,NULL,attribute21, p_attribute21),

Line 1071: attribute18 = DECODE(p_attribute18,FND_API.G_MISS_CHAR,NULL,NULL,attribute18, p_attribute18),

1067: attribute14 = DECODE(p_attribute14,FND_API.G_MISS_CHAR,NULL,NULL,attribute14, p_attribute14),
1068: attribute15 = DECODE(p_attribute15,FND_API.G_MISS_CHAR,NULL,NULL,attribute15, p_attribute15),
1069: attribute16 = DECODE(p_attribute16,FND_API.G_MISS_CHAR,NULL,NULL,attribute16, p_attribute16),
1070: attribute17 = DECODE(p_attribute17,FND_API.G_MISS_CHAR,NULL,NULL,attribute17, p_attribute17),
1071: attribute18 = DECODE(p_attribute18,FND_API.G_MISS_CHAR,NULL,NULL,attribute18, p_attribute18),
1072: attribute19 = DECODE(p_attribute19,FND_API.G_MISS_CHAR,NULL,NULL,attribute19, p_attribute19),
1073: attribute20 = DECODE(p_attribute20,FND_API.G_MISS_CHAR,NULL,NULL,attribute20, p_attribute20),
1074: attribute21 = DECODE(p_attribute21,FND_API.G_MISS_CHAR,NULL,NULL,attribute21, p_attribute21),
1075: attribute22 = DECODE(p_attribute22,FND_API.G_MISS_CHAR,NULL,NULL,attribute22, p_attribute22),

Line 1072: attribute19 = DECODE(p_attribute19,FND_API.G_MISS_CHAR,NULL,NULL,attribute19, p_attribute19),

1068: attribute15 = DECODE(p_attribute15,FND_API.G_MISS_CHAR,NULL,NULL,attribute15, p_attribute15),
1069: attribute16 = DECODE(p_attribute16,FND_API.G_MISS_CHAR,NULL,NULL,attribute16, p_attribute16),
1070: attribute17 = DECODE(p_attribute17,FND_API.G_MISS_CHAR,NULL,NULL,attribute17, p_attribute17),
1071: attribute18 = DECODE(p_attribute18,FND_API.G_MISS_CHAR,NULL,NULL,attribute18, p_attribute18),
1072: attribute19 = DECODE(p_attribute19,FND_API.G_MISS_CHAR,NULL,NULL,attribute19, p_attribute19),
1073: attribute20 = DECODE(p_attribute20,FND_API.G_MISS_CHAR,NULL,NULL,attribute20, p_attribute20),
1074: attribute21 = DECODE(p_attribute21,FND_API.G_MISS_CHAR,NULL,NULL,attribute21, p_attribute21),
1075: attribute22 = DECODE(p_attribute22,FND_API.G_MISS_CHAR,NULL,NULL,attribute22, p_attribute22),
1076: attribute23 = DECODE(p_attribute23,FND_API.G_MISS_CHAR,NULL,NULL,attribute23, p_attribute23),

Line 1073: attribute20 = DECODE(p_attribute20,FND_API.G_MISS_CHAR,NULL,NULL,attribute20, p_attribute20),

1069: attribute16 = DECODE(p_attribute16,FND_API.G_MISS_CHAR,NULL,NULL,attribute16, p_attribute16),
1070: attribute17 = DECODE(p_attribute17,FND_API.G_MISS_CHAR,NULL,NULL,attribute17, p_attribute17),
1071: attribute18 = DECODE(p_attribute18,FND_API.G_MISS_CHAR,NULL,NULL,attribute18, p_attribute18),
1072: attribute19 = DECODE(p_attribute19,FND_API.G_MISS_CHAR,NULL,NULL,attribute19, p_attribute19),
1073: attribute20 = DECODE(p_attribute20,FND_API.G_MISS_CHAR,NULL,NULL,attribute20, p_attribute20),
1074: attribute21 = DECODE(p_attribute21,FND_API.G_MISS_CHAR,NULL,NULL,attribute21, p_attribute21),
1075: attribute22 = DECODE(p_attribute22,FND_API.G_MISS_CHAR,NULL,NULL,attribute22, p_attribute22),
1076: attribute23 = DECODE(p_attribute23,FND_API.G_MISS_CHAR,NULL,NULL,attribute23, p_attribute23),
1077: attribute24 = DECODE(p_attribute24,FND_API.G_MISS_CHAR,NULL,NULL,attribute24, p_attribute24),

Line 1074: attribute21 = DECODE(p_attribute21,FND_API.G_MISS_CHAR,NULL,NULL,attribute21, p_attribute21),

1070: attribute17 = DECODE(p_attribute17,FND_API.G_MISS_CHAR,NULL,NULL,attribute17, p_attribute17),
1071: attribute18 = DECODE(p_attribute18,FND_API.G_MISS_CHAR,NULL,NULL,attribute18, p_attribute18),
1072: attribute19 = DECODE(p_attribute19,FND_API.G_MISS_CHAR,NULL,NULL,attribute19, p_attribute19),
1073: attribute20 = DECODE(p_attribute20,FND_API.G_MISS_CHAR,NULL,NULL,attribute20, p_attribute20),
1074: attribute21 = DECODE(p_attribute21,FND_API.G_MISS_CHAR,NULL,NULL,attribute21, p_attribute21),
1075: attribute22 = DECODE(p_attribute22,FND_API.G_MISS_CHAR,NULL,NULL,attribute22, p_attribute22),
1076: attribute23 = DECODE(p_attribute23,FND_API.G_MISS_CHAR,NULL,NULL,attribute23, p_attribute23),
1077: attribute24 = DECODE(p_attribute24,FND_API.G_MISS_CHAR,NULL,NULL,attribute24, p_attribute24),
1078: attribute25 = DECODE(p_attribute25,FND_API.G_MISS_CHAR,NULL,NULL,attribute25, p_attribute25),

Line 1075: attribute22 = DECODE(p_attribute22,FND_API.G_MISS_CHAR,NULL,NULL,attribute22, p_attribute22),

1071: attribute18 = DECODE(p_attribute18,FND_API.G_MISS_CHAR,NULL,NULL,attribute18, p_attribute18),
1072: attribute19 = DECODE(p_attribute19,FND_API.G_MISS_CHAR,NULL,NULL,attribute19, p_attribute19),
1073: attribute20 = DECODE(p_attribute20,FND_API.G_MISS_CHAR,NULL,NULL,attribute20, p_attribute20),
1074: attribute21 = DECODE(p_attribute21,FND_API.G_MISS_CHAR,NULL,NULL,attribute21, p_attribute21),
1075: attribute22 = DECODE(p_attribute22,FND_API.G_MISS_CHAR,NULL,NULL,attribute22, p_attribute22),
1076: attribute23 = DECODE(p_attribute23,FND_API.G_MISS_CHAR,NULL,NULL,attribute23, p_attribute23),
1077: attribute24 = DECODE(p_attribute24,FND_API.G_MISS_CHAR,NULL,NULL,attribute24, p_attribute24),
1078: attribute25 = DECODE(p_attribute25,FND_API.G_MISS_CHAR,NULL,NULL,attribute25, p_attribute25),
1079: attribute26 = DECODE(p_attribute26,FND_API.G_MISS_CHAR,NULL,NULL,attribute26, p_attribute26),

Line 1076: attribute23 = DECODE(p_attribute23,FND_API.G_MISS_CHAR,NULL,NULL,attribute23, p_attribute23),

1072: attribute19 = DECODE(p_attribute19,FND_API.G_MISS_CHAR,NULL,NULL,attribute19, p_attribute19),
1073: attribute20 = DECODE(p_attribute20,FND_API.G_MISS_CHAR,NULL,NULL,attribute20, p_attribute20),
1074: attribute21 = DECODE(p_attribute21,FND_API.G_MISS_CHAR,NULL,NULL,attribute21, p_attribute21),
1075: attribute22 = DECODE(p_attribute22,FND_API.G_MISS_CHAR,NULL,NULL,attribute22, p_attribute22),
1076: attribute23 = DECODE(p_attribute23,FND_API.G_MISS_CHAR,NULL,NULL,attribute23, p_attribute23),
1077: attribute24 = DECODE(p_attribute24,FND_API.G_MISS_CHAR,NULL,NULL,attribute24, p_attribute24),
1078: attribute25 = DECODE(p_attribute25,FND_API.G_MISS_CHAR,NULL,NULL,attribute25, p_attribute25),
1079: attribute26 = DECODE(p_attribute26,FND_API.G_MISS_CHAR,NULL,NULL,attribute26, p_attribute26),
1080: attribute27 = DECODE(p_attribute27,FND_API.G_MISS_CHAR,NULL,NULL,attribute27, p_attribute27),

Line 1077: attribute24 = DECODE(p_attribute24,FND_API.G_MISS_CHAR,NULL,NULL,attribute24, p_attribute24),

1073: attribute20 = DECODE(p_attribute20,FND_API.G_MISS_CHAR,NULL,NULL,attribute20, p_attribute20),
1074: attribute21 = DECODE(p_attribute21,FND_API.G_MISS_CHAR,NULL,NULL,attribute21, p_attribute21),
1075: attribute22 = DECODE(p_attribute22,FND_API.G_MISS_CHAR,NULL,NULL,attribute22, p_attribute22),
1076: attribute23 = DECODE(p_attribute23,FND_API.G_MISS_CHAR,NULL,NULL,attribute23, p_attribute23),
1077: attribute24 = DECODE(p_attribute24,FND_API.G_MISS_CHAR,NULL,NULL,attribute24, p_attribute24),
1078: attribute25 = DECODE(p_attribute25,FND_API.G_MISS_CHAR,NULL,NULL,attribute25, p_attribute25),
1079: attribute26 = DECODE(p_attribute26,FND_API.G_MISS_CHAR,NULL,NULL,attribute26, p_attribute26),
1080: attribute27 = DECODE(p_attribute27,FND_API.G_MISS_CHAR,NULL,NULL,attribute27, p_attribute27),
1081: attribute28 = DECODE(p_attribute28,FND_API.G_MISS_CHAR,NULL,NULL,attribute28, p_attribute28),

Line 1078: attribute25 = DECODE(p_attribute25,FND_API.G_MISS_CHAR,NULL,NULL,attribute25, p_attribute25),

1074: attribute21 = DECODE(p_attribute21,FND_API.G_MISS_CHAR,NULL,NULL,attribute21, p_attribute21),
1075: attribute22 = DECODE(p_attribute22,FND_API.G_MISS_CHAR,NULL,NULL,attribute22, p_attribute22),
1076: attribute23 = DECODE(p_attribute23,FND_API.G_MISS_CHAR,NULL,NULL,attribute23, p_attribute23),
1077: attribute24 = DECODE(p_attribute24,FND_API.G_MISS_CHAR,NULL,NULL,attribute24, p_attribute24),
1078: attribute25 = DECODE(p_attribute25,FND_API.G_MISS_CHAR,NULL,NULL,attribute25, p_attribute25),
1079: attribute26 = DECODE(p_attribute26,FND_API.G_MISS_CHAR,NULL,NULL,attribute26, p_attribute26),
1080: attribute27 = DECODE(p_attribute27,FND_API.G_MISS_CHAR,NULL,NULL,attribute27, p_attribute27),
1081: attribute28 = DECODE(p_attribute28,FND_API.G_MISS_CHAR,NULL,NULL,attribute28, p_attribute28),
1082: attribute29 = DECODE(p_attribute29,FND_API.G_MISS_CHAR,NULL,NULL,attribute29, p_attribute29),

Line 1079: attribute26 = DECODE(p_attribute26,FND_API.G_MISS_CHAR,NULL,NULL,attribute26, p_attribute26),

1075: attribute22 = DECODE(p_attribute22,FND_API.G_MISS_CHAR,NULL,NULL,attribute22, p_attribute22),
1076: attribute23 = DECODE(p_attribute23,FND_API.G_MISS_CHAR,NULL,NULL,attribute23, p_attribute23),
1077: attribute24 = DECODE(p_attribute24,FND_API.G_MISS_CHAR,NULL,NULL,attribute24, p_attribute24),
1078: attribute25 = DECODE(p_attribute25,FND_API.G_MISS_CHAR,NULL,NULL,attribute25, p_attribute25),
1079: attribute26 = DECODE(p_attribute26,FND_API.G_MISS_CHAR,NULL,NULL,attribute26, p_attribute26),
1080: attribute27 = DECODE(p_attribute27,FND_API.G_MISS_CHAR,NULL,NULL,attribute27, p_attribute27),
1081: attribute28 = DECODE(p_attribute28,FND_API.G_MISS_CHAR,NULL,NULL,attribute28, p_attribute28),
1082: attribute29 = DECODE(p_attribute29,FND_API.G_MISS_CHAR,NULL,NULL,attribute29, p_attribute29),
1083: attribute30 = DECODE(p_attribute30,FND_API.G_MISS_CHAR,NULL,NULL,attribute30, p_attribute30)

Line 1080: attribute27 = DECODE(p_attribute27,FND_API.G_MISS_CHAR,NULL,NULL,attribute27, p_attribute27),

1076: attribute23 = DECODE(p_attribute23,FND_API.G_MISS_CHAR,NULL,NULL,attribute23, p_attribute23),
1077: attribute24 = DECODE(p_attribute24,FND_API.G_MISS_CHAR,NULL,NULL,attribute24, p_attribute24),
1078: attribute25 = DECODE(p_attribute25,FND_API.G_MISS_CHAR,NULL,NULL,attribute25, p_attribute25),
1079: attribute26 = DECODE(p_attribute26,FND_API.G_MISS_CHAR,NULL,NULL,attribute26, p_attribute26),
1080: attribute27 = DECODE(p_attribute27,FND_API.G_MISS_CHAR,NULL,NULL,attribute27, p_attribute27),
1081: attribute28 = DECODE(p_attribute28,FND_API.G_MISS_CHAR,NULL,NULL,attribute28, p_attribute28),
1082: attribute29 = DECODE(p_attribute29,FND_API.G_MISS_CHAR,NULL,NULL,attribute29, p_attribute29),
1083: attribute30 = DECODE(p_attribute30,FND_API.G_MISS_CHAR,NULL,NULL,attribute30, p_attribute30)
1084: WHERE (instrid = p_instr_id);

Line 1081: attribute28 = DECODE(p_attribute28,FND_API.G_MISS_CHAR,NULL,NULL,attribute28, p_attribute28),

1077: attribute24 = DECODE(p_attribute24,FND_API.G_MISS_CHAR,NULL,NULL,attribute24, p_attribute24),
1078: attribute25 = DECODE(p_attribute25,FND_API.G_MISS_CHAR,NULL,NULL,attribute25, p_attribute25),
1079: attribute26 = DECODE(p_attribute26,FND_API.G_MISS_CHAR,NULL,NULL,attribute26, p_attribute26),
1080: attribute27 = DECODE(p_attribute27,FND_API.G_MISS_CHAR,NULL,NULL,attribute27, p_attribute27),
1081: attribute28 = DECODE(p_attribute28,FND_API.G_MISS_CHAR,NULL,NULL,attribute28, p_attribute28),
1082: attribute29 = DECODE(p_attribute29,FND_API.G_MISS_CHAR,NULL,NULL,attribute29, p_attribute29),
1083: attribute30 = DECODE(p_attribute30,FND_API.G_MISS_CHAR,NULL,NULL,attribute30, p_attribute30)
1084: WHERE (instrid = p_instr_id);
1085:

Line 1082: attribute29 = DECODE(p_attribute29,FND_API.G_MISS_CHAR,NULL,NULL,attribute29, p_attribute29),

1078: attribute25 = DECODE(p_attribute25,FND_API.G_MISS_CHAR,NULL,NULL,attribute25, p_attribute25),
1079: attribute26 = DECODE(p_attribute26,FND_API.G_MISS_CHAR,NULL,NULL,attribute26, p_attribute26),
1080: attribute27 = DECODE(p_attribute27,FND_API.G_MISS_CHAR,NULL,NULL,attribute27, p_attribute27),
1081: attribute28 = DECODE(p_attribute28,FND_API.G_MISS_CHAR,NULL,NULL,attribute28, p_attribute28),
1082: attribute29 = DECODE(p_attribute29,FND_API.G_MISS_CHAR,NULL,NULL,attribute29, p_attribute29),
1083: attribute30 = DECODE(p_attribute30,FND_API.G_MISS_CHAR,NULL,NULL,attribute30, p_attribute30)
1084: WHERE (instrid = p_instr_id);
1085:
1086: IF (SQL%NOTFOUND) THEN x_result_code := G_RC_INVALID_CARD_ID;

Line 1083: attribute30 = DECODE(p_attribute30,FND_API.G_MISS_CHAR,NULL,NULL,attribute30, p_attribute30)

1079: attribute26 = DECODE(p_attribute26,FND_API.G_MISS_CHAR,NULL,NULL,attribute26, p_attribute26),
1080: attribute27 = DECODE(p_attribute27,FND_API.G_MISS_CHAR,NULL,NULL,attribute27, p_attribute27),
1081: attribute28 = DECODE(p_attribute28,FND_API.G_MISS_CHAR,NULL,NULL,attribute28, p_attribute28),
1082: attribute29 = DECODE(p_attribute29,FND_API.G_MISS_CHAR,NULL,NULL,attribute29, p_attribute29),
1083: attribute30 = DECODE(p_attribute30,FND_API.G_MISS_CHAR,NULL,NULL,attribute30, p_attribute30)
1084: WHERE (instrid = p_instr_id);
1085:
1086: IF (SQL%NOTFOUND) THEN x_result_code := G_RC_INVALID_CARD_ID;
1087: ELSE x_result_code := null;

Line 1099: IF FND_API.To_Boolean(p_commit) THEN

1095: invalidation_reason = l_invalidation_reason,
1096: card_issuer_code = NVL(l_new_issuer, card_issuer_code)
1097: WHERE (instrid = p_instr_id);
1098:
1099: IF FND_API.To_Boolean(p_commit) THEN
1100: COMMIT;
1101: END IF;
1102: END Update_Card;
1103:

Line 1170: IF (l_temp_issuer IS NOT NULL AND l_temp_issuer <> FND_API.G_MISS_CHAR) THEN

1166: iby_debug_pub.add('card has invalid issuer!',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1167:
1168: -- Check if a new issuer_code is supplied to the API
1169: -- If it is supplied then does it make the record valid
1170: IF (l_temp_issuer IS NOT NULL AND l_temp_issuer <> FND_API.G_MISS_CHAR) THEN
1171: IF (l_temp_issuer = NVL(l_card_issuer2, 'UNKNOWN'))THEN
1172: iby_debug_pub.add('New card issuer makes the record valid.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1173: x_issuer := l_temp_issuer;
1174: ELSE

Line 1392: IF FND_API.to_Boolean( p_commit ) THEN

1388: c_card_rec.expiry_sec_segment_id)
1389: );
1390: END LOOP;
1391:
1392: IF FND_API.to_Boolean( p_commit ) THEN
1393: COMMIT;
1394: END IF;
1395: END Decrypt_Instruments;
1396:

Line 1465: (FND_API.G_FALSE,l_cc_ciphertext,iby_security_pkg.G_ENCODING_NUMERIC,

1461: l_cc_ciphertext :=
1462: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_compress_cc,TRUE));
1463:
1464: IBY_SECURITY_PKG.Create_Segment
1465: (FND_API.G_FALSE,l_cc_ciphertext,iby_security_pkg.G_ENCODING_NUMERIC,
1466: p_sys_key,l_segment_id);
1467: ELSE
1468: l_segment_id := -1;
1469: END IF;

Line 1537: IF FND_API.to_Boolean( p_commit ) THEN

1533: iby_debug_pub.add('Could not encrypt the record ' || c_card_rec.instrid,IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
1534: END IF;
1535: END LOOP;
1536:
1537: IF FND_API.to_Boolean( p_commit ) THEN
1538: COMMIT;
1539: END IF;
1540:
1541: END Encrypt_Instruments;

Line 1544: (p_commit IN VARCHAR2 := FND_API.G_TRUE,

1540:
1541: END Encrypt_Instruments;
1542:
1543: PROCEDURE Remask_Instruments
1544: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
1545: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
1546: )
1547: IS
1548: l_cc_number iby_creditcard.ccnumber%TYPE;

Line 1623: (FND_API.G_FALSE,l_cc_ciphertext,

1619: l_cc_ciphertext :=
1620: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_compress_cc,TRUE));
1621: IF (lx_segment_id IS NULL) THEN
1622: IBY_SECURITY_PKG.Create_Segment
1623: (FND_API.G_FALSE,l_cc_ciphertext,
1624: iby_security_pkg.G_ENCODING_NUMERIC,
1625: p_sys_key,lx_segment_id);
1626: ELSE
1627: IBY_SECURITY_PKG.Update_Segment

Line 1628: (FND_API.G_FALSE,lx_segment_id,l_cc_ciphertext,

1624: iby_security_pkg.G_ENCODING_NUMERIC,
1625: p_sys_key,lx_segment_id);
1626: ELSE
1627: IBY_SECURITY_PKG.Update_Segment
1628: (FND_API.G_FALSE,lx_segment_id,l_cc_ciphertext,
1629: iby_security_pkg.G_ENCODING_NUMERIC,
1630: p_sys_key,c_card_rec.subkey_cipher_text);
1631: END IF;
1632: ELSE

Line 1683: IF FND_API.to_Boolean( p_commit ) THEN

1679: last_update_login = fnd_global.login_id
1680: WHERE (instrid = c_card_rec.instrid);
1681: END LOOP;
1682:
1683: IF FND_API.to_Boolean( p_commit ) THEN
1684: COMMIT;
1685: END IF;
1686: END Remask_Instruments;
1687:

Line 1992: (p_commit IN VARCHAR2 := FND_API.G_TRUE,

1988:
1989: END Query_Card;
1990:
1991: PROCEDURE Encrypt_Card_Info
1992: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
1993: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
1994: p_expiry_date IN DATE,
1995: p_expSegmentId IN NUMBER,
1996: p_chname IN VARCHAR2,

Line 2058: IF FND_API.To_Boolean(p_commit) THEN

2054: x_chnameMaskSetting := p_chnameMaskSetting;
2055: x_chnameUnmaskLen := p_chnameUnmaskLen;
2056: END IF;
2057:
2058: IF FND_API.To_Boolean(p_commit) THEN
2059: COMMIT;
2060: END IF;
2061:
2062:

Line 2066: (p_commit IN VARCHAR2 := FND_API.G_TRUE,

2062:
2063: END Encrypt_Card_Info;
2064:
2065: PROCEDURE Mark_Expired_Cards
2066: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
2067: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
2068: )
2069: IS
2070: l_expiry_date DATE;

Line 2133: IF FND_API.to_Boolean( p_commit ) THEN

2129: END LOOP;
2130: iby_debug_pub.add('No. of records updated = '||cnt,
2131: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2132:
2133: IF FND_API.to_Boolean( p_commit ) THEN
2134: COMMIT;
2135: END IF;
2136:
2137: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

Line 2142: (p_commit IN VARCHAR2 := FND_API.G_TRUE,

2138:
2139: END Mark_Expired_Cards;
2140:
2141: PROCEDURE Upgrade_Encrypted_Instruments
2142: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
2143: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
2144: )
2145: IS
2146: l_api_name CONSTANT VARCHAR2(30) := 'Upgrade_Encrypted_Instruments';

Line 2329: (1.0, FND_API.G_FALSE, risky_instr_rec.creditcard_no,

2325: --script should be modified accordingly.
2326: IF (risky_instr_rec.creditcard_no IS NOT NULL)
2327: THEN
2328: IBY_CC_VALIDATE.StripCC
2329: (1.0, FND_API.G_FALSE, risky_instr_rec.creditcard_no,
2330: IBY_CC_VALIDATE.c_FillerChars, lx_return_status,
2331: lx_msg_count, lx_msg_data, lx_cc_number
2332: );
2333: -- Get hash values of the credit number

Line 2335: (lx_cc_number,FND_API.G_FALSE);

2331: lx_msg_count, lx_msg_data, lx_cc_number
2332: );
2333: -- Get hash values of the credit number
2334: l_cc_hash1 := iby_security_pkg.get_hash
2335: (lx_cc_number,FND_API.G_FALSE);
2336: l_cc_hash2 := iby_security_pkg.get_hash
2337: (lx_cc_number,FND_API.G_TRUE);
2338:
2339: UPDATE iby_irf_risky_instr

Line 2337: (lx_cc_number,FND_API.G_TRUE);

2333: -- Get hash values of the credit number
2334: l_cc_hash1 := iby_security_pkg.get_hash
2335: (lx_cc_number,FND_API.G_FALSE);
2336: l_cc_hash2 := iby_security_pkg.get_hash
2337: (lx_cc_number,FND_API.G_TRUE);
2338:
2339: UPDATE iby_irf_risky_instr
2340: SET creditcard_no = NULL,
2341: cc_number_hash1 = l_cc_hash1,

Line 2354: (risky_instr_rec.account_no,FND_API.G_FALSE);

2350:
2351: ELSIF (risky_instr_rec.account_no IS NOT NULL) THEN
2352: -- Get the hash values of the account number
2353: l_acct_no_hash1 := iby_security_pkg.get_hash
2354: (risky_instr_rec.account_no,FND_API.G_FALSE);
2355: l_acct_no_hash2 := iby_security_pkg.get_hash
2356: (risky_instr_rec.account_no,FND_API.G_TRUE);
2357:
2358: UPDATE iby_irf_risky_instr

Line 2356: (risky_instr_rec.account_no,FND_API.G_TRUE);

2352: -- Get the hash values of the account number
2353: l_acct_no_hash1 := iby_security_pkg.get_hash
2354: (risky_instr_rec.account_no,FND_API.G_FALSE);
2355: l_acct_no_hash2 := iby_security_pkg.get_hash
2356: (risky_instr_rec.account_no,FND_API.G_TRUE);
2357:
2358: UPDATE iby_irf_risky_instr
2359: SET account_no = NULL,
2360: acct_number_hash1 = l_acct_no_hash1,

Line 2378: IF FND_API.to_Boolean( p_commit ) THEN

2374: -- DBMS_OUTPUT.PUT_LINE('No. of cards updated: '|| no_cc);
2375: -- DBMS_OUTPUT.PUT_LINE('No. of accounts updated: '|| no_acct);
2376: fnd_file.put_line(fnd_file.log,l_dbg_mod||': No. of cards updated: '|| no_cc);
2377: fnd_file.put_line(fnd_file.log,l_dbg_mod||': No. of accounts updated: '|| no_acct);
2378: IF FND_API.to_Boolean( p_commit ) THEN
2379: COMMIT;
2380: END IF;
2381: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exit.');
2382: EXCEPTION