PACKAGE: APPS.IGS_TR_NOTE_TYPE_PKG

Source

1 PACKAGE igs_tr_note_type_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSTI08S.pls 115.5 2002/11/29 04:16:02 nsidana ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid IN OUT NOCOPY VARCHAR2,
6     x_trk_note_type IN VARCHAR2,
7     x_description IN VARCHAR2,
8     x_mode IN VARCHAR2 DEFAULT 'R'
9   );
10 
11   PROCEDURE lock_row (
12     x_rowid IN VARCHAR2,
13     x_trk_note_type IN VARCHAR2,
14     x_description IN VARCHAR2
15   );
16 
17   PROCEDURE update_row (
18     x_rowid IN VARCHAR2,
19     x_trk_note_type IN VARCHAR2,
20     x_description IN VARCHAR2,
21     x_mode IN VARCHAR2 DEFAULT 'R'
22   );
23 
24   PROCEDURE add_row (
25     x_rowid IN OUT NOCOPY VARCHAR2,
26     x_trk_note_type IN VARCHAR2,
27     x_description IN VARCHAR2,
28     x_mode IN VARCHAR2 DEFAULT 'R'
29   );
30 
31   PROCEDURE delete_row (
32     x_rowid IN VARCHAR2
33   );
34 
35   FUNCTION get_pk_for_validation (
36     x_trk_note_type IN VARCHAR2
37   )RETURN BOOLEAN;
38 
39   PROCEDURE check_constraints(
40     column_name  IN VARCHAR2 DEFAULT NULL,
41     column_value  IN VARCHAR2 DEFAULT NULL
42   );
43 
44   PROCEDURE before_dml (
45     p_action IN VARCHAR2,
46     x_rowid IN VARCHAR2 DEFAULT NULL,
47     x_trk_note_type IN VARCHAR2 DEFAULT NULL,
48     x_description IN VARCHAR2 DEFAULT NULL,
49     x_creation_date IN DATE DEFAULT NULL,
50     x_created_by IN NUMBER DEFAULT NULL,
51     x_last_update_date IN DATE DEFAULT NULL,
52     x_last_updated_by IN NUMBER DEFAULT NULL,
53     x_last_update_login IN NUMBER DEFAULT NULL
54   );
55 
56 END igs_tr_note_type_pkg;