APPS.INV_PROJECT dependencies on PJM_PROJECTS_ALL_V

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

84: to_task_number := NULL;
85: pa_expenditure_org := NULL;
86:
87: -- bug 4662395 set the profile mfg_organization_id so
88: -- the call to PJM_PROJECTS_ALL_V will return data.
89: l_cur_mfg_org_id := TO_NUMBER(FND_PROFILE.VALUE('MFG_ORGANIZATION_ID'));
90:
91: IF ( (pa_expenditure_org_id IS NOT NULL) AND
92: ( (l_cur_mfg_org_id IS NULL) OR

Line 111: FROM pjm_projects_all_v m

107: WHERE m.project_id = source_project_id ; */
108:
109: SELECT m.project_number
110: INTO source_project_number
111: FROM pjm_projects_all_v m
112: WHERE m.project_id = source_project_id ;
113:
114:
115: EXCEPTION

Line 134: FROM pjm_projects_all_v my

130: WHERE my.project_id = p_project_id ; */
131:
132: SELECT my.project_number
133: INTO p_project_number
134: FROM pjm_projects_all_v my
135: WHERE my.project_id = p_project_id ;
136:
137: success := TRUE ;
138: EXCEPTION

Line 157: FROM pjm_projects_all_v m

153: WHERE m.project_id = to_project_id ; */
154:
155: SELECT m.project_number
156: INTO to_project_number
157: FROM pjm_projects_all_v m
158: WHERE m.project_id = to_project_id ;
159: EXCEPTION
160: WHEN NO_DATA_FOUND then
161: to_project_number := NULL;

Line 2013: -- no value will return from PJM_PROJECTS_ALL_V

2009: -- 4662395 For this function
2010: -- the calling object will be required
2011: -- to set the profile mfg_organization_id.
2012: -- If this profile remains unset then
2013: -- no value will return from PJM_PROJECTS_ALL_V
2014:
2015: if (l_col_index = g_project_index) then
2016: l_project_id := to_number(l_buf);
2017: BEGIN

Line 2020: FROM pjm_projects_all_v m

2016: l_project_id := to_number(l_buf);
2017: BEGIN
2018: SELECT m.project_number
2019: INTO l_pt_buf
2020: FROM pjm_projects_all_v m
2021: WHERE m.project_id = l_project_id
2022: AND ROWNUM = 1;
2023: EXCEPTION
2024: WHEN OTHERS THEN l_pt_buf := '';