APPS.PV_PRICE_PVT dependencies on PV_PG_ENRL_REQUESTS

Line 135: l_enrl_req_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;

131: l_billing_address_exists boolean := false;
132: l_line_has_price_error boolean := false;
133: l_has_price_error boolean := false;
134: l_program_name varchar2(60);
135: l_enrl_req_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
136: l_uom_code VARCHAR2(10);
137:
138:
139:

Line 143: FROM PV_PARTNER_PROGRAM_B pvpp, PV_PG_ENRL_REQUESTS pver,

139:
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)

Line 163: from pv_partner_program_vl pvppv, PV_PG_ENRL_REQUESTS pver

159: ORDER BY LiNE_INDEX;
160:
161: CURSOR c_program_name (cv_enrl_request_id NUMBER) IS
162: select pvppv.program_name
163: from pv_partner_program_vl pvppv, PV_PG_ENRL_REQUESTS pver
164: where pver.enrl_request_id = cv_enrl_request_id
165: and pver.program_id = pvppv.program_id;
166:
167:

Line 569: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests

565: l_enrl_req_rec.membership_fee := l_adjusted_unit_price;
566: l_enrl_req_rec.trans_curr_code := l_currency_code;
567:
568:
569: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests
570: (
571: p_api_version_number => p_api_version_number,
572: p_init_msg_list => Fnd_Api.G_FALSE,
573: p_commit => Fnd_Api.G_FALSE,

Line 588: update pv_pg_enrl_requests

584: RAISE FND_API.g_exc_unexpected_error;
585: END IF;
586:
587:
588: update pv_pg_enrl_requests
589: set MEMBERSHIP_FEE = l_adjusted_unit_price , TRANS_CURR_CODE = l_currency_code
590: where enrl_request_id = l_enrl_req_id_tbl(l_line_index);
591:
592: ELSIF (l_line_type_code = 'ORDER') THEN