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_FD_EXTRACT_GEN_PVT dependencies on XMLTYPE

Line 88: Removing the storing of XMLTYPE in cache.

84: TYPE t_docs_pay_attribs_tbl_type IS TABLE OF t_docs_pay_attribs_type INDEX BY BINARY_INTEGER;
85: g_docs_pay_attribs_tbl t_docs_pay_attribs_tbl_type;
86:
87: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
88: Removing the storing of XMLTYPE in cache.
89: */
90:
91: TYPE t_hr_addr_rec_type IS RECORD(
92: location_id NUMBER(15),

Line 112: Removing the storing of XMLTYPE in cache.

108: TYPE t_hr_addr_tbl_type IS TABLE OF t_hr_addr_rec_type INDEX BY BINARY_INTEGER;
109: g_hr_addr_tbl t_hr_addr_tbl_type;
110:
111: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
112: Removing the storing of XMLTYPE in cache.
113: */
114:
115: /* TYPE t_hz_addr_rec_type IS RECORD(
116: hz_address XMLTYPE

Line 116: hz_address XMLTYPE

112: Removing the storing of XMLTYPE in cache.
113: */
114:
115: /* TYPE t_hz_addr_rec_type IS RECORD(
116: hz_address XMLTYPE
117: ); */
118:
119: TYPE t_hz_addr_rec_type IS RECORD(
120: location_id NUMBER(15),

Line 141: Removing the storing of XMLTYPE in cache.

137: TYPE t_hz_addr_tbl_type IS TABLE OF t_hz_addr_rec_type INDEX BY BINARY_INTEGER;
138: g_hz_addr_tbl t_hz_addr_tbl_type;
139:
140: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
141: Removing the storing of XMLTYPE in cache.
142: */
143:
144: TYPE t_payer_contact_rec_type IS RECORD(
145: phone_cp_id NUMBER,

Line 161: Removing the storing of XMLTYPE in cache.

157: /* Bug 8670295 */
158: /* added for caching the account address*/
159:
160: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
161: Removing the storing of XMLTYPE in cache.
162: */
163: TYPE t_account_addr_rec_type IS RECORD(
164: iso_territory_code VARCHAR2(50),
165: territory_short_name VARCHAR2(50)

Line 196: /* TYPE t_inter_acct_tbl_type IS TABLE OF XMLTYPE INDEX BY varchar2(1000);

192: g_payer_registration_tbl t_payer_registration_tbl_type;
193: /* Bug 8760084 */
194:
195: /* Bug 9266772*/
196: /* TYPE t_inter_acct_tbl_type IS TABLE OF XMLTYPE INDEX BY varchar2(1000);
197: g_inter_accts_tbl t_inter_acct_tbl_type; */
198: /* Bug 9266772*/
199: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
200: Removing the storing of XMLTYPE in cache.

Line 200: Removing the storing of XMLTYPE in cache.

196: /* TYPE t_inter_acct_tbl_type IS TABLE OF XMLTYPE INDEX BY varchar2(1000);
197: g_inter_accts_tbl t_inter_acct_tbl_type; */
198: /* Bug 9266772*/
199: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
200: Removing the storing of XMLTYPE in cache.
201: */
202:
203: TYPE t_inter_acct_rec_type IS RECORD(
204: Intermediary_acct_id NUMBER(15),

Line 221: TYPE t_instr_assign_tbl_type IS TABLE OF XMLTYPE INDEX BY BINARY_INTEGER;

217: TYPE t_inter_acct_tbl_type IS TABLE OF t_inter_acct_rec_type INDEX BY varchar2(1000);
218: g_inter_accts_tbl t_inter_acct_tbl_type;
219:
220: /*Bug 11923557 */
221: TYPE t_instr_assign_tbl_type IS TABLE OF XMLTYPE INDEX BY BINARY_INTEGER;
222: g_instr_assign_tbl t_instr_assign_tbl_type;
223: /*Bug 11923557 */
224:
225: FUNCTION Get_Payee_Default_Attribute(p_payment_id IN NUMBER, p_attribute_type IN NUMBER)

Line 564: SELECT XMLType.getClobVal(instruction)

560: IBY_FD_POST_PICP_PROGS_PVT.Run_ECE_Formatting(p_payment_instruction_id);
561: RETURN;
562: END IF;
563:
564: SELECT XMLType.getClobVal(instruction)
565: INTO x_extract_doc
566: FROM iby_xml_fd_ins_1_0_v
567: WHERE payment_instruction_id = p_payment_instruction_id;
568:

Line 682: SELECT XMLType.getClobVal(payment_process_request)

678: module => l_Debug_Module);
679: END IF;
680: CEP_STANDARD.init_security;
681:
682: SELECT XMLType.getClobVal(payment_process_request)
683: INTO x_extract_doc
684: FROM iby_xml_fd_ppr_1_0_v
685: WHERE payment_service_request_id = p_payment_service_request_id;
686:

Line 725: SELECT XMLType.getClobVal(XMLElement("PositivePayDataExtract", XMLAgg(xml_pmt_lvl.payment)))

721: l_to_date VARCHAR2(255);
722: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Create_Pos_Pay_Extract_1_0';
723:
724: CURSOR l_pospay_ins_csr IS
725: SELECT XMLType.getClobVal(XMLElement("PositivePayDataExtract", XMLAgg(xml_pmt_lvl.payment)))
726: FROM
727: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
728: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
729: AND xml_pmt_lvl.payment_status = 'ISSUED'

Line 733: SELECT XMLType.getClobVal(XMLElement("PositivePayDataExtract", XMLAgg(xml_pmt_lvl.payment)))

729: AND xml_pmt_lvl.payment_status = 'ISSUED'
730: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL);
731:
732: CURSOR l_pospay_appp_csr (p_to_date IN VARCHAR2) IS
733: SELECT XMLType.getClobVal(XMLElement("PositivePayDataExtract", XMLAgg(xml_pmt_lvl.payment)))
734: FROM
735: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
736: WHERE xml_pmt_lvl.payment_profile_id = p_payment_profile_id
737: AND xml_pmt_lvl.payment_date >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), xml_pmt_lvl.payment_date)

Line 906: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

902: x_extract_doc_11i CLOB;
903:
904: --cursor for - pmt instr id supplied,negotiable payments, reselect - no
905: CURSOR l_pospay_ins_csr_1_1 IS
906: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
907: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
908: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
909: AND xml_pmt_lvl.payment_status IN ('ISSUED','PAID')
910: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL)

