568: into l_project_status_code
569: from pa_projects_all
570: where project_id = c_prvdr_prj_rec.project_id;
571:
572: if pa_project_stus_utils.is_project_in_purge_status( l_project_status_code ) <> 'Y' then
573:
574: /* A provider to the given receiver project can again be a receiver project. So, checking
575: for existance of any provider projects if it is a receiver project by calling the
576: procedure Validate_IP_Rcvr recursively */
581: x_err_code,
582: x_err_stack,
583: x_err_stage );
584:
585: if pa_project_stus_utils.is_project_in_purge_status( l_project_status_code ) <> 'Y'
586: then
587:
588: if g_insert_errors_no_duplicate = 'N' then /* Bug#2431705 */
589:
604: end if;
605:
606: else
607:
608: if pa_project_stus_utils.is_project_in_purge_status( l_project_status_code ) <> 'Y'
609: then
610:
611: if g_insert_errors_no_duplicate = 'N' then /* Bug# 2431705 */
612: