DBA Data[Home] [Help]

APPS.PV_PARTNER_PROGRAM_PVT dependencies on PV_PARTNER_PROGRAM_B_S

Line 1022: SELECT PV_PARTNER_PROGRAM_B_S.NEXTVAL

1018: l_isNoEnrlDateInRange boolean:=true;
1019: l_currency VARCHAR2(60);
1020: -- Cursor to get the sequence for pv_partner_program_b
1021: CURSOR c_partner_program_id_seq IS
1022: SELECT PV_PARTNER_PROGRAM_B_S.NEXTVAL
1023: FROM dual;
1024:
1025: -- Cursor to validate the uniqueness
1026: CURSOR c_partner_program_id_exists(l_id IN NUMBER) IS

Line 2113: update pv_partner_program_b set submit_child_nodes='Y',object_version_number=c_rec.object_version_number+1 where program_id=c_rec.program_id;

2109: IF l_tar_ptr_prgm_rec.program_status_code='PENDING_APPROVAL' THEN
2110:
2111: IF l_tar_ptr_prgm_rec.submit_child_nodes='Y' THEN
2112: for c_rec in c_get_child_programs(l_tar_ptr_prgm_rec.program_id) loop
2113: update pv_partner_program_b set submit_child_nodes='Y',object_version_number=c_rec.object_version_number+1 where program_id=c_rec.program_id;
2114: end loop;
2115: END IF;
2116: IF (PV_DEBUG_HIGH_ON) THEN
2117: