DBA Data[Home] [Help]

PACKAGE: APPS.PSP_AUTO_SEGMENTS_PKG

Source


1 package PSP_AUTO_SEGMENTS_PKG AUTHID CURRENT_USER as
2 --$Header: PSPAUSGS.pls 115.9 2002/11/19 10:58:15 ddubey ship $
3  /* $HEADER$ */
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_SET_OF_BOOKS_ID in NUMBER,
7   X_BUSINESS_GROUP_ID IN NUMBER,
8   X_SEGMENT_NUMBER in NUMBER,
9   X_MODE in VARCHAR2 default 'R'
10   );
11 procedure LOCK_ROW (
12   X_SET_OF_BOOKS_ID in NUMBER,
13   X_BUSINESS_GROUP_ID IN NUMBER,
14   X_SEGMENT_NUMBER in NUMBER
15 );
16 procedure UPDATE_ROW (
17   X_SET_OF_BOOKS_ID in NUMBER,
18   X_BUSINESS_GROUP_ID IN NUMBER,
19   X_SEGMENT_NUMBER in NUMBER,
20   X_MODE in VARCHAR2 default 'R'
21   );
22 procedure ADD_ROW (
23   X_ROWID in out NOCOPY VARCHAR2,
24   X_SET_OF_BOOKS_ID in NUMBER,
25   X_BUSINESS_GROUP_ID IN NUMBER,
26   X_SEGMENT_NUMBER in NUMBER,
27   X_MODE in VARCHAR2 default 'R'
28   );
29 procedure DELETE_ROW (
30   X_SET_OF_BOOKS_ID in NUMBER,
31   X_BUSINESS_GROUP_ID IN NUMBER
32 );
33 end PSP_AUTO_SEGMENTS_PKG;