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 80: hr_address XMLTYPE

76: TYPE t_docs_pay_attribs_tbl_type IS TABLE OF t_docs_pay_attribs_type INDEX BY BINARY_INTEGER;
77: g_docs_pay_attribs_tbl t_docs_pay_attribs_tbl_type;
78:
79: TYPE t_hr_addr_rec_type IS RECORD(
80: hr_address XMLTYPE
81: );
82:
83: TYPE t_hr_addr_tbl_type IS TABLE OF t_hr_addr_rec_type INDEX BY BINARY_INTEGER;
84: g_hr_addr_tbl t_hr_addr_tbl_type;

Line 87: hz_address XMLTYPE

83: TYPE t_hr_addr_tbl_type IS TABLE OF t_hr_addr_rec_type INDEX BY BINARY_INTEGER;
84: g_hr_addr_tbl t_hr_addr_tbl_type;
85:
86: TYPE t_hz_addr_rec_type IS RECORD(
87: hz_address XMLTYPE
88: );
89:
90: TYPE t_hz_addr_tbl_type IS TABLE OF t_hz_addr_rec_type INDEX BY BINARY_INTEGER;
91: g_hz_addr_tbl t_hz_addr_tbl_type;

Line 94: l_contactinfo XMLTYPE

90: TYPE t_hz_addr_tbl_type IS TABLE OF t_hz_addr_rec_type INDEX BY BINARY_INTEGER;
91: g_hz_addr_tbl t_hz_addr_tbl_type;
92:
93: TYPE t_payer_contact_rec_type IS RECORD(
94: l_contactinfo XMLTYPE
95: );
96:
97: TYPE t_payer_contact_tbl_type IS TABLE OF t_payer_contact_rec_type INDEX BY BINARY_INTEGER;
98:

Line 379: SELECT ''||XMLType.getClobVal(instruction)

375: IBY_FD_POST_PICP_PROGS_PVT.Run_ECE_Formatting(p_payment_instruction_id);
376: RETURN;
377: END IF;
378:
379: SELECT ''||XMLType.getClobVal(instruction)
380: INTO x_extract_doc
381: FROM iby_xml_fd_ins_1_0_v
382: WHERE payment_instruction_id = p_payment_instruction_id;
383:

Line 487: SELECT XMLType.getClobVal(payment_process_request)

483: module => l_Debug_Module);
484: END IF;
485: CEP_STANDARD.init_security;
486:
487: SELECT XMLType.getClobVal(payment_process_request)
488: INTO x_extract_doc
489: FROM iby_xml_fd_ppr_1_0_v
490: WHERE payment_service_request_id = p_payment_service_request_id;
491:

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

521: l_to_date VARCHAR2(255);
522: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Create_Pos_Pay_Extract_1_0';
523:
524: CURSOR l_pospay_ins_csr IS
525: SELECT XMLType.getClobVal(XMLElement("PositivePayDataExtract", XMLAgg(xml_pmt_lvl.payment)))
526: FROM
527: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
528: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
529: AND xml_pmt_lvl.payment_status = 'ISSUED'

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

529: AND xml_pmt_lvl.payment_status = 'ISSUED'
530: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL);
531:
532: CURSOR l_pospay_appp_csr (p_to_date IN VARCHAR2) IS
533: SELECT XMLType.getClobVal(XMLElement("PositivePayDataExtract", XMLAgg(xml_pmt_lvl.payment)))
534: FROM
535: iby_xml_fd_pmt_1_0_v xml_pmt_lvl,
536: iby_pay_instructions_all ins
537: WHERE xml_pmt_lvl.payment_instruction_id = ins.payment_instruction_id

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

695: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Create_Pos_Pay_Extract_2_0';
696:
697: --cursor for - pmt instr id supplied,negotiable payments, reselect - no
698: CURSOR l_pospay_ins_csr_1_1 IS
699: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
700: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
701: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
702: AND xml_pmt_lvl.payment_status IN ('ISSUED','PAID')
703: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL)

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

