APPS.PA_CI_IMPACT_TYPE_USAGE_PKG dependencies on PA_CI_IMPACT_TYPE_USAGE_S

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 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