PACKAGE: APPS.IGS_OR_ORG_NOTES_PKG

Source

1 PACKAGE igs_or_org_notes_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSOI18S.pls 115.6 2002/11/29 01:41:50 nsidana ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_ORG_STRUCTURE_ID IN VARCHAR2,
6        x_ORG_STRUCTURE_TYPE IN VARCHAR2,
7        x_ORG_NOTE_SEQUENCE IN OUT NOCOPY NUMBER,
8        x_ORG_NOTE_TYPE IN VARCHAR2,
9        x_START_DATE IN DATE,
10        x_END_DATE IN DATE,
11        x_NOTE_TEXT IN VARCHAR2,
12       X_MODE in VARCHAR2 default 'R'
13   );
14 
15  procedure LOCK_ROW (
16       X_ROWID in  VARCHAR2,
17        x_ORG_STRUCTURE_ID IN VARCHAR2,
18        x_ORG_STRUCTURE_TYPE IN VARCHAR2,
19        x_ORG_NOTE_SEQUENCE IN NUMBER,
20        x_ORG_NOTE_TYPE IN VARCHAR2,
21        x_START_DATE IN DATE,
22        x_END_DATE IN DATE,
23        x_NOTE_TEXT IN VARCHAR2  );
24  procedure UPDATE_ROW (
25       X_ROWID in  VARCHAR2,
26        x_ORG_STRUCTURE_ID IN VARCHAR2,
27        x_ORG_STRUCTURE_TYPE IN VARCHAR2,
28        x_ORG_NOTE_SEQUENCE IN NUMBER,
29        x_ORG_NOTE_TYPE IN VARCHAR2,
30        x_START_DATE IN DATE,
31        x_END_DATE IN DATE,
32        x_NOTE_TEXT IN VARCHAR2,
33       X_MODE in VARCHAR2 default 'R'
34   );
35 
36  procedure ADD_ROW (
37       X_ROWID in out NOCOPY VARCHAR2,
38        x_ORG_STRUCTURE_ID IN VARCHAR2,
39        x_ORG_STRUCTURE_TYPE IN VARCHAR2,
40        x_ORG_NOTE_SEQUENCE IN NUMBER,
41        x_ORG_NOTE_TYPE IN VARCHAR2,
42        x_START_DATE IN DATE,
43        x_END_DATE IN DATE,
44        x_NOTE_TEXT IN VARCHAR2,
45       X_MODE in VARCHAR2 default 'R'
46   ) ;
47 
48 procedure DELETE_ROW (
49   X_ROWID in VARCHAR2
50 ) ;
51   FUNCTION Get_PK_For_Validation (
52     x_org_structure_type IN VARCHAR2,
53     x_org_note_sequence IN NUMBER,
54     x_org_note_type IN VARCHAR2,
55     x_org_structure_id IN VARCHAR2
56     ) RETURN BOOLEAN ;
57 
58   PROCEDURE Get_FK_Igs_Or_Org_Note_Type (
59     x_org_notes_type IN VARCHAR2
60     );
61 
62   PROCEDURE Get_FK_Igs_Or_Institution (
63     x_institution_cd IN VARCHAR2
64     );
65 
66   PROCEDURE Get_FK_Igs_Ad_Location(
67     x_location_cd IN VARCHAR2
68     );
69 
70   PROCEDURE GET_FK_IGS_OR_UNIT (
71     x_org_unit_cd IN VARCHAR2
72     ) ;
73 
74   PROCEDURE Check_Constraints (
75 		 Column_Name IN VARCHAR2  DEFAULT NULL,
76 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
77   PROCEDURE Before_DML (
78     p_action IN VARCHAR2,
79     x_rowid IN VARCHAR2 DEFAULT NULL,
80     x_org_structure_id IN VARCHAR2 DEFAULT NULL,
81     x_org_structure_type IN VARCHAR2 DEFAULT NULL,
82     x_org_note_sequence IN NUMBER DEFAULT NULL,
83     x_org_note_type IN VARCHAR2 DEFAULT NULL,
84     x_start_date IN DATE DEFAULT NULL,
85     x_end_date IN DATE DEFAULT NULL,
86     x_note_text IN VARCHAR2 DEFAULT NULL,
87     x_creation_date IN DATE DEFAULT NULL,
88     x_created_by IN NUMBER DEFAULT NULL,
89     x_last_update_date IN DATE DEFAULT NULL,
90     x_last_updated_by IN NUMBER DEFAULT NULL,
91     x_last_update_login IN NUMBER DEFAULT NULL
92  );
93 END igs_or_org_notes_pkg;