APPS.PA_PROJ_ELEMENTS_PKG dependencies on PA_PROJ_ELEMENTS

Line 1: PACKAGE BODY PA_PROJ_ELEMENTS_PKG AS

1: PACKAGE BODY PA_PROJ_ELEMENTS_PKG AS
2: /* $Header: PATSKT1B.pls 120.4.12020000.2 2012/07/19 10:00:47 admarath ship $ */
3:
4: PROCEDURE Insert_Row(
5: X_ROW_ID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 77: INSERT INTO pa_proj_elements(

73: OPEN cur_tasks_seq;
74: FETCH cur_tasks_seq INTO X_PROJ_ELEMENT_ID;
75: CLOSE cur_tasks_seq;
76: END IF;
77: INSERT INTO pa_proj_elements(
78: PROJ_ELEMENT_ID
79: ,PROJECT_ID
80: ,OBJECT_TYPE
81: ,ELEMENT_NUMBER

Line 271: FROM pa_proj_elements

267: ) IS
268: CURSOR cur_proj_elems
269: IS
270: SELECT pm_source_reference,pm_source_code
271: FROM pa_proj_elements
272: WHERE proj_element_id = X_PROJ_ELEMENT_ID;
273: v_cur_proj_elems_rec cur_proj_elems%ROWTYPE;
274: l_pm_task_reference pa_proj_elements.PM_SOURCE_REFERENCE%TYPE;
275: l_pm_source_code pa_proj_elements.PM_SOURCE_CODE%TYPE;

Line 274: l_pm_task_reference pa_proj_elements.PM_SOURCE_REFERENCE%TYPE;

270: SELECT pm_source_reference,pm_source_code
271: FROM pa_proj_elements
272: WHERE proj_element_id = X_PROJ_ELEMENT_ID;
273: v_cur_proj_elems_rec cur_proj_elems%ROWTYPE;
274: l_pm_task_reference pa_proj_elements.PM_SOURCE_REFERENCE%TYPE;
275: l_pm_source_code pa_proj_elements.PM_SOURCE_CODE%TYPE;
276: BEGIN
277: -- Modified the code for bug 13501842
278: OPEN cur_proj_elems;

Line 275: l_pm_source_code pa_proj_elements.PM_SOURCE_CODE%TYPE;

271: FROM pa_proj_elements
272: WHERE proj_element_id = X_PROJ_ELEMENT_ID;
273: v_cur_proj_elems_rec cur_proj_elems%ROWTYPE;
274: l_pm_task_reference pa_proj_elements.PM_SOURCE_REFERENCE%TYPE;
275: l_pm_source_code pa_proj_elements.PM_SOURCE_CODE%TYPE;
276: BEGIN
277: -- Modified the code for bug 13501842
278: OPEN cur_proj_elems;
279: FETCH cur_proj_elems INTO v_cur_proj_elems_rec;

Line 304: UPDATE pa_proj_elements

300: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
301: APP_EXCEPTION.Raise_Exception;
302: end if; moved to private API */
303:
304: UPDATE pa_proj_elements
305: SET PROJ_ELEMENT_ID = X_PROJ_ELEMENT_ID
306: ,PROJECT_ID = X_PROJECT_ID
307: ,OBJECT_TYPE = X_OBJECT_TYPE
308: ,ELEMENT_NUMBER = X_ELEMENT_NUMBER

Line 369: DELETE FROM pa_proj_elements

365: PROCEDURE Delete_Row(
366: X_ROW_ID IN VARCHAR2
367: ) IS
368: BEGIN
369: DELETE FROM pa_proj_elements
370: WHERE rowid = x_row_id;
371: END delete_row;
372:
373: END PA_PROJ_ELEMENTS_PKG;

Line 373: END PA_PROJ_ELEMENTS_PKG;

369: DELETE FROM pa_proj_elements
370: WHERE rowid = x_row_id;
371: END delete_row;
372:
373: END PA_PROJ_ELEMENTS_PKG;