DBA Data[Home] [Help]

APPS.RCV_TRANSACTION_SV dependencies on PJM_SEIBAN_NUMBERS

Line 121: 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

117: End;
118: END IF;
119:
120: x_progress := 23;
121: 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
122: BEGIN
123: x_progress := 25;
124: select PSN.PROJECT_NUMBER ,
125: NULL

Line 128: from PJM_SEIBAN_NUMBERS PSN

124: select PSN.PROJECT_NUMBER ,
125: NULL
126: into x_project_number,
127: x_task_number
128: from PJM_SEIBAN_NUMBERS PSN
129: where PSN.project_id = x_project_id;
130: EXCEPTION
131: WHEN NO_DATA_FOUND THEN
132: x_project_number := NULL;