3422: IF p_line_rec.project_id is not Null then
3423: BEGIN
3424: /* Select project_number
3425: into x_line_val_rec.project_number
3426: from pjm_projects_org_v
3427: Where project_id=p_line_rec.project_id;*/
3428:
3429: x_line_val_rec.project_number := pjm_project.all_proj_idtonum(p_line_rec.project_id);
3430: EXCEPTION
3425: into x_line_val_rec.project_number
3426: from pjm_projects_org_v
3427: Where project_id=p_line_rec.project_id;*/
3428:
3429: x_line_val_rec.project_number := pjm_project.all_proj_idtonum(p_line_rec.project_id);
3430: EXCEPTION
3431: When no_data_found then
3432: Null;
3433: When too_many_rows then
3440: Into x_line_val_rec.task_number
3441: From pjm_tasks_v
3442: Where task_id=p_line_rec.task_id;*/
3443:
3444: x_line_val_rec.task_number := pjm_project.all_task_idtonum(p_line_rec.task_id);
3445: END IF;
3446: --retro{Previously commented by VMALAPAT. Removed the comment for retrobilling
3447: --This query fires only once per order
3448: IF(g_header_id is NULL or p_line_rec.header_id <> g_header_id) THEN