PACKAGE: APPS.IGS_OR_ORG_NOTE_TYPE_PKG

Source

1 PACKAGE igs_or_org_note_type_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSOI17S.pls 115.6 2002/11/29 01:41:34 nsidana ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_ORG_NOTES_TYPE IN VARCHAR2,
6        x_NOTE_TYPE_DESCRIPTION IN VARCHAR2,
7        x_INST_FLAG IN VARCHAR2,
8        x_UNIT_FLAG IN VARCHAR2,
9        x_LOCATION_FLAG IN VARCHAR2,
10       X_MODE in VARCHAR2 default 'R'
11   );
12 
13  procedure LOCK_ROW (
14       X_ROWID in  VARCHAR2,
15        x_ORG_NOTES_TYPE IN VARCHAR2,
16        x_NOTE_TYPE_DESCRIPTION IN VARCHAR2,
17        x_INST_FLAG IN VARCHAR2,
18        x_UNIT_FLAG IN VARCHAR2,
19        x_LOCATION_FLAG IN VARCHAR2  );
20  procedure UPDATE_ROW (
21       X_ROWID in  VARCHAR2,
22        x_ORG_NOTES_TYPE IN VARCHAR2,
23        x_NOTE_TYPE_DESCRIPTION IN VARCHAR2,
24        x_INST_FLAG IN VARCHAR2,
25        x_UNIT_FLAG IN VARCHAR2,
26        x_LOCATION_FLAG IN VARCHAR2,
27       X_MODE in VARCHAR2 default 'R'
28   );
29 
30  procedure ADD_ROW (
31       X_ROWID in out NOCOPY VARCHAR2,
32        x_ORG_NOTES_TYPE IN VARCHAR2,
33        x_NOTE_TYPE_DESCRIPTION IN VARCHAR2,
34        x_INST_FLAG IN VARCHAR2,
35        x_UNIT_FLAG IN VARCHAR2,
36        x_LOCATION_FLAG IN VARCHAR2,
37       X_MODE in VARCHAR2 default 'R'
38   ) ;
39 
40 procedure DELETE_ROW (
41   X_ROWID in VARCHAR2
42 ) ;
43   FUNCTION Get_PK_For_Validation (
44     x_org_notes_type IN VARCHAR2
45     ) RETURN BOOLEAN ;
46 
47   PROCEDURE Check_Constraints (
48 		 Column_Name IN VARCHAR2  DEFAULT NULL,
49 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
50   PROCEDURE Before_DML (
51     p_action IN VARCHAR2,
52     x_rowid IN VARCHAR2 DEFAULT NULL,
53     x_org_notes_type IN VARCHAR2 DEFAULT NULL,
54     x_note_type_description IN VARCHAR2 DEFAULT NULL,
55     x_inst_flag IN VARCHAR2 DEFAULT NULL,
56     x_unit_flag IN VARCHAR2 DEFAULT NULL,
57     x_location_flag IN VARCHAR2 DEFAULT NULL,
58     x_creation_date IN DATE DEFAULT NULL,
59     x_created_by IN NUMBER DEFAULT NULL,
60     x_last_update_date IN DATE DEFAULT NULL,
61     x_last_updated_by IN NUMBER DEFAULT NULL,
62     x_last_update_login IN NUMBER DEFAULT NULL
63  );
64 END igs_or_org_note_type_pkg;