Line 915: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

911: ;
912:
913: --cursor for - pmt instr id supplied,negotiable payments, reselect - yes
914: CURSOR l_pospay_ins_csr_1_2 IS
915: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
916: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
917: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
918: AND xml_pmt_lvl.payment_status IN ('ISSUED','PAID')
919: ;

Line 923: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

919: ;
920:
921: --cursor for - pmt instr id supplied,voided payments, reselect - no
922: CURSOR l_pospay_ins_csr_2_1 IS
923: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
924: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
925: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
926: AND xml_pmt_lvl.payment_status IN('VOID')
927: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL)

Line 932: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

928: ;
929:
930: --cursor for - pmt instr id supplied,voided payments, reselect - yes
931: CURSOR l_pospay_ins_csr_2_2 IS
932: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
933: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
934: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
935: AND xml_pmt_lvl.payment_status IN('VOID')
936: ;

Line 940: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

936: ;
937:
938: --cursor for - pmt instr id supplied,negotiable and voided payments, reselect - no
939: CURSOR l_pospay_ins_csr_3_1 IS
940: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
941: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
942: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
943: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')
944: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL)

Line 949: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

945: ;
946:
947: --cursor for - pmt instr id supplied,negotiable and voided payments, reselect - yes
948: CURSOR l_pospay_ins_csr_3_2 IS
949: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
950: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
951: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
952: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')
953: ;

Line 959: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))

955:
956:
957: --cursor for - pmt instr id not supplied,negotiable payments, reselect - no
958: CURSOR l_pospay_appp_csr_1_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
959: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
960: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
961: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
962: AND ppp.positive_pay_format_code IN
963: (SELECT ppfformat.format_code

Line 978: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))

974: ;
975:
976: --cursor for - pmt instr id not supplied,negotiable payments, reselect - yes
977: CURSOR l_pospay_appp_csr_1_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
978: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
979: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
980: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
981: AND ppp.positive_pay_format_code IN
982: (SELECT ppfformat.format_code

Line 996: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))

992: ;
993:
994: --cursor for - pmt instr id not supplied,voided payments, reselect - no
995: CURSOR l_pospay_appp_csr_2_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
996: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
997: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
998: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
999: AND ppp.positive_pay_format_code IN
1000: (SELECT ppfformat.format_code

Line 1015: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))

1011: ;
1012:
1013: --cursor for - pmt instr id not supplied,voided payments, reselect - yes
1014: CURSOR l_pospay_appp_csr_2_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
1015: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
1016: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
1017: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
1018: AND ppp.positive_pay_format_code IN
1019: (SELECT ppfformat.format_code

Line 1033: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))

1029: ;
1030:
1031: --cursor for - pmt instr id not supplied,negotiable and voided payments, reselect - no
1032: CURSOR l_pospay_appp_csr_3_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
1033: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
1034: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
1035: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
1036: AND ppp.positive_pay_format_code IN
1037: (SELECT ppfformat.format_code

Line 1052: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))

