eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PRGM_APPROVAL_PVT dependencies on PV_PG_ENRL_REQUESTS

Line 347: FROM pv_pg_enrl_requests

343: AND eni.enrl_request_id=p_enrl_req_id;
344:
345: CURSOR enr_requests_dtl_cur (p_enrl_req_id number) IS
346: SELECT enrollment_type_code,program_id,tentative_start_date,tentative_end_date,request_status_code,partner_id,dependent_program_id
347: FROM pv_pg_enrl_requests
348: WHERE enrl_request_id=p_enrl_req_id;
349:
350: CURSOR memb_type_cur(p_ptnr_id IN NUMBER) IS
351: SELECT attr_value

Line 662: FROM pv_pg_enrl_requests

658: l_temp varchar2(30);
659: isApprovable boolean:=false;
660: CURSOR rec_cur(p_enrl_req_id number) IS
661: SELECT contract_status_code
662: FROM pv_pg_enrl_requests
663: WHERE enrl_request_id=p_enrl_req_id;
664:
665: BEGIN
666: OPEN rec_cur(p_enrollment_req_id);

Line 689: FROM pv_pg_enrl_requests enrq, pv_partner_program_b prgm

685:
686: isChecked boolean:=false;
687: CURSOR rec_cur(p_enrl_req_id number) IS
688: SELECT prgm.allow_enrl_wout_chklst_flag
689: FROM pv_pg_enrl_requests enrq, pv_partner_program_b prgm
690: WHERE enrq.program_id=prgm.program_id
691: AND enrl_request_id=p_enrl_req_id;
692:
693: CURSOR checklistresponse_cur(p_enrl_req_id number) IS

Line 2178: ,pv_pg_enrl_requests pper

2174: ,ppvl.program_name
2175: ,fl.description enrollment_type
2176: FROM pv_partner_program_vl ppvl
2177: ,fnd_lookups fl
2178: ,pv_pg_enrl_requests pper
2179: ,pv_partner_profiles ppp
2180: ,hz_parties PARTNER
2181: WHERE pper.partner_id = ppp.partner_id
2182: AND ppp.partner_id=PARTNER.party_id

Line 2193: ,pv_pg_enrl_requests pper

2189: ,ppvl.program_name
2190: ,fl.description enrollment_type
2191: FROM pv_partner_program_vl ppvl
2192: ,fnd_lookups fl
2193: ,pv_pg_enrl_requests pper
2194: ,pv_partner_profiles ppp
2195: ,hz_parties PARTNER
2196:
2197: WHERE pper.partner_id = ppp.partner_id

Line 2486: FROM pv_pg_enrl_requests

2482: ) IS
2483:
2484: CURSOR enr_request_cur(p_enrl_req_id number) IS
2485: SELECT partner_id,program_id,enrollment_type_code,tentative_start_date,tentative_end_date
2486: FROM pv_pg_enrl_requests
2487: WHERE enrl_request_id=p_enrl_req_id;
2488:
2489: l_enrollment_type_code varchar2(30);
2490: l_tentative_start_date DATE:=null;

Line 2550: FROM pv_pg_enrl_requests enrq

2546: WHERE appr_for_entity_id=p_enrl_req_id;
2547:
2548: CURSOR enr_requests_dtl_cur (p_enrl_req_id number) IS
2549: SELECT enrq.object_version_number,enrollment_type_code,order_header_id,partner_id,program_name, enrq.program_id
2550: FROM pv_pg_enrl_requests enrq
2551: , pv_partner_program_vl prgm
2552: WHERE enrq.enrl_request_id=p_enrl_req_id
2553: AND enrq.program_id=prgm.program_id;
2554:

Line 2629: l_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;

2625:
2626: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
2627: pv_pg_prev_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
2628: l_approver_rec Pv_Ge_Temp_Approvers_PVT.APPROVER_REC_TYPE;
2629: l_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
2630: l_mmbr_tran_rec pv_pg_mmbr_transitions_PVT.mmbr_tran_rec_type;
2631: l_api_name CONSTANT VARCHAR2(30) := 'process_approved_requests';
2632: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2633: l_api_version_number CONSTANT NUMBER := 1.0;

