APPS.PV_PRICE_PVT dependencies on JTF_NUMBER_TABLE

Line 54: ,p_enrl_req_id IN JTF_NUMBER_TABLE

50: ,p_partner_account_id IN NUMBER
51: ,p_partner_party_id IN NUMBER
52: ,p_contact_party_id IN NUMBER
53: ,p_transaction_currency IN VARCHAR2
54: ,p_enrl_req_id IN JTF_NUMBER_TABLE
55: ,x_return_status OUT NOCOPY VARCHAR2
56: ,x_msg_count OUT NOCOPY NUMBER
57: ,x_msg_data OUT NOCOPY VARCHAR2
58: )

Line 66: l_inventory_item_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

62: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
63:
64: l_inventory_item_id NUMBER;
65: l_enrl_req_id NUMBER;
66: l_inventory_item_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
67: l_enrl_req_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
68: l_obj_ver_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
69:
70:

Line 67: l_enrl_req_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

63:
64: l_inventory_item_id NUMBER;
65: l_enrl_req_id NUMBER;
66: l_inventory_item_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
67: l_enrl_req_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
68: l_obj_ver_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
69:
70:
71: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

Line 68: l_obj_ver_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

64: l_inventory_item_id NUMBER;
65: l_enrl_req_id NUMBER;
66: l_inventory_item_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
67: l_enrl_req_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
68: l_obj_ver_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
69:
70:
71: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
72: G_LiNE_iNDEX_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;

Line 144: (Select column_value from table (CAST(p_enrl_req_id AS JTF_NUMBER_TABLE))) erequests

140: -- Cursor to get partner program inventoty item id
141: CURSOR c_inventory_item_id IS
142: SELECT /*+ CARDINALITY(erequests 10) */ pvpp.inventory_item_id, pver.enrl_request_id, pver.object_version_number
143: FROM PV_PARTNER_PROGRAM_B pvpp, PV_PG_ENRL_REQUESTS pver,
144: (Select column_value from table (CAST(p_enrl_req_id AS JTF_NUMBER_TABLE))) erequests
145: WHERE pver.enrl_request_id = erequests.column_value
146: and pver.PROGRAM_ID = pvpp.program_id
147: and pver.custom_setup_id in (7004, 7005)
148: and (pver.order_header_id is null