1048: ;
1049:
1050: --cursor for - pmt instr id not supplied,negotiable and voided payments, reselect - yes
1051: CURSOR l_pospay_appp_csr_3_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
1052: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
1053: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
1054: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
1055: AND ppp.positive_pay_format_code IN
1056: (SELECT ppfformat.format_code

Line 1069: SELECT xmltype.getclobval(xmlagg(pmt.payment))

1065: WHERE ba.bank_account_name = p_internal_bank_account_name)
1066: ;
1067:
1068: CURSOR l_pospay_appp_csr_11i (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
1069: SELECT xmltype.getclobval(xmlagg(pmt.payment))
1070: FROM IBY_XML_FD_11iPMT_1_0_V pmt
1071: WHERE pmt.internal_bank_account_id IN (SELECT ba.bank_account_id FROM ce_bank_accounts ba WHERE ba.bank_account_name = p_internal_bank_account_name)
1072: AND pmt.payment_date >= NVL(to_date(l_from_date, 'YYYY/MM/DD HH24:MI:SS'), pmt.payment_date)
1073: AND pmt.payment_date <= NVL(to_date(l_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)

Line 2050: RETURN XMLTYPE

2046:
2047: -- the party is the party that is linked to the LE
2048: -- on the payments
2049: FUNCTION Get_PayerContact(p_party_id IN NUMBER)
2050: RETURN XMLTYPE
2051: IS
2052: l_contactinfo XMLTYPE;
2053: l_phone_cp_id NUMBER;
2054: l_fax_cp_id NUMBER;

Line 2052: l_contactinfo XMLTYPE;

2048: -- on the payments
2049: FUNCTION Get_PayerContact(p_party_id IN NUMBER)
2050: RETURN XMLTYPE
2051: IS
2052: l_contactinfo XMLTYPE;
2053: l_phone_cp_id NUMBER;
2054: l_fax_cp_id NUMBER;
2055:
2056: l_email VARCHAR2(2000);

Line 2172: Removing the storing of XMLTYPE in cache.

2168: module => G_Debug_Module || '.get_payer_contact');
2169: END IF;
2170: -- the ContactName is left null
2171: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
2172: Removing the storing of XMLTYPE in cache.
2173: */
2174: g_payer_contact_tbl(p_party_id).phone_cp_id := l_phone_cp_id;
2175: g_payer_contact_tbl(p_party_id).fax_cp_id := l_fax_cp_id;
2176: g_payer_contact_tbl(p_party_id).email := l_email;

Line 2185: Removing the storing of XMLTYPE in cache.

2181: ELSE
2182: RETURN null;
2183: END IF;
2184: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
2185: Removing the storing of XMLTYPE in cache.
2186: */
2187: l_phone_cp_id := g_payer_contact_tbl(p_party_id).phone_cp_id ;
2188: l_fax_cp_id := g_payer_contact_tbl(p_party_id).fax_cp_id ;
2189: l_email := g_payer_contact_tbl(p_party_id).email ;

Line 2235: RETURN XMLTYPE

2231: -- Add cache for owner_table_id and owner_Table_name, so this gets reduced
2232: -- will give most bang for the buck.
2233:
2234: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER)
2235: RETURN XMLTYPE
2236: IS
2237: l_contactinfo XMLTYPE;
2238: l_remit_to_loc_id NUMBER;
2239: l_party_site_id NUMBER;

Line 2237: l_contactinfo XMLTYPE;

2233:
2234: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER)
2235: RETURN XMLTYPE
2236: IS
2237: l_contactinfo XMLTYPE;
2238: l_remit_to_loc_id NUMBER;
2239: l_party_site_id NUMBER;
2240: l_payee_party_id NUMBER;
2241: l_owner_table_name VARCHAR2(30);

Line 2378: RETURN XMLTYPE

2374: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER
2375: ,p_remit_to_location_id IN iby_payments_all.remit_to_location_id%TYPE
2376: ,p_party_site_id IN iby_payments_all.party_site_id%TYPE
2377: ,p_payee_party_id IN iby_payments_all.payee_party_id%TYPE)
2378: RETURN XMLTYPE
2379: IS
2380: l_contactinfo XMLTYPE;
2381: l_remit_to_loc_id NUMBER;
2382: l_party_site_id NUMBER;

Line 2380: l_contactinfo XMLTYPE;

2376: ,p_party_site_id IN iby_payments_all.party_site_id%TYPE
2377: ,p_payee_party_id IN iby_payments_all.payee_party_id%TYPE)
2378: RETURN XMLTYPE
2379: IS
2380: l_contactinfo XMLTYPE;
2381: l_remit_to_loc_id NUMBER;
2382: l_party_site_id NUMBER;
2383: l_payee_party_id NUMBER;
2384: l_owner_table_name VARCHAR2(30);

Line 2720: -- RETURN XMLTYPE

2716: -- rule is not clear. Omar wanted to defer the bank contacts
2717: -- in the extract until the requirement arises.
2718: --
2719: -- FUNCTION Get_Int_BankContact(p_bank_account_id IN NUMBER)
2720: -- RETURN XMLTYPE
2721:
2722:
2723: FUNCTION Get_Pmt_DocPayableCount(p_payment_id IN NUMBER)
2724: RETURN NUMBER

Line 2800: RETURN XMLTYPE

2796: END Get_Pmt_DocPayableCount;
2797:
2798:
2799: FUNCTION Get_Ins_FVFieldsAgg(p_payment_instruction_id IN NUMBER)
2800: RETURN XMLTYPE
2801: IS
2802: l_fv_summary_agg XMLTYPE;
2803: l_fv_treasury_symbol_agg XMLTYPE;
2804: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_FVFieldsAgg';

Line 2802: l_fv_summary_agg XMLTYPE;

2798:
2799: FUNCTION Get_Ins_FVFieldsAgg(p_payment_instruction_id IN NUMBER)
2800: RETURN XMLTYPE
2801: IS
2802: l_fv_summary_agg XMLTYPE;
2803: l_fv_treasury_symbol_agg XMLTYPE;
2804: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_FVFieldsAgg';
2805:
2806: CURSOR l_fv_treasury_symbol_csr (p_payment_instruction_id IN NUMBER) IS

Line 2803: l_fv_treasury_symbol_agg XMLTYPE;

2799: FUNCTION Get_Ins_FVFieldsAgg(p_payment_instruction_id IN NUMBER)
2800: RETURN XMLTYPE
2801: IS
2802: l_fv_summary_agg XMLTYPE;
2803: l_fv_treasury_symbol_agg XMLTYPE;
2804: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_FVFieldsAgg';
2805:
2806: CURSOR l_fv_treasury_symbol_csr (p_payment_instruction_id IN NUMBER) IS
2807: SELECT XMLAgg(

Line 2821: p_fv_treasury_symbol_agg XMLTYPE) IS

