DBA Data[Home] [Help]

APPS.RCV_TRANSACTION_SV dependencies on PJM_SEIBAN_NUMBERS

Line 109: IF x_project_id is not null AND x_project_number is null THEN --if x_project_number is still null then it could be in PJM_SEIBAN_NUMBERS

105: END;
106: END IF;
107:
108: x_progress := 23;
109: IF x_project_id is not null AND x_project_number is null THEN --if x_project_number is still null then it could be in PJM_SEIBAN_NUMBERS
110: BEGIN
111: x_progress := 25;
112: select PSN.PROJECT_NUMBER ,
113: NULL

Line 116: from PJM_SEIBAN_NUMBERS PSN

112: select PSN.PROJECT_NUMBER ,
113: NULL
114: into x_project_number,
115: x_task_number
116: from PJM_SEIBAN_NUMBERS PSN
117: where PSN.project_id = x_project_id;
118: EXCEPTION
119: WHEN NO_DATA_FOUND THEN
120: x_project_number := NULL;