APPS.INV_PROJECT dependencies on PJM_PROJECTS_ALL_V

Line 93: -- the call to PJM_PROJECTS_ALL_V will return data.

89: to_task_number := NULL;
90: pa_expenditure_org := NULL;
91:
92: -- bug 4662395 set the profile mfg_organization_id so
93: -- the call to PJM_PROJECTS_ALL_V will return data.
94: l_cur_mfg_org_id := TO_NUMBER(FND_PROFILE.VALUE('MFG_ORGANIZATION_ID'));
95:
96: IF ( (pa_expenditure_org_id IS NOT NULL) AND
97: ( (l_cur_mfg_org_id IS NULL) OR

Line 116: FROM pjm_projects_all_v m

112: WHERE m.project_id = source_project_id ; */
113:
114: SELECT m.project_number
115: INTO source_project_number
116: FROM pjm_projects_all_v m
117: WHERE m.project_id = source_project_id ;
118:
119:
120: EXCEPTION

Line 139: FROM pjm_projects_all_v my

135: WHERE my.project_id = p_project_id ; */
136:
137: SELECT my.project_number
138: INTO p_project_number
139: FROM pjm_projects_all_v my
140: WHERE my.project_id = p_project_id ;
141:
142: success := TRUE ;
143: EXCEPTION

Line 162: FROM pjm_projects_all_v m

158: WHERE m.project_id = to_project_id ; */
159:
160: SELECT m.project_number
161: INTO to_project_number
162: FROM pjm_projects_all_v m
163: WHERE m.project_id = to_project_id ;
164: EXCEPTION
165: WHEN NO_DATA_FOUND then
166: to_project_number := NULL;

Line 2043: -- no value will return from PJM_PROJECTS_ALL_V

2039: -- 4662395 For this function
2040: -- the calling object will be required
2041: -- to set the profile mfg_organization_id.
2042: -- If this profile remains unset then
2043: -- no value will return from PJM_PROJECTS_ALL_V
2044:
2045: if (l_col_index = g_project_index) then
2046: l_project_id := to_number(l_buf);
2047: BEGIN

Line 2050: FROM pjm_projects_all_v m

2046: l_project_id := to_number(l_buf);
2047: BEGIN
2048: SELECT m.project_number
2049: INTO l_pt_buf
2050: FROM pjm_projects_all_v m
2051: WHERE m.project_id = l_project_id
2052: AND ROWNUM = 1;
2053: EXCEPTION
2054: WHEN OTHERS THEN l_pt_buf := '';