DBA Data[Home] [Help]

APPS.PA_CI_TYPE_USAGE_PKG dependencies on PA_CI_TYPE_USAGE_S

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