APPS.PV_PRGM_APPROVAL_PVT dependencies on PV_PARTNER_PROGRAM_B

Line 189: from pv_partner_program_b

185: ,'MONTH',add_months(start_date,membership_valid_period)
186: ,'YEAR',add_months(start_date,12*membership_valid_period)
187: ,null
188: ) membership_end_date
189: from pv_partner_program_b
190: where program_id=p_prgm_id;
191:
192:
193: BEGIN

Line 466: FROM pv_partner_program_b

462: FUNCTION ispayment_exists(p_program_id IN number) RETURN boolean IS
463: no_fee varchar2(1);
464: CURSOR rec_cur(p_prgm_id number) IS
465: SELECT no_fee_flag
466: FROM pv_partner_program_b
467: WHERE program_id = p_prgm_id;
468:
469:
470: BEGIN

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 767: select PROGRAM_STATUS_CODE from pv_partner_program_b where program_id=p_parent_prgm_id and ENABLED_FLAG='Y';

763:
764: l_parent_program_status varchar2(30);
765: isApproved boolean:=false ;
766: cursor parentprogramstatus_cur(p_parent_prgm_id number) is
767: select PROGRAM_STATUS_CODE from pv_partner_program_b where program_id=p_parent_prgm_id and ENABLED_FLAG='Y';
768: BEGIN
769: OPEN parentprogramstatus_cur(p_parent_program_id);
770: FETCH parentprogramstatus_cur into l_parent_program_status;
771: if parentprogramstatus_cur%found THEN

Line 1814: FROM ibc_citem_versions_b cont_ver, ibc_content_items cont,pv_partner_program_b prog

1810: l_program_id NUMBER;
1811:
1812: CURSOR citem_csr(prgm_id NUMBER) IS
1813: SELECT cont.object_version_number object_version_number , prog.citem_version_id citem_version_id
1814: FROM ibc_citem_versions_b cont_ver, ibc_content_items cont,pv_partner_program_b prog
1815: WHERE prog.program_id = prgm_id
1816: AND prog.citem_version_id = cont_ver.citem_version_id
1817: AND cont_ver.content_item_id = cont.content_item_id;
1818:

Line 1824: FROM PV_PARTNER_PROGRAM_B

1820: l_citem_version_id NUMBER;
1821:
1822: CURSOR c_get_partner_program(cv_program_id NUMBER) IS
1823: SELECT *
1824: FROM PV_PARTNER_PROGRAM_B
1825: WHERE PROGRAM_PARENT_ID = cv_program_id
1826: AND ENABLED_FLAG='Y'
1827: AND SUBMIT_CHILD_NODES='Y'
1828: AND PROGRAM_STATUS_CODE='NEW';

Line 1839: FROM pv_partner_program_b

1835: and SYSTEM_STATUS_CODE=cv_status_code;
1836:
1837: CURSOR c_get_objverno(cv_program_id NUMBER) IS
1838: SELECT object_version_number
1839: FROM pv_partner_program_b
1840: WHERE program_id=cv_program_id;
1841:
1842: CURSOR c_get_status_child(cv_program_id NUMBER) IS
1843: SELECT program_status_code,object_version_number

Line 1844: FROM pv_partner_program_b

1840: WHERE program_id=cv_program_id;
1841:
1842: CURSOR c_get_status_child(cv_program_id NUMBER) IS
1843: SELECT program_status_code,object_version_number
1844: FROM pv_partner_program_b
1845: WHERE program_id=cv_program_id;
1846:
1847: l_user_status_for_new NUMBER;
1848: l_user_status_for_approved NUMBER;

Line 2009: update pv_partner_program_b set PROGRAM_STATUS_CODE='PENDING_APPROVAL',

2005: --the child program could automatically go to approved if owner and approver is same
2006:
2007: IF l_child_prog_stat_code <>'APPROVED' THEN
2008:
2009: update pv_partner_program_b set PROGRAM_STATUS_CODE='PENDING_APPROVAL',
2010: USER_STATUS_ID=l_user_status_for_pa,
2011: object_version_number=l_object_version_number+1
2012: where
2013: program_id=child_cur.program_id;

Line 2572: FROM pv_partner_program_b

2568: FROM pv_ge_qsnr_elements_b
2569: WHERE arc_used_by_entity_code='PRGM'
2570: AND used_by_entity_id in
2571: ( SELECT program_id
2572: FROM pv_partner_program_b
2573: START WITH program_id =p_program_id
2574: CONNECT BY program_id = prior program_parent_id
2575: )
2576: );

Line 2586: FROM pv_partner_program_b

2582: WHERE arc_used_by_entity_code='PRGM'
2583: AND attr.ENTITY_ATTR_ID=qsnr.entity_attr_id
2584: AND used_by_entity_id in
2585: ( SELECT program_id
2586: FROM pv_partner_program_b
2587: START WITH program_id =p_program_id
2588: CONNECT BY program_id = prior program_parent_id
2589: )
2590: );

Line 2600: FROM pv_partner_program_b

2596: WHERE arc_used_by_entity_code='PRGM'
2597: AND attr.ENTITY_ATTR_ID=qsnr.entity_attr_id
2598: AND used_by_entity_id in
2599: ( SELECT program_id
2600: FROM pv_partner_program_b
2601: START WITH program_id =p_program_id
2602: CONNECT BY program_id = prior program_parent_id
2603: );
2604:

Line 2613: FROM pv_partner_program_b

2609: FROM pv_ge_qsnr_elements_b
2610: WHERE arc_used_by_entity_code='PRGM'
2611: AND used_by_entity_id in
2612: ( SELECT program_id
2613: FROM pv_partner_program_b
2614: START WITH program_id =p_program_id
2615: CONNECT BY program_id = prior program_parent_id
2616: );
2617: */