APPS.PA_CI_IMPACTS_PKG dependencies on PA_CI_IMPACTS

Line 1: package body PA_CI_IMPACTS_PKG as

1: package body PA_CI_IMPACTS_PKG as
2: /* $Header: PACIIPTB.pls 120.0 2005/06/03 13:37:12 appldev noship $ */
3: procedure INSERT_ROW (
4: X_ROWID out NOCOPY VARCHAR2,
5: X_CI_IMPACT_ID out NOCOPY NUMBER,

Line 22: cursor C is select ROWID from PA_CI_IMPACTS

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from PA_CI_IMPACTS
23: where CI_IMPACT_ID = X_CI_IMPACT_ID
24: ;
25: begin
26: SELECT pa_ci_impacts_s.NEXTVAL

Line 26: SELECT pa_ci_impacts_s.NEXTVAL

22: cursor C is select ROWID from PA_CI_IMPACTS
23: where CI_IMPACT_ID = X_CI_IMPACT_ID
24: ;
25: begin
26: SELECT pa_ci_impacts_s.NEXTVAL
27: INTO X_CI_IMPACT_ID
28: FROM sys.dual;
29:
30: insert into PA_CI_IMPACTS (

Line 30: insert into PA_CI_IMPACTS (

26: SELECT pa_ci_impacts_s.NEXTVAL
27: INTO X_CI_IMPACT_ID
28: FROM sys.dual;
29:
30: insert into PA_CI_IMPACTS (
31: ci_impact_id ,
32: CI_ID ,
33: impact_type_code ,
34: status_code ,

Line 80: from PA_CI_IMPACTS

76: x_record_version_number) is
77: cursor c is select
78: impact_type_code,
79: ci_id
80: from PA_CI_IMPACTS
81: where ci_impact_id
82: = x_ci_impact_id
83: AND record_version_number = x_record_version_number
84: for update of CI_impact_ID nowait;

Line 107: delete from PA_CI_IMPACTS

103: X_CI_IMPACT_ID in NUMBER,
104: X_record_version_number in NUMBER
105: ) is
106: begin
107: delete from PA_CI_IMPACTS
108: where CI_IMPACT_ID = x_ci_impact_id
109: AND record_version_number =x_record_version_number;
110:
111: -- if (sql%notfound) then

Line 136: update PA_CI_IMPACTS SET

132: ) is
133: begin
134:
135:
136: update PA_CI_IMPACTS SET
137: CI_ID = Nvl(x_ci_id, ci_id),
138: impact_type_code = Nvl(x_impact_type_code,impact_type_code),
139: status_code = Nvl(x_status_code,status_code),
140: description = x_description,

Line 170: end PA_CI_IMPACTS_PKG;

166: */
167:
168: end UPDATE_ROW;
169:
170: end PA_CI_IMPACTS_PKG;