APPS.PA_CI_TYPE_USAGE_PKG dependencies on PA_CI_TYPE_USAGE

Line 1: package body PA_CI_TYPE_USAGE_PKG as

1: package body PA_CI_TYPE_USAGE_PKG as
2: /* $Header: PACITUTB.pls 120.2 2005/08/22 05:14:57 sukhanna noship $ */
3: procedure INSERT_ROW (
4: X_ROWID out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
5: X_CI_TYPE_USAGE_ID out NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 14: cursor C is select ROWID from PA_CI_TYPE_USAGE

10: X_LAST_UPDATE_DATE in DATE,
11: X_LAST_UPDATED_BY in NUMBER,
12: X_LAST_UPDATE_LOGIN in NUMBER
13: ) is
14: cursor C is select ROWID from PA_CI_TYPE_USAGE
15: where CI_TYPE_USAGE_ID = X_CI_TYPE_USAGE_ID
16: ;
17: begin
18: SELECT pa_ci_type_usage_s.NEXTVAL

Line 18: SELECT pa_ci_type_usage_s.NEXTVAL

14: cursor C is select ROWID from PA_CI_TYPE_USAGE
15: where CI_TYPE_USAGE_ID = X_CI_TYPE_USAGE_ID
16: ;
17: begin
18: SELECT pa_ci_type_usage_s.NEXTVAL
19: INTO X_CI_TYPE_USAGE_ID
20: FROM sys.dual;
21:
22: insert into PA_CI_TYPE_USAGE (

Line 22: insert into PA_CI_TYPE_USAGE (

18: SELECT pa_ci_type_usage_s.NEXTVAL
19: INTO X_CI_TYPE_USAGE_ID
20: FROM sys.dual;
21:
22: insert into PA_CI_TYPE_USAGE (
23: CI_TYPE_USAGE_ID,
24: PROJECT_TYPE_ID,
25: CI_TYPE_ID,
26: CREATION_DATE,

Line 66: update PA_CI_TYPE_USAGE set

62: X_LAST_UPDATED_BY in NUMBER,
63: X_LAST_UPDATE_LOGIN in NUMBER
64: ) is
65: begin
66: update PA_CI_TYPE_USAGE set
67: PROJECT_TYPE_ID = X_PROJECT_TYPE_ID,
68: CI_TYPE_ID = X_CI_TYPE_ID,
69: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
70: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 83: from PA_CI_TYPE_USAGE

79: ) is
80: cursor c is select
81: PROJECT_TYPE_ID,
82: CI_TYPE_ID
83: from PA_CI_TYPE_USAGE
84: where CI_TYPE_USAGE_ID = X_CI_TYPE_USAGE_ID
85: for update of CI_TYPE_USAGE_ID nowait;
86: recinfo c%rowtype;
87:

Line 114: delete from PA_CI_TYPE_USAGE

110: procedure DELETE_ROW (
111: X_CI_TYPE_USAGE_ID in NUMBER
112: ) is
113: begin
114: delete from PA_CI_TYPE_USAGE
115: where CI_TYPE_USAGE_ID = X_CI_TYPE_USAGE_ID;
116:
117: if (sql%notfound) then
118: raise no_data_found;

Line 123: end PA_CI_TYPE_USAGE_PKG;

119: end if;
120: end DELETE_ROW;
121:
122:
123: end PA_CI_TYPE_USAGE_PKG;