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.1 2005/08/19 17:05:47 mwasowic noship $ */
3:
4: PROCEDURE Insert_Row(
5: X_ROW_ID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 76: INSERT INTO pa_proj_elements(

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

Line 268: FROM pa_proj_elements

264: ) IS
265: CURSOR cur_proj_elems
266: IS
267: SELECT *
268: FROM pa_proj_elements
269: WHERE proj_element_id = X_PROJ_ELEMENT_ID;
270: v_cur_proj_elems_rec cur_proj_elems%ROWTYPE;
271:
272: BEGIN

Line 283: UPDATE pa_proj_elements

279: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
280: APP_EXCEPTION.Raise_Exception;
281: end if; moved to private API */
282:
283: UPDATE pa_proj_elements
284: SET PROJ_ELEMENT_ID = X_PROJ_ELEMENT_ID
285: ,PROJECT_ID = X_PROJECT_ID
286: ,OBJECT_TYPE = X_OBJECT_TYPE
287: ,ELEMENT_NUMBER = X_ELEMENT_NUMBER

Line 348: DELETE FROM pa_proj_elements

344: PROCEDURE Delete_Row(
345: X_ROW_ID IN VARCHAR2
346: ) IS
347: BEGIN
348: DELETE FROM pa_proj_elements
349: WHERE rowid = x_row_id;
350: END delete_row;
351:
352: END PA_PROJ_ELEMENTS_PKG;

Line 352: END PA_PROJ_ELEMENTS_PKG;

348: DELETE FROM pa_proj_elements
349: WHERE rowid = x_row_id;
350: END delete_row;
351:
352: END PA_PROJ_ELEMENTS_PKG;