2817: WHERE iby.payment_instruction_id = fv.payment_instruction_id
2818: AND iby.payment_instruction_id = p_payment_instruction_id;
2819:
2820: CURSOR l_fv_summary_csr (p_payment_instruction_id IN NUMBER,
2821: p_fv_treasury_symbol_agg XMLTYPE) IS
2822: SELECT XMLElement("FederalInstructionInfo",
2823: XMLElement("TreasurySymbols", p_fv_treasury_symbol_agg),
2824: XMLElement("ControlNumber", control_number),
2825: XMLElement("ECSSummaryDosSeqNumber", iby_utility_pvt.get_view_param('FV_ECS_SEQ'))

Line 2852: RETURN XMLTYPE

2848: END Get_Ins_FVFieldsAgg;
2849:
2850:
2851: FUNCTION Get_Ins_PayerInstrAgg(p_payment_instruction_id IN NUMBER)
2852: RETURN XMLTYPE
2853: IS
2854: l_payerinstr_agg XMLTYPE;
2855: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_PayerInstrAgg';
2856: /* perf bug- 6763515 */

Line 2854: l_payerinstr_agg XMLTYPE;

2850:
2851: FUNCTION Get_Ins_PayerInstrAgg(p_payment_instruction_id IN NUMBER)
2852: RETURN XMLTYPE
2853: IS
2854: l_payerinstr_agg XMLTYPE;
2855: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_PayerInstrAgg';
2856: /* perf bug- 6763515 */
2857:
2858:

Line 3139: RETURN XMLTYPE

3135: RAISE;
3136: END Get_Ins_PayerInstrAgg;
3137:
3138: FUNCTION Get_Payer(p_legal_entity_id IN NUMBER)
3139: RETURN XMLTYPE
3140: IS
3141: l_payer XMLTYPE;
3142: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payer';
3143: CURSOR l_payer_csr (p_legal_entity_id IN NUMBER) IS

Line 3141: l_payer XMLTYPE;

3137:
3138: FUNCTION Get_Payer(p_legal_entity_id IN NUMBER)
3139: RETURN XMLTYPE
3140: IS
3141: l_payer XMLTYPE;
3142: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payer';
3143: CURSOR l_payer_csr (p_legal_entity_id IN NUMBER) IS
3144: SELECT payer
3145: FROM iby_xml_fd_payer_1_0_v

Line 3184: RETURN XMLTYPE

3180: END Get_Payer;
3181:
3182:
3183: FUNCTION Get_PayerBankAccount(p_bank_account_id IN NUMBER)
3184: RETURN XMLTYPE
3185: IS
3186: l_payer_ba XMLTYPE;
3187: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerBankAccount';
3188: CURSOR l_payer_ba_csr (p_bank_account_id IN NUMBER) IS

Line 3186: l_payer_ba XMLTYPE;

3182:
3183: FUNCTION Get_PayerBankAccount(p_bank_account_id IN NUMBER)
3184: RETURN XMLTYPE
3185: IS
3186: l_payer_ba XMLTYPE;
3187: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerBankAccount';
3188: CURSOR l_payer_ba_csr (p_bank_account_id IN NUMBER) IS
3189: SELECT int_bank_account
3190: FROM iby_xml_fd_prba_1_0_v

Line 3228: RETURN XMLTYPE

3224: END Get_PayerBankAccount;
3225:
3226:
3227: FUNCTION Get_Payer_Denorm(p_payment_id IN NUMBER)
3228: RETURN XMLTYPE
3229: IS
3230: l_payer XMLTYPE;
3231: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payer_Denorm';
3232: CURSOR l_payer_csr (p_payment_id IN NUMBER) IS

Line 3230: l_payer XMLTYPE;

3226:
3227: FUNCTION Get_Payer_Denorm(p_payment_id IN NUMBER)
3228: RETURN XMLTYPE
3229: IS
3230: l_payer XMLTYPE;
3231: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payer_Denorm';
3232: CURSOR l_payer_csr (p_payment_id IN NUMBER) IS
3233: SELECT payer
3234: FROM iby_xml_fd_payer_1_0_v

Line 3280: RETURN XMLTYPE

3276: END Get_Payer_Denorm;
3277:
3278:
3279: FUNCTION Get_PayerBankAccount_Denorm(p_payment_id IN NUMBER)
3280: RETURN XMLTYPE
3281: IS
3282: l_payer_ba XMLTYPE;
3283: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerBankAccount_Denorm';
3284: CURSOR l_payer_ba_csr (p_payment_id IN NUMBER) IS

Line 3282: l_payer_ba XMLTYPE;

3278:
3279: FUNCTION Get_PayerBankAccount_Denorm(p_payment_id IN NUMBER)
3280: RETURN XMLTYPE
3281: IS
3282: l_payer_ba XMLTYPE;
3283: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerBankAccount_Denorm';
3284: CURSOR l_payer_ba_csr (p_payment_id IN NUMBER) IS
3285: SELECT int_bank_account
3286: FROM iby_xml_fd_prba_1_0_v

Line 3331: RETURN XMLTYPE

3327: END Get_PayerBankAccount_Denorm;
3328:
3329:
3330: FUNCTION Get_PayerIns_Denorm(p_payment_instruction_id IN NUMBER)
3331: RETURN XMLTYPE
3332: IS
3333: l_payment_id NUMBER;
3334: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerIns_Denorm';
3335: CURSOR l_ins_payment_csr (p_payment_instruction_id IN NUMBER) IS

Line 3374: RETURN XMLTYPE

3370: END Get_PayerIns_Denorm;
3371:
3372:
3373: FUNCTION Get_PayerBankAccountIns_Denorm(p_payment_instruction_id IN NUMBER)
3374: RETURN XMLTYPE
3375: IS
3376: l_payment_id NUMBER;
3377: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerBankAccountIns_Denorm';
3378:

Line 3418: RETURN XMLTYPE

3414: END Get_PayerBankAccountIns_Denorm;
3415:
3416:
3417: FUNCTION Get_Ins_AccountSettingsAgg(p_bep_account_id IN NUMBER)
3418: RETURN XMLTYPE
3419: IS
3420: l_acctsettings_agg XMLTYPE;
3421:
3422: CURSOR l_acctsettings_csr (p_bep_account_id IN NUMBER) IS

Line 3420: l_acctsettings_agg XMLTYPE;

3416:
3417: FUNCTION Get_Ins_AccountSettingsAgg(p_bep_account_id IN NUMBER)
3418: RETURN XMLTYPE
3419: IS
3420: l_acctsettings_agg XMLTYPE;
3421:
3422: CURSOR l_acctsettings_csr (p_bep_account_id IN NUMBER) IS
3423: SELECT XMLAgg(account_setting)
3424: FROM iby_xml_fd_acct_settings_1_0_v

Line 3440: RETURN XMLTYPE

3436:
3437:
3438:
3439: FUNCTION Get_Pmt_DocPayableAgg(p_payment_id IN NUMBER)
3440: RETURN XMLTYPE
3441: IS
3442: l_docpayable_agg XMLTYPE;
3443: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_DocPayableAgg';
3444:

Line 3442: l_docpayable_agg XMLTYPE;

3438:
3439: FUNCTION Get_Pmt_DocPayableAgg(p_payment_id IN NUMBER)
3440: RETURN XMLTYPE
3441: IS
3442: l_docpayable_agg XMLTYPE;
3443: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_DocPayableAgg';
3444:
3445: CURSOR l_docpayable_csr (p_payment_id IN NUMBER) IS
3446: SELECT XMLAgg(doc_payable)

Line 3538: RETURN XMLTYPE

3534: END Get_Pmt_DocPayableAgg;
3535:
3536:
3537: FUNCTION Get_Payee(p_payment_id IN NUMBER)
3538: RETURN XMLTYPE
3539: IS
3540: l_payee XMLTYPE;
3541: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payee';
3542: l_pmt_func VARCHAR2(1);

Line 3540: l_payee XMLTYPE;

3536:
3537: FUNCTION Get_Payee(p_payment_id IN NUMBER)
3538: RETURN XMLTYPE
3539: IS
3540: l_payee XMLTYPE;
3541: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payee';
3542: l_pmt_func VARCHAR2(1);
3543:
3544: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS

Line 3608: RETURN XMLTYPE

3604:
3605:
3606: FUNCTION Get_Payee(p_payment_id IN NUMBER,
3607: p_pmt_func IN VARCHAR2)
3608: RETURN XMLTYPE
3609: IS
3610: l_payee XMLTYPE;
3611: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payee(payment_id, pmt_func)';
3612: l_pmt_func VARCHAR2(1);

Line 3610: l_payee XMLTYPE;

3606: FUNCTION Get_Payee(p_payment_id IN NUMBER,
3607: p_pmt_func IN VARCHAR2)
3608: RETURN XMLTYPE
3609: IS
3610: l_payee XMLTYPE;
3611: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payee(payment_id, pmt_func)';
3612: l_pmt_func VARCHAR2(1);
3613:
3614: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS

Line 3687: RETURN XMLTYPE

3683:
3684:
3685: /* TPP - Start */
3686: FUNCTION Get_InvPayee(p_payment_id IN NUMBER)
3687: RETURN XMLTYPE
3688: IS
3689: l_payee XMLTYPE;
3690: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_InvPayee';
3691:

Line 3689: l_payee XMLTYPE;

3685: /* TPP - Start */
3686: FUNCTION Get_InvPayee(p_payment_id IN NUMBER)
3687: RETURN XMLTYPE
3688: IS
3689: l_payee XMLTYPE;
3690: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_InvPayee';
3691:
3692: CURSOR l_payee_csr (p_payment_id IN NUMBER) IS
3693: SELECT payee

Line 3838: RETURN XMLTYPE

3834: /* TPP - End */
3835:
3836:
3837: FUNCTION Get_PayeeBankAccount(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
3838: RETURN XMLTYPE
3839: IS
3840: l_payee_ba XMLTYPE;
3841: l_pmt_func VARCHAR2(1);
3842: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount';

Line 3840: l_payee_ba XMLTYPE;

3836:
3837: FUNCTION Get_PayeeBankAccount(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
3838: RETURN XMLTYPE
3839: IS
3840: l_payee_ba XMLTYPE;
3841: l_pmt_func VARCHAR2(1);
3842: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount';
3843:
3844: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS

Line 3905: RETURN XMLTYPE

3901: END Get_PayeeBankAccount;
3902:
3903:
3904: FUNCTION Get_PayeeBankAccount_Denorm(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
3905: RETURN XMLTYPE
3906: IS
3907: l_payee_ba XMLTYPE;
3908: l_pmt_func VARCHAR2(1);
3909: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount_Denorm 2 input param';

Line 3907: l_payee_ba XMLTYPE;

3903:
3904: FUNCTION Get_PayeeBankAccount_Denorm(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
3905: RETURN XMLTYPE
3906: IS
3907: l_payee_ba XMLTYPE;
3908: l_pmt_func VARCHAR2(1);
3909: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount_Denorm 2 input param';
3910:
3911: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS

Line 3986: RETURN XMLTYPE

3982: For perf issue : Citi. */
3983: FUNCTION Get_PayeeBankAccount_Denorm(p_payment_id IN NUMBER
3984: , p_external_bank_account_id IN NUMBER
3985: ,p_pmt_func IN VARCHAR2)
3986: RETURN XMLTYPE
3987: IS
3988: l_payee_ba XMLTYPE;
3989: l_pmt_func VARCHAR2(1);
3990: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount_Denorm 3 input param';

Line 3988: l_payee_ba XMLTYPE;

3984: , p_external_bank_account_id IN NUMBER
3985: ,p_pmt_func IN VARCHAR2)
3986: RETURN XMLTYPE
3987: IS
3988: l_payee_ba XMLTYPE;
3989: l_pmt_func VARCHAR2(1);
3990: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount_Denorm 3 input param';
3991:
3992: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS

Line 4064: RETURN XMLTYPE

4060: END Get_PayeeBankAccount_Denorm;
4061: /*End of Overloaded Function*/
4062:
4063: FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER)
4064: RETURN XMLTYPE
4065: IS
4066: l_docline_agg XMLTYPE;
4067: --l_conc_invalid_chars VARCHAR2(50);
4068: --l_conc_replacement_chars VARCHAR2(50);

Line 4066: l_docline_agg XMLTYPE;

4062:
4063: FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER)
4064: RETURN XMLTYPE
4065: IS
4066: l_docline_agg XMLTYPE;
4067: --l_conc_invalid_chars VARCHAR2(50);
4068: --l_conc_replacement_chars VARCHAR2(50);
4069: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Doc_DocLineAgg';
4070:

Line 4159: RETURN XMLTYPE

4155: FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER,
4156: p_call_app_doc_unique_ref2 IN ap_invoices_all.invoice_id%TYPE,
4157: p_doc_currency_code IN iby_docs_payable_all.document_currency_code%TYPE,
4158: p_calling_app_id IN iby_docs_payable_all.calling_app_id%TYPE)
4159: RETURN XMLTYPE
4160: IS
4161: l_docline_agg XMLTYPE;
4162: --l_conc_invalid_chars VARCHAR2(50);
4163: --l_conc_replacement_chars VARCHAR2(50);

Line 4161: l_docline_agg XMLTYPE;

4157: p_doc_currency_code IN iby_docs_payable_all.document_currency_code%TYPE,
4158: p_calling_app_id IN iby_docs_payable_all.calling_app_id%TYPE)
4159: RETURN XMLTYPE
4160: IS
4161: l_docline_agg XMLTYPE;
4162: --l_conc_invalid_chars VARCHAR2(50);
4163: --l_conc_replacement_chars VARCHAR2(50);
4164: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Doc_DocLineAgg';
4165:

