APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on DUAL

Line 2202: FROM dual;

2198: XMLElement("EmailAddress", l_email),
2199: XMLElement("Website", l_url)
2200: )
2201: INTO l_contactinfo
2202: FROM dual;
2203:
2204: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2205: iby_debug_pub.add(debug_msg => 'EXIT get_payer_contact',
2206: debug_level => G_LEVEL_STATEMENT,

Line 2356: FROM dual;

2352: XMLElement("EmailAddress", l_email),
2353: XMLElement("Website", l_url)
2354: )
2355: INTO l_contactinfo
2356: FROM dual;
2357: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2358: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2359: debug_level => G_LEVEL_PROCEDURE,
2360: module => l_Debug_Module);

Line 2550: FROM dual;

2546: XMLElement("EmailAddress", l_email),
2547: XMLElement("Website", l_url)
2548: )
2549: INTO l_contactinfo
2550: FROM dual;
2551: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2552: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2553: debug_level => G_LEVEL_PROCEDURE,
2554: module => l_Debug_Module);

Line 2872: -- for payment format: reprint individual and ranges

2868: AND ((xml_pmt_lvl.payment_status in ('INSTRUCTION_CREATED',
2869: 'VOID_BY_SETUP', 'VOID_BY_OVERFLOW') AND ins.process_type = 'STANDARD') OR
2870: ins.process_type = 'IMMEDIATE');
2871:
2872: -- for payment format: reprint individual and ranges
2873: CURSOR l_payerinstr_reprt_csr (p_payment_instruction_id IN NUMBER) IS
2874: SELECT XMLAgg(xml_pmt_lvl.payment)
2875: FROM
2876: iby_xml_fd_pmt_1_0_v xml_pmt_lvl,

Line 5061: FROM DUAL;

5057: XMLElement("Country", l_country), XMLElement("ISO3DigitCountry", l_iso_territory_code),
5058: XMLElement("CountryName", l_territory_short_name), XMLElement("PostalCode", l_postal_code),
5059: XMLElement("PreFormattedConcatenatedAddress", l_concat_addr),
5060: XMLElement("PreFormattedMailingAddress", l_mail_addr, 'POSTAL_ADDR')) INTO l_hz_addr
5061: FROM DUAL;
5062:
5063: RETURN l_hz_addr;
5064:
5065:

Line 5167: FROM dual ;

5163:
5164: SELECT XMLConcat( XMLElement("Country", p_country),
5165: XMLElement("ISO3DigitCountry", l_te_code),
5166: XMLElement("CountryName", l_te_sname) ) INTO l_hz_addr
5167: FROM dual ;
5168:
5169: RETURN l_hz_addr;
5170: END IF;
5171: END IF;

Line 5231: FROM DUAL;

5227: XMLElement("Country", l_country), XMLElement("ISO3DigitCountry", l_iso_territory_code),
5228: XMLElement("CountryName", l_territory_short_name), XMLElement("PostalCode", l_postal_code),
5229: XMLElement("PreFormattedConcatenatedAddress", l_concat_addr),
5230: XMLElement("PreFormattedMailingAddress", l_mail_addr, 'POSTAL_ADDR')) INTO l_hz_addr
5231: FROM DUAL;
5232:
5233: RETURN l_hz_addr;
5234:
5235: END Get_Account_Address;

Line 5357: FROM DUAL;

5353: XMLElement("CountryName", l_territory_short_name),XMLElement("PostalCode", l_postal_code),
5354: XMLElement("PreFormattedConcatenatedAddress", l_concat_addr),
5355: XMLElement("PreFormattedMailingAddress", l_mail_addr),
5356: XMLElement("AddressName", l_location_code) ) INTO l_hr_addr
5357: FROM DUAL;
5358:
5359: RETURN l_hr_addr;
5360:
5361: END Get_Hr_Address;

Line 5530: from dual;

5526:
5527: CURSOR cc_num_ext_agg(p_card_num varchar2) is
5528: Select XMLAgg(
5529: XMLElement("CreditCardNumber",p_card_num))
5530: from dual;
5531:
5532: BEGIN
5533:
5534: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5858: into l_intermediary_accounts from dual;

5854: (XMLELEMENT("City",l_city2)),
5855: (XMLELEMENT("Country",l_country_code2)),
5856: (XMLELEMENT("Comments",l_comments2)) )
5857: )
5858: into l_intermediary_accounts from dual;
5859:
5860: RETURN l_intermediary_accounts;
5861:
5862: END Get_Intermediary_Bank_Accts;

Line 5957: into g_inter_accts_tbl(l_instr_assign_id) from dual;

5953: g_inter_accts_tbl(l_instr_assign_id):=null;
5954: ELSE
5955: SELECT XMLCONCAT(XMLELEMENT("PayeeBankAccountAssignment",
5956: XMLELEMENT("DescriptiveFlexField",IBY_EXTRACTGEN_PVT.Get_Dffs('IBY_PMT_INSTR_USES_ALL',l_instr_assign_id, null))))
5957: into g_inter_accts_tbl(l_instr_assign_id) from dual;
5958: END IF;
5959: ELSE
5960: RETURN g_inter_accts_tbl(l_instr_assign_id);
5961: END IF;

Line 5971: into l_assign_dff from dual;

5967: l_assign_dff := null;
5968: ELSE
5969: SELECT XMLCONCAT(XMLELEMENT("PayeeBankAccountAssignment",
5970: XMLELEMENT("DescriptiveFlexField",IBY_EXTRACTGEN_PVT.Get_Dffs('IBY_PMT_INSTR_USES_ALL',l_instr_assign_id, null))))
5971: into l_assign_dff from dual;
5972: END IF;
5973: RETURN l_assign_dff;
5974: END IF;
5975: END IF;