APPS.PA_CI_IMPACT_TYPE_USAGE_PKG dependencies on PA_CI_IMPACT_TYPE_USAGE

Line 1: package body PA_CI_IMPACT_TYPE_USAGE_PKG as

1: package body PA_CI_IMPACT_TYPE_USAGE_PKG as
2: /* $Header: PACIIMTB.pls 120.1 2009/03/24 17:36:38 cklee ship $ */
3: procedure INSERT_ROW (
4: X_ROWID out NOCOPY VARCHAR2,
5: X_CI_IMPACT_TYPE_USAGE_ID out NOCOPY NUMBER,

Line 20: cursor C is select ROWID from PA_CI_IMPACT_TYPE_USAGE

16: X_IMPACT_TYPE_CODE_ORDER IN NUMBER default null
17: --end:| 16-FEB-2009 cklee R12.1.2 setup ehancement
18:
19: ) is
20: cursor C is select ROWID from PA_CI_IMPACT_TYPE_USAGE
21: where CI_IMPACT_TYPE_USAGE_ID = X_CI_IMPACT_TYPE_USAGE_ID
22: ;
23: begin
24: SELECT pa_ci_impact_type_usage_s.NEXTVAL

Line 24: SELECT pa_ci_impact_type_usage_s.NEXTVAL

20: cursor C is select ROWID from PA_CI_IMPACT_TYPE_USAGE
21: where CI_IMPACT_TYPE_USAGE_ID = X_CI_IMPACT_TYPE_USAGE_ID
22: ;
23: begin
24: SELECT pa_ci_impact_type_usage_s.NEXTVAL
25: INTO X_CI_IMPACT_TYPE_USAGE_ID
26: FROM sys.dual;
27:
28: insert into PA_CI_IMPACT_TYPE_USAGE (

Line 28: insert into PA_CI_IMPACT_TYPE_USAGE (

24: SELECT pa_ci_impact_type_usage_s.NEXTVAL
25: INTO X_CI_IMPACT_TYPE_USAGE_ID
26: FROM sys.dual;
27:
28: insert into PA_CI_IMPACT_TYPE_USAGE (
29: CI_IMPACT_TYPE_USAGE_ID ,
30: impact_type_code ,
31: ci_type_class_code ,
32: CI_TYPE_ID ,

Line 79: from PA_CI_IMPACT_TYPE_USAGE

75: cursor c is select
76: impact_type_code,
77: ci_type_class_code,
78: ci_type_id
79: from PA_CI_IMPACT_TYPE_USAGE
80: where ci_impact_type_usage_id = X_CI_IMPACT_TYPE_USAGE_ID
81: for update of CI_impact_TYPE_USAGE_ID nowait;
82: recinfo c%rowtype;
83:

Line 111: update PA_CI_IMPACT_TYPE_USAGE set

107: X_CI_IMPACT_TYPE_USAGE_ID in NUMBER,
108: X_IMPACT_TYPE_CODE_ORDER IN NUMBER
109: ) is
110: begin
111: update PA_CI_IMPACT_TYPE_USAGE set
112: IMPACT_TYPE_CODE_ORDER = X_IMPACT_TYPE_CODE_ORDER
113: where CI_IMPACT_TYPE_USAGE_ID = X_CI_IMPACT_TYPE_USAGE_ID;
114:
115: if (sql%notfound) then

Line 126: delete from PA_CI_IMPACT_TYPE_USAGE

122: procedure DELETE_ROW (
123: X_CI_IMPACT_TYPE_USAGE_ID in NUMBER
124: ) is
125: begin
126: delete from PA_CI_IMPACT_TYPE_USAGE
127: where CI_IMPACT_TYPE_USAGE_ID = X_CI_IMPACT_TYPE_USAGE_ID;
128:
129: if (sql%notfound) then
130: raise no_data_found;

Line 135: end PA_CI_IMPACT_TYPE_USAGE_PKG;

131: end if;
132: end DELETE_ROW;
133:
134:
135: end PA_CI_IMPACT_TYPE_USAGE_PKG;