Line 4692: RETURN XMLTYPE

4688:
4689:
4690: -- Payment process request extract functions
4691: FUNCTION Get_Ppr_PmtAgg(p_payment_service_request_id IN NUMBER)
4692: RETURN XMLTYPE
4693: IS
4694: l_ppr_pmt_agg XMLTYPE;
4695:
4696: CURSOR l_ppr_pmt_csr (p_payment_service_request_id IN NUMBER) IS

Line 4694: l_ppr_pmt_agg XMLTYPE;

4690: -- Payment process request extract functions
4691: FUNCTION Get_Ppr_PmtAgg(p_payment_service_request_id IN NUMBER)
4692: RETURN XMLTYPE
4693: IS
4694: l_ppr_pmt_agg XMLTYPE;
4695:
4696: CURSOR l_ppr_pmt_csr (p_payment_service_request_id IN NUMBER) IS
4697: SELECT XMLAgg(payment)
4698: FROM iby_xml_fd_pmt_1_0_v

Line 4733: RETURN XMLTYPE

4729: END Get_Ppr_PmtCount;
4730:
4731:
4732: FUNCTION Get_Ppr_PreBuildDocAgg(p_payment_service_request_id IN NUMBER)
4733: RETURN XMLTYPE
4734: IS
4735: l_docpayable_agg XMLTYPE;
4736:
4737: CURSOR l_baddoc_csr (p_payment_service_request_id IN NUMBER) IS

