PACKAGE: APPS.IGS_PS_CATLG_VERS_PKG

Source

1 PACKAGE igs_ps_catlg_vers_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSPI1JS.pls 115.7 2002/11/29 02:07:20 nsidana ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_CATALOG_VERSION_ID IN OUT NOCOPY NUMBER,
6        x_CATALOG_VERSION IN VARCHAR2,
7        x_DESCRIPTION IN VARCHAR2,
8        x_CLOSED_IND IN VARCHAR2,
9        x_CATALOG_SCHEDULE IN VARCHAR2,
10       X_MODE in VARCHAR2 default 'R'  ,
11        X_ORG_ID IN NUMBER
12   );
13 
14  procedure LOCK_ROW (
15       X_ROWID in  VARCHAR2,
16        x_CATALOG_VERSION_ID IN NUMBER,
17        x_CATALOG_VERSION IN VARCHAR2,
18        x_DESCRIPTION IN VARCHAR2,
19        x_CLOSED_IND IN VARCHAR2,
20        x_CATALOG_SCHEDULE IN VARCHAR2
21        );
22  procedure UPDATE_ROW (
23       X_ROWID in  VARCHAR2,
24        x_CATALOG_VERSION_ID IN NUMBER,
25        x_CATALOG_VERSION IN VARCHAR2,
26        x_DESCRIPTION IN VARCHAR2,
27        x_CLOSED_IND IN VARCHAR2,
28        x_CATALOG_SCHEDULE IN VARCHAR2,
29       X_MODE in VARCHAR2 default 'R'
30   );
31 
32  procedure ADD_ROW (
33       X_ROWID in out NOCOPY VARCHAR2,
34        x_CATALOG_VERSION_ID IN OUT NOCOPY NUMBER,
35        x_CATALOG_VERSION IN VARCHAR2,
36        x_DESCRIPTION IN VARCHAR2,
37        x_CLOSED_IND IN VARCHAR2,
38        x_CATALOG_SCHEDULE IN VARCHAR2,
39       X_MODE in VARCHAR2 default 'R'  ,
40        X_ORG_ID IN NUMBER
41   ) ;
42 
43 procedure DELETE_ROW (
44   X_ROWID in VARCHAR2
45 ) ;
46   FUNCTION Get_PK_For_Validation (
47     x_catalog_version_id IN NUMBER
48     ) RETURN BOOLEAN ;
49 
50   FUNCTION Get_UK_For_Validation (
51     x_catalog_schedule IN VARCHAR2,
52     x_catalog_version IN VARCHAR2
53     ) RETURN BOOLEAN;
54 
55   PROCEDURE Check_Constraints (
56 		 Column_Name IN VARCHAR2  DEFAULT NULL,
57 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
58   PROCEDURE Before_DML (
59     p_action IN VARCHAR2,
60     x_rowid IN VARCHAR2 DEFAULT NULL,
61     x_catalog_version_id IN NUMBER DEFAULT NULL,
62     x_catalog_version IN VARCHAR2 DEFAULT NULL,
63     x_description IN VARCHAR2 DEFAULT NULL,
64     x_closed_ind IN VARCHAR2 DEFAULT NULL,
65     x_catalog_schedule IN VARCHAR2 DEFAULT NULL,
66     x_creation_date IN DATE DEFAULT NULL,
67     x_created_by IN NUMBER DEFAULT NULL,
68     x_last_update_date IN DATE DEFAULT NULL,
69     x_last_updated_by IN NUMBER DEFAULT NULL,
70     x_last_update_login IN NUMBER DEFAULT NULL,
71     x_org_id IN NUMBER DEFAULT NULL
72  );
73 END igs_ps_catlg_vers_pkg;