APPS.POR_UTIL_PKG dependencies on PA_PROJECTS_ALL

Line 4518: x_pjt_name PA_PROJECTS_ALL.NAME%TYPE default 'NA';

4514: p_po_dist_id IN NUMBER)
4515: RETURN VARCHAR2 IS
4516:
4517: x_progress VARCHAR2(3);
4518: x_pjt_name PA_PROJECTS_ALL.NAME%TYPE default 'NA';
4519: x_pjt_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
4520: l_api_name CONSTANT VARCHAR2(100) := 'get_po_dist_project';
4521:
4522: BEGIN

Line 4519: x_pjt_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;

4515: RETURN VARCHAR2 IS
4516:
4517: x_progress VARCHAR2(3);
4518: x_pjt_name PA_PROJECTS_ALL.NAME%TYPE default 'NA';
4519: x_pjt_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
4520: l_api_name CONSTANT VARCHAR2(100) := 'get_po_dist_project';
4521:
4522: BEGIN
4523:

Line 4531: SELECT NAME INTO x_pjt_name FROM PA_PROJECTS_ALL WHERE project_id = x_pjt_id;

4527: SELECT PROJECT_ID INTO x_pjt_id FROM po_distributions_all WHERE PO_DISTRIBUTION_ID = p_po_dist_id;
4528:
4529: if (x_pjt_id IS NOT NULL) THEN
4530: BEGIN
4531: SELECT NAME INTO x_pjt_name FROM PA_PROJECTS_ALL WHERE project_id = x_pjt_id;
4532: EXCEPTION
4533: WHEN No_Data_Found THEN
4534: x_progress := '001';
4535: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 4643: x_cur_pjt_name PA_PROJECTS_ALL.NAME%TYPE;

4639: p_req_line_id IN NUMBER)
4640: RETURN VARCHAR2 IS
4641:
4642: x_progress VARCHAR2(3);
4643: x_cur_pjt_name PA_PROJECTS_ALL.NAME%TYPE;
4644: x_cur_pjt_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
4645: x_invalid_pjts VARCHAR2(4000);
4646: x_valid_pjt_cnt NUMBER;
4647: l_api_name CONSTANT VARCHAR2(100) := 'get_req_line_invalid_pjts';

Line 4644: x_cur_pjt_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;

4640: RETURN VARCHAR2 IS
4641:
4642: x_progress VARCHAR2(3);
4643: x_cur_pjt_name PA_PROJECTS_ALL.NAME%TYPE;
4644: x_cur_pjt_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
4645: x_invalid_pjts VARCHAR2(4000);
4646: x_valid_pjt_cnt NUMBER;
4647: l_api_name CONSTANT VARCHAR2(100) := 'get_req_line_invalid_pjts';
4648:

Line 4674: SELECT NAME INTO x_cur_pjt_name FROM PA_PROJECTS_ALL WHERE project_id = x_cur_pjt_id;

4670: SELECT project_id
4671: FROM pjm_seiban_numbers
4672: WHERE project_id =x_cur_pjt_id);
4673: IF(x_valid_pjt_cnt=0) THEN
4674: SELECT NAME INTO x_cur_pjt_name FROM PA_PROJECTS_ALL WHERE project_id = x_cur_pjt_id;
4675: IF(x_invalid_pjts Is NULL) THEN
4676: x_invalid_pjts := x_cur_pjt_name;
4677: ELSE
4678: x_invalid_pjts :=x_invalid_pjts||',' || x_cur_pjt_name;