Line 4735: l_docpayable_agg XMLTYPE;

4731:
4732: FUNCTION Get_Ppr_PreBuildDocAgg(p_payment_service_request_id IN NUMBER)
4733: RETURN XMLTYPE
4734: IS
4735: l_docpayable_agg XMLTYPE;
4736:
4737: CURSOR l_baddoc_csr (p_payment_service_request_id IN NUMBER) IS
4738: SELECT XMLAgg(doc_payable)
4739: FROM iby_xml_fd_doc_1_0_v

Line 4778: RETURN XMLTYPE

4774: END Get_Ppr_PreBuildDocCount;
4775:
4776:
4777: FUNCTION Get_Pmt_PmtErrAgg(p_payment_id IN NUMBER)
4778: RETURN XMLTYPE
4779: IS
4780: l_pmterr_agg XMLTYPE;
4781: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_PmtErrAgg';
4782: CURSOR l_pmterr_csr (p_payment_id IN NUMBER) IS

Line 4780: l_pmterr_agg XMLTYPE;

4776:
4777: FUNCTION Get_Pmt_PmtErrAgg(p_payment_id IN NUMBER)
4778: RETURN XMLTYPE
4779: IS
4780: l_pmterr_agg XMLTYPE;
4781: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_PmtErrAgg';
4782: CURSOR l_pmterr_csr (p_payment_id IN NUMBER) IS
4783: SELECT XMLAgg(payment_error)
4784: FROM iby_xml_fd_pmt_err_1_0_v