704: ;
705:
706: --cursor for - pmt instr id supplied,negotiable payments, reselect - yes
707: CURSOR l_pospay_ins_csr_1_2 IS
708: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
709: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
710: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
711: AND xml_pmt_lvl.payment_status IN ('ISSUED','PAID')
712: ;

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

712: ;
713:
714: --cursor for - pmt instr id supplied,voided payments, reselect - no
715: CURSOR l_pospay_ins_csr_2_1 IS
716: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
717: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
718: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
719: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')
720: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL)

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

721: ;
722:
723: --cursor for - pmt instr id supplied,voided payments, reselect - yes
724: CURSOR l_pospay_ins_csr_2_2 IS
725: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
726: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
727: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
728: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')
729: ;

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

730:
731:
732: --cursor for - pmt instr id not supplied,negotiable payments, reselect - no
733: CURSOR l_pospay_appp_csr_1_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
734: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
735: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp
736: WHERE xml_pmt_lvl.payment_instruction_id = pmtinstr.payment_instruction_id
737: AND pmtinstr.payment_profile_id = ppp.payment_profile_id
738: AND ppp.positive_pay_format_code IN

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

750: ;
751:
752: --cursor for - pmt instr id not supplied,negotiable payments, reselect - yes
753: CURSOR l_pospay_appp_csr_1_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
754: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
755: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp
756: WHERE xml_pmt_lvl.payment_instruction_id = pmtinstr.payment_instruction_id
757: AND pmtinstr.payment_profile_id = ppp.payment_profile_id
758: AND ppp.positive_pay_format_code IN

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

769: ;
770:
771: --cursor for - pmt instr id not supplied,voided payments, reselect - no
772: CURSOR l_pospay_appp_csr_2_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
773: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
774: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp
775: WHERE xml_pmt_lvl.payment_instruction_id = pmtinstr.payment_instruction_id
776: AND pmtinstr.payment_profile_id = ppp.payment_profile_id
777: AND ppp.positive_pay_format_code IN

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

789: ;
790:
791: --cursor for - pmt instr id not supplied,voided payments, reselect - yes
792: CURSOR l_pospay_appp_csr_2_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
793: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
794: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp
795: WHERE xml_pmt_lvl.payment_instruction_id = pmtinstr.payment_instruction_id
796: AND pmtinstr.payment_profile_id = ppp.payment_profile_id
797: AND ppp.positive_pay_format_code IN

Line 1535: RETURN XMLTYPE

1531:
1532: -- the party is the party that is linked to the LE
1533: -- on the payments
1534: FUNCTION Get_PayerContact(p_party_id IN NUMBER)
1535: RETURN XMLTYPE
1536: IS
1537: l_contactinfo XMLTYPE;
1538: l_phone_cp_id NUMBER;
1539: l_fax_cp_id NUMBER;

Line 1537: l_contactinfo XMLTYPE;

1533: -- on the payments
1534: FUNCTION Get_PayerContact(p_party_id IN NUMBER)
1535: RETURN XMLTYPE
1536: IS
1537: l_contactinfo XMLTYPE;
1538: l_phone_cp_id NUMBER;
1539: l_fax_cp_id NUMBER;
1540:
1541: l_email VARCHAR2(2000);

Line 1686: RETURN XMLTYPE

1682: END Get_PayerContact;
1683:
1684:
1685: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER)
1686: RETURN XMLTYPE
1687: IS
1688: l_contactinfo XMLTYPE;
1689: l_remit_to_loc_id NUMBER;
1690: l_party_site_id NUMBER;

Line 1688: l_contactinfo XMLTYPE;

1684:
1685: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER)
1686: RETURN XMLTYPE
1687: IS
1688: l_contactinfo XMLTYPE;
1689: l_remit_to_loc_id NUMBER;
1690: l_party_site_id NUMBER;
1691: l_payee_party_id NUMBER;
1692: l_owner_table_name VARCHAR2(30);

