APPS.PA_LIFECYCLE_USAGES_PKG dependencies on PA_LIFECYCLE_USAGES

Line 1: PACKAGE BODY PA_LIFECYCLE_USAGES_PKG AS

1: PACKAGE BODY PA_LIFECYCLE_USAGES_PKG AS
2: /* $Header: PALCUPKB.pls 115.1 2002/10/22 21:25:22 mrajput noship $ */
3:
4: /*-----------------------------------------------------------+
5: | For Details/Comments Refer Package Specification Comments |

Line 15: insert into PA_LIFECYCLE_USAGES (

11: X_LIFECYCLE_ID in NUMBER,
12: X_USAGE_TYPE in VARCHAR2
13: ) IS
14: BEGIN
15: insert into PA_LIFECYCLE_USAGES (
16: LAST_UPDATE_LOGIN,
17: RECORD_VERSION_NUMBER,
18: LAST_UPDATE_DATE,
19: LAST_UPDATED_BY,

Line 56: from PA_LIFECYCLE_USAGES

52: RECORD_VERSION_NUMBER,
53: LIFECYCLE_ID,
54: USAGE_TYPE,
55: LIFECYCLE_USAGE_ID
56: from PA_LIFECYCLE_USAGES
57: where LIFECYCLE_USAGE_ID = X_LIFECYCLE_USAGE_ID
58: for update of LIFECYCLE_USAGE_ID nowait;
59: BEGIN
60: for tlinfo in c1 loop

Line 87: update PA_LIFECYCLE_USAGES set

83: X_LIFECYCLE_ID in NUMBER,
84: X_USAGE_TYPE in VARCHAR2
85: ) IS
86: BEGIN
87: update PA_LIFECYCLE_USAGES set
88: RECORD_VERSION_NUMBER = nvl(X_RECORD_VERSION_NUMBER,0)+1,
89: LIFECYCLE_ID = X_LIFECYCLE_ID,
90: USAGE_TYPE = X_USAGE_TYPE,
91: LIFECYCLE_USAGE_ID = X_LIFECYCLE_USAGE_ID,

Line 110: delete from PA_LIFECYCLE_USAGES

106: PROCEDURE DELETE_ROW (
107: X_LIFECYCLE_USAGE_ID in NUMBER
108: ) IS
109: BEGIN
110: delete from PA_LIFECYCLE_USAGES
111: where LIFECYCLE_USAGE_ID = X_LIFECYCLE_USAGE_ID;
112:
113: if (sql%notfound) then
114: raise no_data_found;

Line 119: END PA_LIFECYCLE_USAGES_PKG;

115: end if;
116:
117: END DELETE_ROW;
118:
119: END PA_LIFECYCLE_USAGES_PKG;