Line 4807: RETURN XMLTYPE

4803: END Get_Pmt_PmtErrAgg;
4804:
4805:
4806: FUNCTION Get_Doc_DocErrAgg(p_document_payable_id IN NUMBER)
4807: RETURN XMLTYPE
4808: IS
4809: l_docerr_agg XMLTYPE;
4810:
4811: CURSOR l_docerr_csr (p_document_payable_id IN NUMBER) IS

Line 4809: l_docerr_agg XMLTYPE;

4805:
4806: FUNCTION Get_Doc_DocErrAgg(p_document_payable_id IN NUMBER)
4807: RETURN XMLTYPE
4808: IS
4809: l_docerr_agg XMLTYPE;
4810:
4811: CURSOR l_docerr_csr (p_document_payable_id IN NUMBER) IS
4812: SELECT XMLAgg(doc_payable_error)
4813: FROM iby_xml_fd_doc_err_1_0_v

Line 4935: RETURN XMLTYPE

4931:
4932: END initialize;
4933:
4934: FUNCTION Get_Hz_Address(p_location_id IN NUMBER)
4935: RETURN XMLTYPE
4936: IS
4937: l_hz_addr XMLTYPE;
4938:
4939: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE

Line 4937: l_hz_addr XMLTYPE;

4933:
4934: FUNCTION Get_Hz_Address(p_location_id IN NUMBER)
4935: RETURN XMLTYPE
4936: IS
4937: l_hz_addr XMLTYPE;
4938:
4939: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
4940: Removing the storing of XMLTYPE in cache.
4941: */

Line 4940: Removing the storing of XMLTYPE in cache.

4936: IS
4937: l_hz_addr XMLTYPE;
4938:
4939: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
4940: Removing the storing of XMLTYPE in cache.
4941: */
4942:
4943: l_location_id NUMBER(15);
4944: l_address1 VARCHAR2(240);

Line 5049: Removing the storing of XMLTYPE in cache.