Line 1951: -- RETURN XMLTYPE

1947: -- rule is not clear. Omar wanted to defer the bank contacts
1948: -- in the extract until the requirement arises.
1949: --
1950: -- FUNCTION Get_Int_BankContact(p_bank_account_id IN NUMBER)
1951: -- RETURN XMLTYPE
1952:
1953:
1954: FUNCTION Get_Pmt_DocPayableCount(p_payment_id IN NUMBER)
1955: RETURN NUMBER

Line 2003: RETURN XMLTYPE

1999: END Get_Pmt_DocPayableCount;
2000:
2001:
2002: FUNCTION Get_Ins_FVFieldsAgg(p_payment_instruction_id IN NUMBER)
2003: RETURN XMLTYPE
2004: IS
2005: l_fv_summary_agg XMLTYPE;
2006: l_fv_treasury_symbol_agg XMLTYPE;
2007: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_FVFieldsAgg';

Line 2005: l_fv_summary_agg XMLTYPE;

2001:
2002: FUNCTION Get_Ins_FVFieldsAgg(p_payment_instruction_id IN NUMBER)
2003: RETURN XMLTYPE
2004: IS
2005: l_fv_summary_agg XMLTYPE;
2006: l_fv_treasury_symbol_agg XMLTYPE;
2007: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_FVFieldsAgg';
2008:
2009: CURSOR l_fv_treasury_symbol_csr (p_payment_instruction_id IN NUMBER) IS

Line 2006: l_fv_treasury_symbol_agg XMLTYPE;

2002: FUNCTION Get_Ins_FVFieldsAgg(p_payment_instruction_id IN NUMBER)
2003: RETURN XMLTYPE
2004: IS
2005: l_fv_summary_agg XMLTYPE;
2006: l_fv_treasury_symbol_agg XMLTYPE;
2007: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_FVFieldsAgg';
2008:
2009: CURSOR l_fv_treasury_symbol_csr (p_payment_instruction_id IN NUMBER) IS
2010: SELECT XMLAgg(

Line 2024: p_fv_treasury_symbol_agg XMLTYPE) IS

