APPS.PV_PARTNER_CONTRACTS_PVT dependencies on JTF_NUMBER_TABLE

Line 100: --,x_program_id_tbl OUT NOCOPY JTF_NUMBER_TABLE

96: ,x_exist OUT NOCOPY VARCHAR2
97:
98: --,x_contract_status_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
99: --,x_program_name_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
100: --,x_program_id_tbl OUT NOCOPY JTF_NUMBER_TABLE
101: --,x_enrl_request_id_tbl OUT NOCOPY JTF_NUMBER_TABLE
102: )
103: IS
104: L_API_NAME CONSTANT VARCHAR2(30) := 'Is_Contract_Exist_Then_Create';

Line 101: --,x_enrl_request_id_tbl OUT NOCOPY JTF_NUMBER_TABLE

97:
98: --,x_contract_status_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
99: --,x_program_name_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
100: --,x_program_id_tbl OUT NOCOPY JTF_NUMBER_TABLE
101: --,x_enrl_request_id_tbl OUT NOCOPY JTF_NUMBER_TABLE
102: )
103: IS
104: L_API_NAME CONSTANT VARCHAR2(30) := 'Is_Contract_Exist_Then_Create';
105: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 142: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

138: AND (term.end_date is null or term.end_date > sysdate)
139: AND ppc.geo_hierarchy_id = cv_geo_hierarchy_id;
140:
141:
142: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
143: l_contract_id NUMBER;
144: l_geo_hierarchy_id NUMBER;
145: l_geo_cnt NUMBER;
146: l_partner_party_id NUMBER;

Line 404: l_geo_hierarchy_ids_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

400: AND NVL(l.start_date_active, SYSDATE)<=SYSDATE
401: AND NVL(l.end_date_active, SYSDATE)>=SYSDATE
402: order by meaning;
403:
404: l_geo_hierarchy_ids_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
405: l_geo_hierarchy_id NUMBER;
406: l_get_all_cntr_types boolean := false;
407: l_msg_count number;
408: l_msg_data varchar2(200);