DBA Data[Home] [Help]

PACKAGE: APPS.PSA_IMPLEMENTATION_ALL_PKG

Source


1 package  PSA_IMPLEMENTATION_ALL_PKG as
2  /* $Header: PSAIMPLS.pls 120.2 2006/09/13 11:54:41 agovil ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_PSA_FEATURE in VARCHAR2,
6   X_ORG_ID in NUMBER,
7   X_STATUS in VARCHAR2,
8   X_ALLOCATION_METHOD in VARCHAR2,
9   X_MAPPING_REQUIRED in VARCHAR2,
10   X_PROGRAM_INSTALLED in VARCHAR2,
11   X_MODE in VARCHAR2 default 'R'
12   );
13 procedure LOCK_ROW (
14   X_PSA_FEATURE in VARCHAR2,
15   X_ORG_ID in NUMBER,
16   X_STATUS in VARCHAR2,
17   X_ALLOCATION_METHOD in VARCHAR2,
18   X_MAPPING_REQUIRED in VARCHAR2,
19   X_PROGRAM_INSTALLED in VARCHAR2
20 );
21 procedure UPDATE_ROW (
22   X_PSA_FEATURE in VARCHAR2,
23   X_ORG_ID in NUMBER,
24   X_STATUS in VARCHAR2,
25   X_ALLOCATION_METHOD in VARCHAR2,
26   X_MAPPING_REQUIRED in VARCHAR2,
27   X_PROGRAM_INSTALLED in VARCHAR2,
28   X_MODE in VARCHAR2 default 'R'
29   );
30 procedure ADD_ROW (
31   X_ROWID in out nocopy VARCHAR2,
32   X_PSA_FEATURE in VARCHAR2,
33   X_ORG_ID in NUMBER,
34   X_STATUS in VARCHAR2,
35   X_ALLOCATION_METHOD in VARCHAR2,
36   X_MAPPING_REQUIRED in VARCHAR2,
37   X_PROGRAM_INSTALLED in VARCHAR2,
38   X_MODE in VARCHAR2 default 'R'
39   );
40 procedure DELETE_ROW (
41   X_PSA_FEATURE in VARCHAR2,
42   X_ORG_ID in NUMBER
43 );
44 end PSA_IMPLEMENTATION_ALL_PKG;