APPS.PV_PRTNR_PMNT_TYPES_PVT dependencies on JTF_VARCHAR2_TABLE_200

Line 29: p_payment_type_tbl_in IN JTF_VARCHAR2_TABLE_200

25: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvptsb.pls';
26:
27: PROCEDURE VerifyPaymentTypes
28: (
29: p_payment_type_tbl_in IN JTF_VARCHAR2_TABLE_200
30: , p_invoice IN VARCHAR2
31: , p_credit_card_exists IN VARCHAR2
32: , x_payment_type_tbl_out OUT NOCOPY JTF_VARCHAR2_TABLE_200
33: ) IS

Line 32: , x_payment_type_tbl_out OUT NOCOPY JTF_VARCHAR2_TABLE_200

28: (
29: p_payment_type_tbl_in IN JTF_VARCHAR2_TABLE_200
30: , p_invoice IN VARCHAR2
31: , p_credit_card_exists IN VARCHAR2
32: , x_payment_type_tbl_out OUT NOCOPY JTF_VARCHAR2_TABLE_200
33: ) IS
34:
35: l_oe_query_str VARCHAR2(3000);
36:

Line 45: CURSOR x_enrq_param_cur( pymnt_type_tbl JTF_VARCHAR2_TABLE_200) IS

41:
42: TYPE csr_type IS REF CURSOR;
43: oe_csr csr_type ;
44:
45: CURSOR x_enrq_param_cur( pymnt_type_tbl JTF_VARCHAR2_TABLE_200) IS
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

Line 46: SELECT * FROM TABLE( CAST (pymnt_type_tbl AS JTF_VARCHAR2_TABLE_200)) order by column_value;

42: TYPE csr_type IS REF CURSOR;
43: oe_csr csr_type ;
44:
45: CURSOR x_enrq_param_cur( pymnt_type_tbl JTF_VARCHAR2_TABLE_200) IS
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

Line 63: x_payment_type_tbl_out := JTF_VARCHAR2_TABLE_200();

59: );
60:
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:

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;

Line 99: ,x_payment_type_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_200

95: END VerifyPaymentTypes;
96:
97: PROCEDURE Get_prtnr_payment_types(
98: p_partner_party_id IN NUMBER
99: ,x_payment_type_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_200
100: ,x_is_po_number_enabled OUT NOCOPY VARCHAR2
101: )
102: IS
103: l_api_name CONSTANT VARCHAR2(45) := 'Get_prtnr_payment_types';

Line 148: l_payment_type_tbl JTF_VARCHAR2_TABLE_200:= JTF_VARCHAR2_TABLE_200();

144:
145: l_invoice VARCHAR2(200);
146: l_credit_card_exists VARCHAR2(1);
147: l_is_po_num_enabled VARCHAR2(1);
148: l_payment_type_tbl JTF_VARCHAR2_TABLE_200:= JTF_VARCHAR2_TABLE_200();
149:
150:
151: BEGIN
152:

Line 153: x_payment_type_tbl := JTF_VARCHAR2_TABLE_200();

149:
150:
151: BEGIN
152:
153: x_payment_type_tbl := JTF_VARCHAR2_TABLE_200();
154:
155: for x in c_pmnt_geo_hierarchy_ids loop
156: l_geo_hierarchy_ids_tbl.extend;
157: l_geo_hierarchy_ids_tbl(l_geo_hierarchy_ids_tbl.count) := x.geo_hierarchy_id;