5045: END IF;
5046:
5047: /* Bug 8658052 */
5048: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
5049: Removing the storing of XMLTYPE in cache.
5050: */
5051:
5052: SELECT XMLConcat( XMLElement("AddressInternalID", l_location_id),
5053: XMLElement("AddressLine1", l_address1), XMLElement("AddressLine2", l_address2),

Line 5069: RETURN XMLTYPE

5065:
5066: END Get_Hz_Address;
5067:
5068: FUNCTION Get_Account_Address(p_location_id IN NUMBER, p_country IN VARCHAR2)
5069: RETURN XMLTYPE
5070: IS
5071: l_hz_addr XMLTYPE;
5072:
5073: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE

Line 5071: l_hz_addr XMLTYPE;

5067:
5068: FUNCTION Get_Account_Address(p_location_id IN NUMBER, p_country IN VARCHAR2)
5069: RETURN XMLTYPE
5070: IS
5071: l_hz_addr XMLTYPE;
5072:
5073: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
5074: Removing the storing of XMLTYPE in cache.
5075: */

Line 5074: Removing the storing of XMLTYPE in cache.

5070: IS
5071: l_hz_addr XMLTYPE;
5072:
5073: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
5074: Removing the storing of XMLTYPE in cache.
5075: */
5076:
5077: l_te_code VARCHAR2(50);
5078: l_te_sname VARCHAR2(50);

Line 5219: Removing the storing of XMLTYPE in cache.

5215: END IF;
5216:
5217: /* Bug 8658052 */
5218: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
5219: Removing the storing of XMLTYPE in cache.
5220: */
5221:
5222: SELECT XMLConcat( XMLElement("AddressInternalID", l_location_id),
5223: XMLElement("AddressLine1", l_address1), XMLElement("AddressLine2", l_address2),

Line 5241: RETURN XMLTYPE

5237:
5238:
5239:
5240: FUNCTION Get_Hr_Address(p_location_id IN NUMBER)
5241: RETURN XMLTYPE
5242: IS
5243: l_hr_addr XMLTYPE;
5244: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
5245: Removing the storing of XMLTYPE in cache.

Line 5243: l_hr_addr XMLTYPE;

5239:
5240: FUNCTION Get_Hr_Address(p_location_id IN NUMBER)
5241: RETURN XMLTYPE
5242: IS
5243: l_hr_addr XMLTYPE;
5244: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
5245: Removing the storing of XMLTYPE in cache.
5246: */
5247:

Line 5245: Removing the storing of XMLTYPE in cache.

5241: RETURN XMLTYPE
5242: IS
5243: l_hr_addr XMLTYPE;
5244: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
5245: Removing the storing of XMLTYPE in cache.
5246: */
5247:
5248: l_location_id NUMBER(15);
5249: l_address1 VARCHAR2(240);

Line 5345: Removing the storing of XMLTYPE in cache.

5341: module => G_Debug_Module || '.Get_Hr_Address');
5342: END IF;
5343:
5344: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
5345: Removing the storing of XMLTYPE in cache.
5346: */
5347:
5348: SELECT XMLConcat( XMLElement("AddressInternalID", l_location_id),
5349: XMLElement("AddressLine1", l_address1), XMLElement("AddressLine2", l_address2),

Line 5519: RETURN XMLTYPE

5515: /* This function would retrieve Credit card number for invoices
5516: which pay Credit Card Issuer */
5517: /* This logic will work only for Both Pay Expense reports */
5518: FUNCTION Get_CC_Num_For_Issuer_Pmt_Agg(p_document_payable_id IN NUMBER)
5519: RETURN XMLTYPE
5520: IS
5521: l_instrid NUMBER;
5522: l_card_num_agg XMLTYPE := NULL;
5523: l_base_inv_num iby_docs_payable_all.CALLING_APP_DOC_REF_NUMBER%TYPE;

Line 5522: l_card_num_agg XMLTYPE := NULL;

5518: FUNCTION Get_CC_Num_For_Issuer_Pmt_Agg(p_document_payable_id IN NUMBER)
5519: RETURN XMLTYPE
5520: IS
5521: l_instrid NUMBER;
5522: l_card_num_agg XMLTYPE := NULL;
5523: l_base_inv_num iby_docs_payable_all.CALLING_APP_DOC_REF_NUMBER%TYPE;
5524: l_card_num VARCHAR2(30);
5525: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_CC_Num_For_Issuer_Pmt_Agg';
5526:

Line 5660: FUNCTION Get_Intermediary_Bank_Accts(p_bank_acct_id NUMBER) RETURN XMLTYPE

5656:
5657:
5658:
5659: /* Bug 9266772*/
5660: FUNCTION Get_Intermediary_Bank_Accts(p_bank_acct_id NUMBER) RETURN XMLTYPE
5661: IS
5662:
5663: l_intermediary_accounts xmltype;
5664:

Line 5663: l_intermediary_accounts xmltype;

5659: /* Bug 9266772*/
5660: FUNCTION Get_Intermediary_Bank_Accts(p_bank_acct_id NUMBER) RETURN XMLTYPE
5661: IS
5662:
5663: l_intermediary_accounts xmltype;
5664:
5665: /* Bug 16184066*/
5666: l_Intermediary_acct_id NUMBER(15);
5667: l_Account_Number VARCHAR2(100);

Line 5830: Removing the storing of XMLTYPE in cache.

5826:
5827: END IF;
5828:
5829: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
5830: Removing the storing of XMLTYPE in cache.
5831: */
5832:
5833: select XMLCONCAT(XMLELEMENT("IntermediaryBankAccount1",
5834: (XMLELEMENT("IntermediaryAccountID", l_Intermediary_acct_id)),

Line 5866: FUNCTION get_PayeeBankAccountAssignment(p_pmt_id Number, p_ext_bank_acct_id NUMBER) RETURN XMLTYPE IS

5862: END Get_Intermediary_Bank_Accts;
5863:
5864: /* Bug 9266772*/
5865:
5866: FUNCTION get_PayeeBankAccountAssignment(p_pmt_id Number, p_ext_bank_acct_id NUMBER) RETURN XMLTYPE IS
5867: l_instr_assign_id IBY_PMT_INSTR_USES_ALL.INSTRUMENT_PAYMENT_USE_ID%TYPE;
5868: l_attribute_category IBY_PMT_INSTR_USES_ALL.ATTRIBUTE_CATEGORY%TYPE;
5869: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.get_PayeeBankAccountAssignment';
5870: l_assign_dff XMLTYPE;

Line 5870: l_assign_dff XMLTYPE;

5866: FUNCTION get_PayeeBankAccountAssignment(p_pmt_id Number, p_ext_bank_acct_id NUMBER) RETURN XMLTYPE IS
5867: l_instr_assign_id IBY_PMT_INSTR_USES_ALL.INSTRUMENT_PAYMENT_USE_ID%TYPE;
5868: l_attribute_category IBY_PMT_INSTR_USES_ALL.ATTRIBUTE_CATEGORY%TYPE;
5869: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.get_PayeeBankAccountAssignment';
5870: l_assign_dff XMLTYPE;
5871:
5872: cursor get_Assignments(c_payment_id NUMBER,
5873: c_ext_bank_account_id NUMBER) is
5874: SELECT instr.instrument_payment_use_id, instr.attribute_category

Line 5930: Removing the storing of XMLTYPE in cache.

5926: module => l_Debug_Module);
5927: END IF;
5928:
5929: /* 16184066: +T5:R12.1:IBY_FD_PAYMENT_FORMAT_TEXT PERFORMANCE
5930: Removing the storing of XMLTYPE in cache.
5931: */
5932:
5933: IF (p_ext_bank_acct_id is not null) then
5934: