APPS.OE_OE_FORM_LINE dependencies on PJM_PROJECT

Line 3519: from pjm_projects_org_v

3515: IF p_line_rec.project_id is not Null then
3516: BEGIN
3517: /* Select project_number
3518: into x_line_val_rec.project_number
3519: from pjm_projects_org_v
3520: Where project_id=p_line_rec.project_id;*/
3521:
3522: x_line_val_rec.project_number := pjm_project.all_proj_idtonum(p_line_rec.project_id);
3523: EXCEPTION

Line 3522: x_line_val_rec.project_number := pjm_project.all_proj_idtonum(p_line_rec.project_id);

3518: into x_line_val_rec.project_number
3519: from pjm_projects_org_v
3520: Where project_id=p_line_rec.project_id;*/
3521:
3522: x_line_val_rec.project_number := pjm_project.all_proj_idtonum(p_line_rec.project_id);
3523: EXCEPTION
3524: When no_data_found then
3525: Null;
3526: When too_many_rows then

Line 3537: x_line_val_rec.task_number := pjm_project.all_task_idtonum(p_line_rec.task_id);

3533: Into x_line_val_rec.task_number
3534: From pjm_tasks_v
3535: Where task_id=p_line_rec.task_id;*/
3536:
3537: x_line_val_rec.task_number := pjm_project.all_task_idtonum(p_line_rec.task_id);
3538: END IF;
3539: --retro{Previously commented by VMALAPAT. Removed the comment for retrobilling
3540: --This query fires only once per order
3541: IF(g_header_id is NULL or p_line_rec.header_id <> g_header_id) THEN