APPS.IBY_DISBURSE_SUBMIT_PUB_PKG dependencies on IBY_PAYMENT_PROFILES

Line 2021: FROM iby_payments_all pmts, iby_payment_profiles prof

2017:
2018:
2019: SELECT Count(pmts.payment_id)
2020: INTO l_pmts_invalid_pdoc
2021: FROM iby_payments_all pmts, iby_payment_profiles prof
2022: WHERE pmts.payment_profile_id = prof.payment_profile_id
2023: AND prof.processing_type = 'PRINTED'
2024: AND pmts.payment_service_request_id = l_payreq_id
2025: AND NOT EXISTS (SELECT 'Default Doc in Sync with Acc'

Line 5483: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,

5479: | NOTES:
5480: |
5481: *---------------------------------------------------------------------*/
5482: PROCEDURE get_profile_process_attribs(
5483: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,
5484: x_profile_attribs IN OUT NOCOPY profileProcessAttribs
5485: )
5486: IS
5487:

Line 5570: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,

5566: | NOTES:
5567: |
5568: *---------------------------------------------------------------------*/
5569: PROCEDURE checkIfDefaultPmtDocOnProfile (
5570: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,
5571: x_profile_name IN OUT NOCOPY IBY_PAYMENT_PROFILES.system_profile_name%TYPE,
5572: x_return_flag IN OUT NOCOPY BOOLEAN
5573: )
5574:

Line 5571: x_profile_name IN OUT NOCOPY IBY_PAYMENT_PROFILES.system_profile_name%TYPE,

5567: |
5568: *---------------------------------------------------------------------*/
5569: PROCEDURE checkIfDefaultPmtDocOnProfile (
5570: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE,
5571: x_profile_name IN OUT NOCOPY IBY_PAYMENT_PROFILES.system_profile_name%TYPE,
5572: x_return_flag IN OUT NOCOPY BOOLEAN
5573: )
5574:
5575: IS

Line 5577: l_default_pmt_doc_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;

5573: )
5574:
5575: IS
5576:
5577: l_default_pmt_doc_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
5578: l_module_name VARCHAR2(200) := G_PKG_NAME
5579: || '.checkIfDefaultPmtDocOnProfile';
5580:
5581: BEGIN

Line 5906: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE

5902: | NOTES:
5903: |
5904: *---------------------------------------------------------------------*/
5905: PROCEDURE set_profile_attribs(
5906: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE
5907: ) IS
5908: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
5909: '.set_profile_attribs';
5910: l_ppp_rec IBY_PAYMENT_PROFILES%rowtype;

Line 5910: l_ppp_rec IBY_PAYMENT_PROFILES%rowtype;

5906: p_profile_id IN IBY_PAYMENT_PROFILES.payment_profile_id%TYPE
5907: ) IS
5908: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
5909: '.set_profile_attribs';
5910: l_ppp_rec IBY_PAYMENT_PROFILES%rowtype;
5911: BEGIN
5912:
5913: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5914: print_debuginfo(l_module_name, 'ENTER');

Line 5920: FROM IBY_PAYMENT_PROFILES

5916: END IF;
5917: BEGIN
5918: SELECT *
5919: INTO l_ppp_rec
5920: FROM IBY_PAYMENT_PROFILES
5921: WHERE payment_profile_id = p_profile_id;
5922: EXCEPTION
5923: WHEN OTHERS THEN
5924: l_ppp_rec := null;