19: P_START_DATE_ACTIVE IN DATE,
20: P_END_DATE_ACTIVE IN DATE,
21: P_DESCRIPTION IN VARCHAR2,
22: P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
23: P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
24: P_CREATION_DATE IN DATE DEFAULT SYSDATE,
25: P_CREATED_BY IN NUMBER DEFAULT fnd_global.user_id,
26: P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.login_id,
27: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
21: P_DESCRIPTION IN VARCHAR2,
22: P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
23: P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
24: P_CREATION_DATE IN DATE DEFAULT SYSDATE,
25: P_CREATED_BY IN NUMBER DEFAULT fnd_global.user_id,
26: P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.login_id,
27: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
28: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
29: X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22: P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
23: P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
24: P_CREATION_DATE IN DATE DEFAULT SYSDATE,
25: P_CREATED_BY IN NUMBER DEFAULT fnd_global.user_id,
26: P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.login_id,
27: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
28: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
29: X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
30: );
47: P_START_DATE_ACTIVE IN DATE,
48: P_END_DATE_ACTIVE IN DATE,
49: P_DESCRIPTION IN VARCHAR2,
50: P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
51: P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
52: P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.login_id,
53: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
54: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
55: X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48: P_END_DATE_ACTIVE IN DATE,
49: P_DESCRIPTION IN VARCHAR2,
50: P_LAST_UPDATE_DATE IN DATE DEFAULT SYSDATE,
51: P_LAST_UPDATED_BY IN NUMBER DEFAULT fnd_global.user_id,
52: P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT fnd_global.login_id,
53: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
54: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
55: X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
56: );