2020: WHERE iby.payment_instruction_id = fv.payment_instruction_id
2021: AND iby.payment_instruction_id = p_payment_instruction_id;
2022:
2023: CURSOR l_fv_summary_csr (p_payment_instruction_id IN NUMBER,
2024: p_fv_treasury_symbol_agg XMLTYPE) IS
2025: SELECT XMLElement("FederalInstructionInfo",
2026: XMLElement("TreasurySymbols", p_fv_treasury_symbol_agg),
2027: XMLElement("ControlNumber", control_number),
2028: XMLElement("ECSSummaryDosSeqNumber", iby_utility_pvt.get_view_param('FV_ECS_SEQ'))

Line 2055: RETURN XMLTYPE

2051: END Get_Ins_FVFieldsAgg;
2052:
2053:
2054: FUNCTION Get_Ins_PayerInstrAgg(p_payment_instruction_id IN NUMBER)
2055: RETURN XMLTYPE
2056: IS
2057: l_payerinstr_agg XMLTYPE;
2058: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_PayerInstrAgg';
2059: /* perf bug- 6763515 */

Line 2057: l_payerinstr_agg XMLTYPE;

2053:
2054: FUNCTION Get_Ins_PayerInstrAgg(p_payment_instruction_id IN NUMBER)
2055: RETURN XMLTYPE
2056: IS
2057: l_payerinstr_agg XMLTYPE;
2058: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_PayerInstrAgg';
2059: /* perf bug- 6763515 */
2060:
2061:

Line 2316: RETURN XMLTYPE

2312: RAISE;
2313: END Get_Ins_PayerInstrAgg;
2314:
2315: FUNCTION Get_Payer(p_legal_entity_id IN NUMBER)
2316: RETURN XMLTYPE
2317: IS
2318: l_payer XMLTYPE;
2319: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payer';
2320: CURSOR l_payer_csr (p_legal_entity_id IN NUMBER) IS

Line 2318: l_payer XMLTYPE;

2314:
2315: FUNCTION Get_Payer(p_legal_entity_id IN NUMBER)
2316: RETURN XMLTYPE
2317: IS
2318: l_payer XMLTYPE;
2319: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payer';
2320: CURSOR l_payer_csr (p_legal_entity_id IN NUMBER) IS
2321: SELECT payer
2322: FROM iby_xml_fd_payer_1_0_v

Line 2361: RETURN XMLTYPE

2357: END Get_Payer;
2358:
2359:
2360: FUNCTION Get_PayerBankAccount(p_bank_account_id IN NUMBER)
2361: RETURN XMLTYPE
2362: IS
2363: l_payer_ba XMLTYPE;
2364: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerBankAccount';
2365: CURSOR l_payer_ba_csr (p_bank_account_id IN NUMBER) IS

Line 2363: l_payer_ba XMLTYPE;

2359:
2360: FUNCTION Get_PayerBankAccount(p_bank_account_id IN NUMBER)
2361: RETURN XMLTYPE
2362: IS
2363: l_payer_ba XMLTYPE;
2364: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerBankAccount';
2365: CURSOR l_payer_ba_csr (p_bank_account_id IN NUMBER) IS
2366: SELECT int_bank_account
2367: FROM iby_xml_fd_prba_1_0_v

Line 2405: RETURN XMLTYPE

2401: END Get_PayerBankAccount;
2402:
2403:
2404: FUNCTION Get_Payer_Denorm(p_payment_id IN NUMBER)
2405: RETURN XMLTYPE
2406: IS
2407: l_payer XMLTYPE;
2408: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payer_Denorm';
2409: CURSOR l_payer_csr (p_payment_id IN NUMBER) IS

Line 2407: l_payer XMLTYPE;

2403:
2404: FUNCTION Get_Payer_Denorm(p_payment_id IN NUMBER)
2405: RETURN XMLTYPE
2406: IS
2407: l_payer XMLTYPE;
2408: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payer_Denorm';
2409: CURSOR l_payer_csr (p_payment_id IN NUMBER) IS
2410: SELECT payer
2411: FROM iby_xml_fd_payer_1_0_v

Line 2445: RETURN XMLTYPE

2441: END Get_Payer_Denorm;
2442:
2443:
2444: FUNCTION Get_PayerBankAccount_Denorm(p_payment_id IN NUMBER)
2445: RETURN XMLTYPE
2446: IS
2447: l_payer_ba XMLTYPE;
2448: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerBankAccount_Denorm';
2449: CURSOR l_payer_ba_csr (p_payment_id IN NUMBER) IS

Line 2447: l_payer_ba XMLTYPE;

2443:
2444: FUNCTION Get_PayerBankAccount_Denorm(p_payment_id IN NUMBER)
2445: RETURN XMLTYPE
2446: IS
2447: l_payer_ba XMLTYPE;
2448: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerBankAccount_Denorm';
2449: CURSOR l_payer_ba_csr (p_payment_id IN NUMBER) IS
2450: SELECT int_bank_account
2451: FROM iby_xml_fd_prba_1_0_v

Line 2484: RETURN XMLTYPE

2480: END Get_PayerBankAccount_Denorm;
2481:
2482:
2483: FUNCTION Get_PayerIns_Denorm(p_payment_instruction_id IN NUMBER)
2484: RETURN XMLTYPE
2485: IS
2486: l_payment_id NUMBER;
2487: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerIns_Denorm';
2488: CURSOR l_ins_payment_csr (p_payment_instruction_id IN NUMBER) IS

Line 2516: RETURN XMLTYPE

2512: END Get_PayerIns_Denorm;
2513:
2514:
2515: FUNCTION Get_PayerBankAccountIns_Denorm(p_payment_instruction_id IN NUMBER)
2516: RETURN XMLTYPE
2517: IS
2518: l_payment_id NUMBER;
2519: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerBankAccountIns_Denorm';
2520: CURSOR l_ins_payment_csr (p_payment_instruction_id IN NUMBER) IS

Line 2548: RETURN XMLTYPE

2544: END Get_PayerBankAccountIns_Denorm;
2545:
2546:
2547: FUNCTION Get_Ins_AccountSettingsAgg(p_bep_account_id IN NUMBER)
2548: RETURN XMLTYPE
2549: IS
2550: l_acctsettings_agg XMLTYPE;
2551:
2552: CURSOR l_acctsettings_csr (p_bep_account_id IN NUMBER) IS

Line 2550: l_acctsettings_agg XMLTYPE;

2546:
2547: FUNCTION Get_Ins_AccountSettingsAgg(p_bep_account_id IN NUMBER)
2548: RETURN XMLTYPE
2549: IS
2550: l_acctsettings_agg XMLTYPE;
2551:
2552: CURSOR l_acctsettings_csr (p_bep_account_id IN NUMBER) IS
2553: SELECT XMLAgg(account_setting)
2554: FROM iby_xml_fd_acct_settings_1_0_v

Line 2570: RETURN XMLTYPE

2566:
2567:
2568:
2569: FUNCTION Get_Pmt_DocPayableAgg(p_payment_id IN NUMBER)
2570: RETURN XMLTYPE
2571: IS
2572: l_docpayable_agg XMLTYPE;
2573: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_DocPayableAgg';
2574:

Line 2572: l_docpayable_agg XMLTYPE;

2568:
2569: FUNCTION Get_Pmt_DocPayableAgg(p_payment_id IN NUMBER)
2570: RETURN XMLTYPE
2571: IS
2572: l_docpayable_agg XMLTYPE;
2573: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_DocPayableAgg';
2574:
2575: CURSOR l_docpayable_csr (p_payment_id IN NUMBER) IS
2576: SELECT XMLAgg(doc_payable)

Line 2632: RETURN XMLTYPE

2628: END Get_Pmt_DocPayableAgg;
2629:
2630:
2631: FUNCTION Get_Payee(p_payment_id IN NUMBER)
2632: RETURN XMLTYPE
2633: IS
2634: l_payee XMLTYPE;
2635: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payee';
2636: l_pmt_func VARCHAR2(1);

Line 2634: l_payee XMLTYPE;

2630:
2631: FUNCTION Get_Payee(p_payment_id IN NUMBER)
2632: RETURN XMLTYPE
2633: IS
2634: l_payee XMLTYPE;
2635: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payee';
2636: l_pmt_func VARCHAR2(1);
2637:
2638: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS

Line 2695: RETURN XMLTYPE

2691:
2692:
2693: /* TPP - Start */
2694: FUNCTION Get_InvPayee(p_payment_id IN NUMBER)
2695: RETURN XMLTYPE
2696: IS
2697: l_payee XMLTYPE;
2698: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payee';
2699:

Line 2697: l_payee XMLTYPE;

2693: /* TPP - Start */
2694: FUNCTION Get_InvPayee(p_payment_id IN NUMBER)
2695: RETURN XMLTYPE
2696: IS
2697: l_payee XMLTYPE;
2698: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Payee';
2699:
2700: CURSOR l_payee_csr (p_payment_id IN NUMBER) IS
2701: SELECT payee

Line 2833: RETURN XMLTYPE

2829: /* TPP - End */
2830:
2831:
2832: FUNCTION Get_PayeeBankAccount(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
2833: RETURN XMLTYPE
2834: IS
2835: l_payee_ba XMLTYPE;
2836: l_pmt_func VARCHAR2(1);
2837: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount';

Line 2835: l_payee_ba XMLTYPE;

2831:
2832: FUNCTION Get_PayeeBankAccount(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
2833: RETURN XMLTYPE
2834: IS
2835: l_payee_ba XMLTYPE;
2836: l_pmt_func VARCHAR2(1);
2837: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount';
2838:
2839: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS

Line 2900: RETURN XMLTYPE

2896: END Get_PayeeBankAccount;
2897:
2898:
2899: FUNCTION Get_PayeeBankAccount_Denorm(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
2900: RETURN XMLTYPE
2901: IS
2902: l_payee_ba XMLTYPE;
2903: l_pmt_func VARCHAR2(1);
2904: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount_Denorm';

Line 2902: l_payee_ba XMLTYPE;

2898:
2899: FUNCTION Get_PayeeBankAccount_Denorm(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
2900: RETURN XMLTYPE
2901: IS
2902: l_payee_ba XMLTYPE;
2903: l_pmt_func VARCHAR2(1);
2904: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount_Denorm';
2905:
2906: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS

Line 2967: RETURN XMLTYPE

2963: END Get_PayeeBankAccount_Denorm;
2964:
2965:
2966: FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER)
2967: RETURN XMLTYPE
2968: IS
2969: l_docline_agg XMLTYPE;
2970: l_conc_invalid_chars VARCHAR2(50);
2971: l_conc_replacement_chars VARCHAR2(50);

Line 2969: l_docline_agg XMLTYPE;

2965:
2966: FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER)
2967: RETURN XMLTYPE
2968: IS
2969: l_docline_agg XMLTYPE;
2970: l_conc_invalid_chars VARCHAR2(50);
2971: l_conc_replacement_chars VARCHAR2(50);
2972: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Doc_DocLineAgg';
2973:

Line 3453: RETURN XMLTYPE

3449:
3450:
3451: -- Payment process request extract functions
3452: FUNCTION Get_Ppr_PmtAgg(p_payment_service_request_id IN NUMBER)
3453: RETURN XMLTYPE
3454: IS
3455: l_ppr_pmt_agg XMLTYPE;
3456:
3457: CURSOR l_ppr_pmt_csr (p_payment_service_request_id IN NUMBER) IS

Line 3455: l_ppr_pmt_agg XMLTYPE;

3451: -- Payment process request extract functions
3452: FUNCTION Get_Ppr_PmtAgg(p_payment_service_request_id IN NUMBER)
3453: RETURN XMLTYPE
3454: IS
3455: l_ppr_pmt_agg XMLTYPE;
3456:
3457: CURSOR l_ppr_pmt_csr (p_payment_service_request_id IN NUMBER) IS
3458: SELECT XMLAgg(payment)
3459: FROM iby_xml_fd_pmt_1_0_v

Line 3494: RETURN XMLTYPE

3490: END Get_Ppr_PmtCount;
3491:
3492:
3493: FUNCTION Get_Ppr_PreBuildDocAgg(p_payment_service_request_id IN NUMBER)
3494: RETURN XMLTYPE
3495: IS
3496: l_docpayable_agg XMLTYPE;
3497:
3498: CURSOR l_baddoc_csr (p_payment_service_request_id IN NUMBER) IS

Line 3496: l_docpayable_agg XMLTYPE;

3492:
3493: FUNCTION Get_Ppr_PreBuildDocAgg(p_payment_service_request_id IN NUMBER)
3494: RETURN XMLTYPE
3495: IS
3496: l_docpayable_agg XMLTYPE;
3497:
3498: CURSOR l_baddoc_csr (p_payment_service_request_id IN NUMBER) IS
3499: SELECT XMLAgg(doc_payable)
3500: FROM iby_xml_fd_doc_1_0_v

Line 3539: RETURN XMLTYPE

3535: END Get_Ppr_PreBuildDocCount;
3536:
3537:
3538: FUNCTION Get_Pmt_PmtErrAgg(p_payment_id IN NUMBER)
3539: RETURN XMLTYPE
3540: IS
3541: l_pmterr_agg XMLTYPE;
3542: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_PmtErrAgg';
3543: CURSOR l_pmterr_csr (p_payment_id IN NUMBER) IS

Line 3541: l_pmterr_agg XMLTYPE;

3537:
3538: FUNCTION Get_Pmt_PmtErrAgg(p_payment_id IN NUMBER)
3539: RETURN XMLTYPE
3540: IS
3541: l_pmterr_agg XMLTYPE;
3542: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_PmtErrAgg';
3543: CURSOR l_pmterr_csr (p_payment_id IN NUMBER) IS
3544: SELECT XMLAgg(payment_error)
3545: FROM iby_xml_fd_pmt_err_1_0_v

Line 3568: RETURN XMLTYPE

3564: END Get_Pmt_PmtErrAgg;
3565:
3566:
3567: FUNCTION Get_Doc_DocErrAgg(p_document_payable_id IN NUMBER)
3568: RETURN XMLTYPE
3569: IS
3570: l_docerr_agg XMLTYPE;
3571:
3572: CURSOR l_docerr_csr (p_document_payable_id IN NUMBER) IS

Line 3570: l_docerr_agg XMLTYPE;

3566:
3567: FUNCTION Get_Doc_DocErrAgg(p_document_payable_id IN NUMBER)
3568: RETURN XMLTYPE
3569: IS
3570: l_docerr_agg XMLTYPE;
3571:
3572: CURSOR l_docerr_csr (p_document_payable_id IN NUMBER) IS
3573: SELECT XMLAgg(doc_payable_error)
3574: FROM iby_xml_fd_doc_err_1_0_v

Line 3696: RETURN XMLTYPE

3692:
3693: END initialize;
3694:
3695: FUNCTION Get_Hz_Address(p_location_id IN NUMBER)
3696: RETURN XMLTYPE
3697: IS
3698: l_hz_addr XMLTYPE;
3699:
3700: CURSOR l_hz_addr_csr (p_location_id IN NUMBER) IS

Line 3698: l_hz_addr XMLTYPE;

3694:
3695: FUNCTION Get_Hz_Address(p_location_id IN NUMBER)
3696: RETURN XMLTYPE
3697: IS
3698: l_hz_addr XMLTYPE;
3699:
3700: CURSOR l_hz_addr_csr (p_location_id IN NUMBER) IS
3701: SELECT address
3702: FROM IBY_XML_HZ_ADDR_1_0_V

Line 3738: RETURN XMLTYPE

3734:
3735:
3736:
3737: FUNCTION Get_Account_Address(p_location_id IN NUMBER, p_country IN VARCHAR2)
3738: RETURN XMLTYPE
3739: IS
3740: l_hz_addr XMLTYPE;
3741:
3742: CURSOR l_hz_addr_csr (p_location_id IN NUMBER) IS

Line 3740: l_hz_addr XMLTYPE;

3736:
3737: FUNCTION Get_Account_Address(p_location_id IN NUMBER, p_country IN VARCHAR2)
3738: RETURN XMLTYPE
3739: IS
3740: l_hz_addr XMLTYPE;
3741:
3742: CURSOR l_hz_addr_csr (p_location_id IN NUMBER) IS
3743: SELECT address
3744: FROM IBY_XML_HZ_ADDR_1_0_V

Line 3795: RETURN XMLTYPE

3791:
3792:
3793:
3794: FUNCTION Get_Hr_Address(p_location_id IN NUMBER)
3795: RETURN XMLTYPE
3796: IS
3797: l_hr_addr XMLTYPE;
3798:
3799: CURSOR l_hr_addr_csr (p_location_id IN NUMBER) IS

Line 3797: l_hr_addr XMLTYPE;

3793:
3794: FUNCTION Get_Hr_Address(p_location_id IN NUMBER)
3795: RETURN XMLTYPE
3796: IS
3797: l_hr_addr XMLTYPE;
3798:
3799: CURSOR l_hr_addr_csr (p_location_id IN NUMBER) IS
3800: SELECT address
3801: FROM IBY_XML_HR_ADDR_1_0_V