Line 2754: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests(

2750:
2751: l_enrq_rec.tentative_start_date:= pv_pg_memb_rec.start_date;
2752: l_enrq_rec.tentative_end_date:= pv_pg_memb_rec.original_end_date;
2753:
2754: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests(
2755: p_api_version_number => 1.0
2756: ,p_init_msg_list => FND_API.g_false
2757: ,p_commit => FND_API.G_FALSE
2758: ,p_validation_level => FND_API.g_valid_level_full

Line 3053: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests(

3049:
3050: ELSE --end of approved code
3051: --the code below is for enrollments that are rejected by any appprover.
3052: --update the enrollment requests table with the approvalstatus
3053: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests(
3054: p_api_version_number => 1.0
3055: ,p_init_msg_list => FND_API.g_false
3056: ,p_commit => FND_API.G_FALSE
3057: ,p_validation_level => FND_API.g_valid_level_full

Line 3238: FROM pv_pg_enrl_requests

3234: AND res.user_id=fnd.user_id;
3235:
3236: CURSOR c_enrl_cur ( enrl_id NUMBER ) IS
3237: SELECT partner_id
3238: FROM pv_pg_enrl_requests
3239: WHERE enrl_request_id=enrl_id;
3240:
3241: CURSOR pending_appovers_csr ( enrl_id NUMBER ) IS
3242: SELECT entity_approver_id,object_version_number

Line 4080: l_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;

4076: l_api_version_number CONSTANT NUMBER := 1.0;
4077: l_checkrow_pending boolean:=false;
4078: l_approver_rec Pv_Ge_Temp_Approvers_PVT.approver_rec_type;
4079: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
4080: l_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
4081: l_membership_id number;
4082: l_approvalStatus varchar2(50);
4083: l_approverPersonId number;
4084: l_approverUserId number;

Line 4110: FROM pv_pg_enrl_requests

4106: AND ARC_APPR_FOR_ENTITY_CODE='ENRQ';
4107:
4108: CURSOR enrq_dtl_cur (p_enrl_req_id number) IS
4109: SELECT object_version_number, partner_id
4110: FROM pv_pg_enrl_requests
4111: WHERE enrl_request_id=p_enrl_req_id;
4112:
4113: CURSOR c_resource_per_cur(p_appr_id NUMBER) IS
4114: SELECT res.resource_id,res.resource_name

Line 4205: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests

4201: l_enrq_rec.enrl_request_id:=enrl_request_id;
4202: l_enrq_rec.tentative_start_date:=start_date;
4203: l_enrq_rec.tentative_end_date:=end_date;
4204:
4205: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests
4206: ( p_api_version_number => 1.0
4207: , p_init_msg_list => FND_API.g_false
4208: , p_commit => FND_API.G_FALSE
4209: , p_validation_level => FND_API.g_valid_level_full

Line 4650: l_pv_pg_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;

4646: ,x_msg_data OUT NOCOPY VARCHAR2) IS
4647:
4648: l_pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
4649: l_pv_pg_new_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
4650: l_pv_pg_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
4651: l_mmbr_tran_rec pv_pg_mmbr_transitions_PVT.mmbr_tran_rec_type;
4652: l_partner_id NUMBER;
4653: l_enrl_request_id NUMBER;
4654: l_membership_id NUMBER;

Line 4667: FROM pv_pg_memberships memb,pv_pg_enrl_requests enrq

4663: l_custom_setup_id NUMBER;
4664:
4665: CURSOR membership_csr(p_memb_id NUMBER) IS
4666: SELECT memb.object_version_number,memb.partner_id,memb.original_end_date,enrq.custom_setup_id
4667: FROM pv_pg_memberships memb,pv_pg_enrl_requests enrq
4668: WHERE memb.membership_id=p_memb_id
4669: AND memb.enrl_request_id=enrq.enrl_request_id;
4670:
4671: CURSOR program_name_csr(p_prgm_id NUMBER) IS

Line 4783: PV_Pg_Enrl_Requests_PVT.Create_Pg_Enrl_Requests

4779: l_pv_pg_enrq_rec.request_initiated_by_code:='VENDOR';
4780: l_pv_pg_enrq_rec.contract_status_code:='NOT_SIGNED';
4781: l_pv_pg_enrq_rec.custom_setup_id:=getCustomSetupID(p_program_id_downgraded_to);
4782:
4783: PV_Pg_Enrl_Requests_PVT.Create_Pg_Enrl_Requests
4784: ( p_api_version_number =>1.0
4785: ,p_init_msg_list => FND_API.g_false
4786: ,p_commit => FND_API.G_FALSE
4787: ,p_validation_level => FND_API.g_valid_level_full

Line 4984: l_pv_pg_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;

4980: ,x_msg_data OUT NOCOPY VARCHAR2
4981: ) IS
4982:
4983: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
4984: l_pv_pg_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
4985: l_api_name CONSTANT VARCHAR2(30) := 'Create_Default_Membership';
4986: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
4987: l_api_version_number CONSTANT NUMBER := 1.0;
4988: l_membership_id NUMBER;

Line 5063: PV_Pg_Enrl_Requests_PVT.Create_Pg_Enrl_Requests

5059: l_pv_pg_enrq_rec.contract_status_code:='NOT_SIGNED';
5060: l_pv_pg_enrq_rec.payment_status_code:='NOT_SUBMITTED';
5061: l_pv_pg_enrq_rec.custom_setup_id:= getCustomSetupID(l_default_program_id);
5062:
5063: PV_Pg_Enrl_Requests_PVT.Create_Pg_Enrl_Requests
5064: ( p_api_version_number =>1.0
5065: ,p_init_msg_list => FND_API.g_false
5066: ,p_commit => FND_API.G_FALSE
5067: ,p_validation_level => FND_API.g_valid_level_full

Line 5268: , pv_pg_enrl_requests enrq

5264: l_lookup_exists VARCHAR2(1);
5265: CURSOR c_vad_csr(enrl_id IN NUMBER ) IS
5266: SELECT invite.invited_by_partner_id
5267: FROM pv_pg_invite_headers_b invite
5268: , pv_pg_enrl_requests enrq
5269: WHERE enrq.enrl_request_id=enrl_id
5270: AND enrq.invite_header_id=invite.invite_header_id;
5271:
5272: CURSOR c_memb_type_csr(ptr_id NUMBER) IS