PACKAGE: APPS.IGS_PS_CATLG_NOTES_PKG

Source

1 PACKAGE igs_ps_catlg_notes_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSPI0QS.pls 115.8 2002/11/29 01:59:40 nsidana ship $ */
3  procedure INSERT_ROW (
4        X_ROWID in out NOCOPY VARCHAR2,
5        x_CATALOG_NOTE_ID IN OUT NOCOPY NUMBER,
6        x_CATALOG_VERSION_ID IN NUMBER,
7        x_NOTE_TYPE_ID IN NUMBER,
8        x_CREATE_DATE IN DATE,
9        x_END_DATE IN DATE,
10        x_SEQUENCE IN NUMBER,
11        x_NOTE_TEXT IN VARCHAR2,
12        X_MODE in VARCHAR2 default 'R',
13        X_ORG_ID IN NUMBER
14   );
15 
16  procedure LOCK_ROW (
17       X_ROWID in  VARCHAR2,
18        x_CATALOG_NOTE_ID IN NUMBER,
19        x_CATALOG_VERSION_ID IN NUMBER,
20        x_NOTE_TYPE_ID IN NUMBER,
21        x_CREATE_DATE IN DATE,
22        x_END_DATE IN DATE,
23        x_SEQUENCE IN NUMBER,
24        x_NOTE_TEXT IN VARCHAR2
25       );
26 
27 
28  procedure UPDATE_ROW (
29       X_ROWID in  VARCHAR2,
30        x_CATALOG_NOTE_ID IN NUMBER,
31        x_CATALOG_VERSION_ID IN NUMBER,
32        x_NOTE_TYPE_ID IN NUMBER,
33        x_CREATE_DATE IN DATE,
34        x_END_DATE IN DATE,
35        x_SEQUENCE IN NUMBER,
36        x_NOTE_TEXT IN VARCHAR2,
37        X_MODE in VARCHAR2 default 'R'
38   );
39 
40  procedure ADD_ROW (
41       X_ROWID in out NOCOPY VARCHAR2,
42        x_CATALOG_NOTE_ID IN OUT NOCOPY NUMBER,
43        x_CATALOG_VERSION_ID IN NUMBER,
44        x_NOTE_TYPE_ID IN NUMBER,
45        x_CREATE_DATE IN DATE,
46        x_END_DATE IN DATE,
47        x_SEQUENCE IN NUMBER,
48        x_NOTE_TEXT IN VARCHAR2,
49        X_MODE in VARCHAR2 default 'R',
50        X_ORG_ID IN NUMBER
51   ) ;
52 
53 
54 procedure DELETE_ROW (
55   X_ROWID in VARCHAR2
56 ) ;
57 
58   FUNCTION Get_PK_For_Validation (
59     x_catalog_note_id IN NUMBER
60     ) RETURN BOOLEAN ;
61 
62 
63   FUNCTION Get_UK_For_Validation (
64     x_catalog_version_id IN NUMBER,
65     x_note_type_id IN NUMBER,
66     x_sequence IN NUMBER
67     ) RETURN BOOLEAN;
68 
69   PROCEDURE Get_FK_Igs_Ps_Catlg_Vers (
70     x_catalog_version_id IN NUMBER
71     );
72 
73   PROCEDURE Get_FK_Igs_Ps_Note_Types (
74     x_note_type_id IN NUMBER
75     );
76 
77   PROCEDURE Check_Constraints (
78 		 Column_Name IN VARCHAR2  DEFAULT NULL,
79 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
80   PROCEDURE Before_DML (
81     p_action IN VARCHAR2,
82     x_rowid IN VARCHAR2 DEFAULT NULL,
83     x_catalog_note_id IN NUMBER DEFAULT NULL,
84     x_catalog_version_id IN NUMBER DEFAULT NULL,
85     x_note_type_id IN NUMBER DEFAULT NULL,
86     x_create_date IN DATE DEFAULT NULL,
87     x_end_date IN DATE DEFAULT NULL,
88     x_sequence IN NUMBER DEFAULT NULL,
89     x_note_text IN VARCHAR2 DEFAULT NULL,
90     x_creation_date IN DATE DEFAULT NULL,
91     x_created_by IN NUMBER DEFAULT NULL,
92     x_last_update_date IN DATE DEFAULT NULL,
93     x_last_updated_by IN NUMBER DEFAULT NULL,
94     x_last_update_login IN NUMBER DEFAULT NULL,
95     x_org_id IN NUMBER DEFAULT NULL
96  );
97 END igs_ps_catlg_notes_pkg;