APPS.PV_PRTNR_PMNT_TYPES_PVT dependencies on OE_PAYMENT_TYPES_VL

Line 16: -- the x_payment_type_tbl_out only if its enabled in oe_payment_types_vl and exists

12: -- p_credit_card_exists which would be used to validate if credit card is
13: -- enabled in payments view.
14: -- Also made changes to Get_prtnr_payment_types api. It wont include CREDIT_CARD
15: -- in the x_payment_type_tbl that gets passed to VerifyPaymentTypes. Its added to
16: -- the x_payment_type_tbl_out only if its enabled in oe_payment_types_vl and exists
17: -- in iby_fndcpt_all_pmt_channels_v (doing this as we create transaction extension
18: -- for just CREDIT_CARD type.
19: -- NOTE :
20: -- Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA

Line 50: FROM oe_payment_types_vl

46: SELECT * FROM TABLE( CAST (pymnt_type_tbl AS JTF_VARCHAR2_TABLE_200)) order by column_value;
47:
48: CURSOR c_get_credit_card_type IS
49: SELECT payment_type_code, name
50: FROM oe_payment_types_vl
51: WHERE payment_type_code = 'CREDIT_CARD'
52: AND NVL(start_date_active, sysdate) <= sysdate
53: AND NVL(end_date_active,sysdate+1) >= sysdate
54: AND enabled_flag='Y'

Line 65: l_oe_query_str := 'SELECT name ||''%''||payment_type_code FROM oe_payment_types_vl WHERE payment_type_code IN ( SELECT * FROM TABLE (CAST(:1' || 'AS JTF_VARCHAR2_TABLE_200)))';

61: BEGIN
62:
63: x_payment_type_tbl_out := JTF_VARCHAR2_TABLE_200();
64:
65: l_oe_query_str := 'SELECT name ||''%''||payment_type_code FROM oe_payment_types_vl WHERE payment_type_code IN ( SELECT * FROM TABLE (CAST(:1' || 'AS JTF_VARCHAR2_TABLE_200)))';
66: l_oe_query_str := l_oe_query_str || 'AND NVL(start_date_active, SYSDATE) <= SYSDATE AND NVL(end_date_active,sysdate+1)>=sysdate and enabled_flag=''Y''';
67:
68: OPEN oe_csr FOR l_oe_query_str USING p_payment_type_tbl_in;
69: FETCH oe_csr BULK COLLECT INTO x_payment_type_tbl_out;