[Home] [Help]
5750: -- PADSS Start
5751: begin
5752: select encrypted
5753: into l_encrypted
5754: from iby_creditcard
5755: where instrid=p_prior_rec.cc_instrument_id;
5756: exception
5757: when others then
5758: begin
5757: when others then
5758: begin
5759: select encrypted
5760: into l_encrypted
5761: from iby_creditcard_h
5762: where card_history_change_id=p_prior_rec.cc_instrument_id;
5763: exception
5764: when others then
5765: null;
5768:
5769: begin
5770: select encrypted
5771: into l_encrypted1
5772: from iby_creditcard
5773: where instrid=p_curr_rec.cc_instrument_id;
5774: exception
5775: when others then
5776: --l_encrypted1:=null;
5776: --l_encrypted1:=null;
5777: begin
5778: select encrypted
5779: into l_encrypted1
5780: from iby_creditcard_h
5781: where card_history_change_id=p_curr_rec.cc_instrument_id;
5782: exception
5783: when others then
5784: null;
5837: -- PADSS Start
5838: begin
5839: select encrypted
5840: into l_encrypted
5841: from iby_creditcard
5842: where instrid=p_next_rec.cc_instrument_id;
5843: exception
5844: when others then
5845: --l_encrypted:=null;
5845: --l_encrypted:=null;
5846: begin
5847: select encrypted
5848: into l_encrypted
5849: from iby_creditcard_h
5850: where card_history_change_id=p_next_rec.cc_instrument_id;
5851: exception
5852: when others then
5853: null;
5856:
5857: begin
5858: select encrypted
5859: into l_encrypted1
5860: from iby_creditcard
5861: where instrid=p_curr_rec.cc_instrument_id;
5862: exception
5863: when others then
5864: --l_encrypted1:=null;
5864: --l_encrypted1:=null;
5865: begin
5866: select encrypted
5867: into l_encrypted1
5868: from iby_creditcard_h
5869: where card_history_change_id=p_curr_rec.cc_instrument_id;
5870: exception
5871: when others then
5872: null;
21784: IF p_is_card_history1 = 'Y' THEN
21785: BEGIN
21786: SELECT CHNAME
21787: INTO l_attribute_value1
21788: FROM iby_creditcard_h
21789: WHERE card_history_change_id = p_instrument_id1;
21790: EXCEPTION WHEN NO_DATA_FOUND THEN
21791: null;
21792: END;
21793: ELSE
21794: BEGIN
21795: SELECT CHNAME
21796: INTO l_attribute_value1
21797: FROM iby_creditcard
21798: WHERE instrid = p_instrument_id1;
21799: EXCEPTION WHEN NO_DATA_FOUND THEN
21800: null;
21801: END;
21805: IF p_is_card_history2 = 'Y' THEN
21806: BEGIN
21807: SELECT CHNAME
21808: INTO l_attribute_value2
21809: FROM iby_creditcard_h
21810: WHERE card_history_change_id = p_instrument_id2;
21811: EXCEPTION WHEN NO_DATA_FOUND THEN
21812: null;
21813: END;
21814: ELSE
21815: BEGIN
21816: SELECT CHNAME
21817: INTO l_attribute_value2
21818: FROM iby_creditcard
21819: WHERE instrid = p_instrument_id2;
21820: EXCEPTION WHEN NO_DATA_FOUND THEN
21821: null;
21822: END;
21827: IF p_is_card_history1 = 'Y' THEN
21828: BEGIN
21829: SELECT card_issuer_code
21830: INTO l_attribute_value1
21831: FROM iby_creditcard_h
21832: WHERE card_history_change_id = p_instrument_id1;
21833: EXCEPTION WHEN NO_DATA_FOUND THEN
21834: null;
21835: END;
21836: ELSE
21837: BEGIN
21838: SELECT card_issuer_code
21839: INTO l_attribute_value1
21840: FROM iby_creditcard
21841: WHERE instrid = p_instrument_id1;
21842: EXCEPTION WHEN NO_DATA_FOUND THEN
21843: null;
21844: END;
21847: IF p_is_card_history2 = 'Y' THEN
21848: BEGIN
21849: SELECT card_issuer_code
21850: INTO l_attribute_value2
21851: FROM iby_creditcard_h
21852: WHERE card_history_change_id = p_instrument_id2;
21853: EXCEPTION WHEN NO_DATA_FOUND THEN
21854: null;
21855: END;
21856: ELSE
21857: BEGIN
21858: SELECT card_issuer_code
21859: INTO l_attribute_value2
21860: FROM iby_creditcard
21861: WHERE instrid = p_instrument_id2;
21862: EXCEPTION WHEN NO_DATA_FOUND THEN
21863: null;
21864: END;
21868: --PADSS start
21869: begin
21870: select encrypted
21871: into l_encrypted
21872: from iby_creditcard
21873: where instrid=p_instrument_id1;
21874: exception
21875: when others then
21876: --l_encrypted:=null;
21876: --l_encrypted:=null;
21877: begin
21878: select encrypted
21879: into l_encrypted
21880: from iby_creditcard_h
21881: where card_history_change_id=p_instrument_id1;
21882: exception
21883: when others then
21884: null;
21890: --IF NOT iby_cc_security_pub.encryption_enabled() THEN
21891: IF nvl(l_encrypted,'N') <> 'A' THEN
21892: SELECT expirydate
21893: INTO l_attribute_value1
21894: FROM iby_creditcard_h
21895: WHERE card_history_change_id = p_instrument_id1;
21896: ELSE
21897: select credit_card_expiration_date
21898: INTO l_attribute_value1
21909: --IF NOT iby_cc_security_pub.encryption_enabled() THEN
21910: IF nvl(l_encrypted,'N') <> 'A' THEN
21911: SELECT expirydate
21912: INTO l_attribute_value1
21913: FROM iby_creditcard
21914: WHERE instrid = p_instrument_id1;
21915: ELSE
21916: l_attribute_value1:='-1';
21917: END IF;
21922:
21923: begin
21924: select encrypted
21925: into l_encrypted
21926: from iby_creditcard
21927: where instrid=p_instrument_id2;
21928: exception
21929: when others then
21930: --l_encrypted:=null;
21930: --l_encrypted:=null;
21931: begin
21932: select encrypted
21933: into l_encrypted
21934: from iby_creditcard_h
21935: where card_history_change_id=p_instrument_id2;
21936: exception
21937: when others then
21938: null;
21944: --IF NOT iby_cc_security_pub.encryption_enabled() THEN
21945: IF nvl(l_encrypted,'N') <> 'A' THEN
21946: SELECT expirydate
21947: INTO l_attribute_value2
21948: FROM iby_creditcard_h
21949: WHERE card_history_change_id = p_instrument_id2;
21950: ELSE
21951: select credit_card_expiration_date
21952: INTO l_attribute_value2
21962: --IF NOT iby_cc_security_pub.encryption_enabled() THEN
21963: IF nvl(l_encrypted,'N') <> 'A' THEN
21964: SELECT expirydate
21965: INTO l_attribute_value2
21966: FROM iby_creditcard
21967: WHERE instrid = p_instrument_id2;
21968: ELSE
21969: l_attribute_value2:='-1';
21970: END IF;