APPS.PA_CLIENT_EXTN_PROJECT_WF dependencies on PA_PROJECT_STATUSES

Line 215: FROM pa_project_statuses

211: IS
212: SELECT project_status_name
213: , wf_success_status_code
214: , wf_failure_status_code
215: FROM pa_project_statuses
216: WHERE project_status_code = l_project_status_code;
217:
218: -- Get Success Status Name
219: CURSOR l_wf_success_status_name_csr(l_wf_success_status_code VARCHAR2)

Line 222: FROM pa_project_statuses

218: -- Get Success Status Name
219: CURSOR l_wf_success_status_name_csr(l_wf_success_status_code VARCHAR2)
220: IS
221: SELECT project_status_name
222: FROM pa_project_statuses
223: WHERE project_status_code = l_wf_success_status_code;
224:
225: -- Get Failure Status Name
226: CURSOR l_wf_failure_status_name_csr(l_wf_failure_status_code VARCHAR2)

Line 229: FROM pa_project_statuses

225: -- Get Failure Status Name
226: CURSOR l_wf_failure_status_name_csr(l_wf_failure_status_code VARCHAR2)
227: IS
228: SELECT project_status_name
229: FROM pa_project_statuses
230: WHERE project_status_code = l_wf_failure_status_code;
231: -- -------------------------------------------------------------------------------------
232:
233: -- Get System Date for Worflow-Started-Date

Line 274: l_project_status_code pa_project_statuses.project_status_code%TYPE;

270: /* l_carrying_out_org_name varchar2(60); */
271: l_carrying_out_org_name hr_organization_units.name%TYPE;
272: l_project_type_class_code varchar2(30);
273:
274: l_project_status_code pa_project_statuses.project_status_code%TYPE;
275: l_wf_success_status_code pa_project_statuses.project_status_code%TYPE;
276: l_wf_failure_status_code pa_project_statuses.project_status_code%TYPE;
277:
278: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 275: l_wf_success_status_code pa_project_statuses.project_status_code%TYPE;

271: l_carrying_out_org_name hr_organization_units.name%TYPE;
272: l_project_type_class_code varchar2(30);
273:
274: l_project_status_code pa_project_statuses.project_status_code%TYPE;
275: l_wf_success_status_code pa_project_statuses.project_status_code%TYPE;
276: l_wf_failure_status_code pa_project_statuses.project_status_code%TYPE;
277:
278: l_project_status_name pa_project_statuses.project_status_name%TYPE;
279: l_wf_success_status_name pa_project_statuses.project_status_name%TYPE;

Line 276: l_wf_failure_status_code pa_project_statuses.project_status_code%TYPE;

272: l_project_type_class_code varchar2(30);
273:
274: l_project_status_code pa_project_statuses.project_status_code%TYPE;
275: l_wf_success_status_code pa_project_statuses.project_status_code%TYPE;
276: l_wf_failure_status_code pa_project_statuses.project_status_code%TYPE;
277:
278: l_project_status_name pa_project_statuses.project_status_name%TYPE;
279: l_wf_success_status_name pa_project_statuses.project_status_name%TYPE;
280: l_wf_failure_status_name pa_project_statuses.project_status_name%TYPE;

Line 278: l_project_status_name pa_project_statuses.project_status_name%TYPE;

274: l_project_status_code pa_project_statuses.project_status_code%TYPE;
275: l_wf_success_status_code pa_project_statuses.project_status_code%TYPE;
276: l_wf_failure_status_code pa_project_statuses.project_status_code%TYPE;
277:
278: l_project_status_name pa_project_statuses.project_status_name%TYPE;
279: l_wf_success_status_name pa_project_statuses.project_status_name%TYPE;
280: l_wf_failure_status_name pa_project_statuses.project_status_name%TYPE;
281:
282: l_wf_started_date DATE;

Line 279: l_wf_success_status_name pa_project_statuses.project_status_name%TYPE;

275: l_wf_success_status_code pa_project_statuses.project_status_code%TYPE;
276: l_wf_failure_status_code pa_project_statuses.project_status_code%TYPE;
277:
278: l_project_status_name pa_project_statuses.project_status_name%TYPE;
279: l_wf_success_status_name pa_project_statuses.project_status_name%TYPE;
280: l_wf_failure_status_name pa_project_statuses.project_status_name%TYPE;
281:
282: l_wf_started_date DATE;
283:

Line 280: l_wf_failure_status_name pa_project_statuses.project_status_name%TYPE;

276: l_wf_failure_status_code pa_project_statuses.project_status_code%TYPE;
277:
278: l_project_status_name pa_project_statuses.project_status_name%TYPE;
279: l_wf_success_status_name pa_project_statuses.project_status_name%TYPE;
280: l_wf_failure_status_name pa_project_statuses.project_status_name%TYPE;
281:
282: l_wf_started_date DATE;
283:
284: