[Home] [Help]
834:
835:
836: CURSOR c_program_rec (p_program_id IN NUMBER) IS
837: SELECT PROGRAM_NAME,MEANING,PROGRAM_START_DATE,PROGRAM_END_DATE,SOURCE_NAME,PROGRAM_DESCRIPTION,SOURCE_BUSINESS_GRP_NAME
838: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL
839: WHERE PROGRAM_ID =p_program_id
840: AND PROGRAM_OWNER_RESOURCE_ID =RESOURCE_ID
841: AND LOOKUP_CODE=PROGRAM_LEVEL_CODE
842: AND LOOKUP_TYPE='PV_PROGRAM_LEVEL';
979:
980:
981: CURSOR c_program_rec (p_program_id IN NUMBER) IS
982: SELECT PROGRAM_NAME,MEANING,PROGRAM_START_DATE,PROGRAM_END_DATE,SOURCE_NAME,PROGRAM_DESCRIPTION,SOURCE_BUSINESS_GRP_NAME
983: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL
984: WHERE PROGRAM_ID =p_program_id
985: AND PROGRAM_OWNER_RESOURCE_ID =RESOURCE_ID
986: AND LOOKUP_CODE=PROGRAM_LEVEL_CODE
987: AND LOOKUP_TYPE='PV_PROGRAM_LEVEL';
1136:
1137:
1138: CURSOR c_program_rec (p_program_id IN NUMBER) IS
1139: SELECT PROGRAM_NAME,MEANING,PROGRAM_START_DATE,PROGRAM_END_DATE,SOURCE_NAME,PROGRAM_DESCRIPTION,SOURCE_BUSINESS_GRP_NAME
1140: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL
1141: WHERE PROGRAM_ID =p_program_id
1142: AND PROGRAM_OWNER_RESOURCE_ID =RESOURCE_ID
1143: AND LOOKUP_CODE=PROGRAM_LEVEL_CODE
1144: AND LOOKUP_TYPE='PV_PROGRAM_LEVEL';
1293: l_url2 VARCHAR2 (360);
1294:
1295: CURSOR c_program_rec (p_program_id IN NUMBER) IS
1296: SELECT PROGRAM_NAME,MEANING,PROGRAM_START_DATE,PROGRAM_END_DATE,SOURCE_NAME,PROGRAM_DESCRIPTION,SOURCE_BUSINESS_GRP_NAME
1297: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL
1298: WHERE PROGRAM_ID =p_program_id
1299: AND PROGRAM_OWNER_RESOURCE_ID =RESOURCE_ID
1300: AND LOOKUP_CODE=PROGRAM_LEVEL_CODE
1301: AND LOOKUP_TYPE='PV_PROGRAM_LEVEL';
1442: l_url2 VARCHAR2 (360);
1443:
1444: CURSOR c_program_rec (p_program_id IN NUMBER) IS
1445: SELECT PROGRAM_NAME,MEANING,PROGRAM_START_DATE,PROGRAM_END_DATE,SOURCE_NAME,PROGRAM_DESCRIPTION,SOURCE_BUSINESS_GRP_NAME
1446: FROM PV_PARTNER_PROGRAM_VL ,JTF_RS_RESOURCE_EXTNS,FND_LOOKUP_VALUES_VL
1447: WHERE PROGRAM_ID =p_program_id
1448: AND PROGRAM_OWNER_RESOURCE_ID =RESOURCE_ID
1449: AND LOOKUP_CODE=PROGRAM_LEVEL_CODE
1450: AND LOOKUP_TYPE='PV_PROGRAM_LEVEL';
1590: l_string VARCHAR2 (3000);
1591:
1592: --the cursor below picks up the program type id based on the program id.
1593: CURSOR c_program_type_rec (p_program_id IN NUMBER) IS
1594: SELECT ppv.program_name,to_char(ppv.program_type_id) from pv_partner_program_vl ppv, pv_partner_program_type_vl ppt
1595: WHERE ppv.program_id=p_program_id
1596: AND ppv.program_type_id=ppt.program_type_id;
1597:
1598:
2172: CURSOR c_enr_cur (cv_enrl_id IN NUMBER) IS
2173: /**SELECT partner.party_name
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
2187: */
2188: SELECT partner.party_name
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
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:
2555: CURSOR membership_dtl_cur(p_membership_id number) IS
5005: );
5006:
5007: CURSOR c_program_csr( prgm_id IN NUMBER ) IS
5008: SELECT program_name
5009: FROM pv_partner_program_vl
5010: WHERE program_id=prgm_id;
5011:
5012: BEGIN
5013: SAVEPOINT Create_Default_Membership;