APPS.PA_PROJ_ELEMENT_VERSIONS_PKG dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 1: PACKAGE BODY PA_PROJ_ELEMENT_VERSIONS_PKG AS

1: PACKAGE BODY PA_PROJ_ELEMENT_VERSIONS_PKG AS
2: /* $Header: PATSKT2B.pls 120.1 2005/08/19 17:05:57 mwasowic noship $ */
3:
4: PROCEDURE Insert_Row(
5: X_ROW_ID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 38: SELECT pa_proj_element_versions_s.nextval

34: ) IS
35:
36: CURSOR cur_elem_ver_seq
37: IS
38: SELECT pa_proj_element_versions_s.nextval
39: FROM sys.dual;
40:
41: BEGIN
42: IF X_ELEMENT_VERSION_ID IS NULL

Line 48: INSERT INTO pa_proj_element_versions(

44: OPEN cur_elem_ver_seq;
45: FETCH cur_elem_ver_seq INTO X_ELEMENT_VERSION_ID;
46: CLOSE cur_elem_ver_seq;
47: END IF;
48: INSERT INTO pa_proj_element_versions(
49: ELEMENT_VERSION_ID
50: ,PROJ_ELEMENT_ID
51: ,OBJECT_TYPE
52: ,PROJECT_ID

Line 156: FROM pa_proj_element_versions

152: ) IS
153: CURSOR cur_proj_elem_ver
154: IS
155: SELECT *
156: FROM pa_proj_element_versions
157: WHERE element_version_id = X_ELEMENT_VERSION_ID;
158: cur_proj_elem_ver_rec cur_proj_elem_ver%ROWTYPE;
159:
160: BEGIN

Line 171: UPDATE pa_proj_element_versions

167: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
168: APP_EXCEPTION.Raise_Exception;
169: end if; moved to private API */
170:
171: UPDATE pa_proj_element_versions
172: SET ELEMENT_VERSION_ID = X_ELEMENT_VERSION_ID
173: ,PROJ_ELEMENT_ID = X_PROJ_ELEMENT_ID
174: ,OBJECT_TYPE = X_OBJECT_TYPE
175: ,PROJECT_ID = X_PROJECT_ID

Line 209: DELETE FROM pa_proj_element_versions

205: PROCEDURE Delete_Row(
206: X_ROW_ID IN VARCHAR2
207: ) IS
208: BEGIN
209: DELETE FROM pa_proj_element_versions
210: WHERE rowid = x_row_id;
211: END Delete_Row;
212:
213: END PA_PROJ_ELEMENT_VERSIONS_PKG;

Line 213: END PA_PROJ_ELEMENT_VERSIONS_PKG;

209: DELETE FROM pa_proj_element_versions
210: WHERE rowid = x_row_id;
211: END Delete_Row;
212:
213: END PA_PROJ_ELEMENT_VERSIONS_PKG;