PACKAGE: APPS.IGS_AD_NOTE_TYPES_PKG

Source

1 PACKAGE igs_ad_note_types_pkg AS
2 /* $Header: IGSAI76S.pls 120.0 2005/06/01 19:32:00 appldev noship $ */
3   procedure INSERT_ROW (
4     X_ROWID in out NOCOPY VARCHAR2,
5     x_NOTES_TYPE_ID IN OUT NOCOPY NUMBER,
6     x_NOTES_CATEGORY IN VARCHAR2,
7     x_NOTE_TYPE IN VARCHAR2,
8     x_DESCRIPTION IN VARCHAR2,
9     x_CLOSED_IND IN VARCHAR2,
10     X_MODE in VARCHAR2 default NULL
11   );
12 
13   procedure LOCK_ROW (
14     X_ROWID in  VARCHAR2,
15     x_NOTES_TYPE_ID IN NUMBER,
16     x_NOTES_CATEGORY IN VARCHAR2,
17     x_NOTE_TYPE IN VARCHAR2,
18     x_DESCRIPTION IN VARCHAR2,
19     x_CLOSED_IND IN VARCHAR2
20   );
21 
22   procedure UPDATE_ROW (
23     X_ROWID in  VARCHAR2,
24     x_NOTES_TYPE_ID IN NUMBER,
25     x_NOTES_CATEGORY IN VARCHAR2,
26     x_NOTE_TYPE IN VARCHAR2,
27     x_DESCRIPTION IN VARCHAR2,
28     x_CLOSED_IND IN VARCHAR2,
29     X_MODE in VARCHAR2 default NULL
30   );
31 
32   procedure ADD_ROW (
33     X_ROWID in out NOCOPY VARCHAR2,
34     x_NOTES_TYPE_ID IN  OUT NOCOPY NUMBER,
35     x_NOTES_CATEGORY IN VARCHAR2,
36     x_NOTE_TYPE IN VARCHAR2,
37     x_DESCRIPTION IN VARCHAR2,
38     x_CLOSED_IND IN VARCHAR2,
39     X_MODE in VARCHAR2 default NULL
40   ) ;
41 
42   procedure DELETE_ROW (
43     X_ROWID in VARCHAR2
44   );
45 
46   FUNCTION Get_PK_For_Validation (
47     x_notes_type_id IN NUMBER,
48     x_closed_ind IN VARCHAR2 DEFAULT NULL
49   ) RETURN BOOLEAN;
50 
51   FUNCTION Get_UK_For_Validation (
52     x_notes_category IN VARCHAR2,
53     x_note_type IN VARCHAR2,
54     x_closed_ind IN VARCHAR2 DEFAULT NULL
55   ) RETURN BOOLEAN;
56 
57    FUNCTION Get_UK2_For_Validation (
58     x_notes_type_id IN NUMBER,
59     x_notes_category IN VARCHAR2,
60     x_closed_ind IN VARCHAR2 DEFAULT NULL
61   ) RETURN BOOLEAN;
62 
63   PROCEDURE Check_Constraints (
64     Column_Name IN VARCHAR2  DEFAULT NULL,
65     Column_Value IN VARCHAR2  DEFAULT NULL
66   );
67 
68   PROCEDURE Before_DML (
69     p_action IN VARCHAR2,
70     x_rowid IN VARCHAR2 DEFAULT NULL,
71     x_notes_type_id IN NUMBER DEFAULT NULL,
72     x_notes_category IN VARCHAR2 DEFAULT NULL,
73     x_note_type IN VARCHAR2 DEFAULT NULL,
74     x_description IN VARCHAR2 DEFAULT NULL,
75     x_closed_ind IN VARCHAR2 DEFAULT NULL,
76     x_creation_date IN DATE DEFAULT NULL,
77     x_created_by IN NUMBER DEFAULT NULL,
78     x_last_update_date IN DATE DEFAULT NULL,
79     x_last_updated_by IN NUMBER DEFAULT NULL,
80     x_last_update_login IN NUMBER DEFAULT NULL
81   );
82 
83 END igs_ad_note_types_pkg;