PACKAGE: APPS.IGS_TR_ITEM_NOTE_PKG

Source

1 PACKAGE igs_tr_item_note_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSTI01S.pls 115.5 2002/11/29 04:13:49 nsidana ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid IN OUT NOCOPY VARCHAR2,
6     x_tracking_id IN NUMBER,
7     x_reference_number IN NUMBER,
8     x_trk_note_type IN VARCHAR2,
9     x_mode IN VARCHAR2 DEFAULT 'R'
10   );
11 
12   PROCEDURE lock_row (
13     x_rowid IN VARCHAR2,
14     x_tracking_id IN NUMBER,
15     x_reference_number IN NUMBER,
16     x_trk_note_type IN VARCHAR2
17   );
18 
19   PROCEDURE update_row (
20     x_rowid IN VARCHAR2,
21     x_tracking_id IN NUMBER,
22     x_reference_number IN NUMBER,
23     x_trk_note_type IN VARCHAR2,
24     x_mode IN VARCHAR2 DEFAULT 'R'
25   );
26 
27   PROCEDURE add_row (
28     x_rowid IN OUT NOCOPY VARCHAR2,
29     x_tracking_id IN NUMBER,
30     x_reference_number IN NUMBER,
31     x_trk_note_type IN VARCHAR2,
32     x_mode IN VARCHAR2 DEFAULT 'R'
33   );
34 
35   PROCEDURE delete_row (
36     x_rowid IN VARCHAR2
37   );
38 
39   FUNCTION get_pk_for_validation (
40     x_tracking_id IN NUMBER,
41     x_reference_number IN NUMBER
42   ) RETURN BOOLEAN;
43 
44   PROCEDURE check_constraints(
45     column_name  IN VARCHAR2 DEFAULT NULL,
46     column_value  IN VARCHAR2 DEFAULT NULL
47   );
48 
49   PROCEDURE before_dml (
50     p_action IN VARCHAR2,
51     x_rowid IN VARCHAR2 DEFAULT NULL,
52     x_tracking_id IN NUMBER DEFAULT NULL,
53     x_reference_number IN NUMBER DEFAULT NULL,
54     x_trk_note_type IN VARCHAR2 DEFAULT NULL,
55     x_creation_date IN DATE DEFAULT NULL,
56     x_created_by IN NUMBER DEFAULT NULL,
57     x_last_update_date IN DATE DEFAULT NULL,
58     x_last_updated_by IN NUMBER DEFAULT NULL,
59     x_last_update_login IN NUMBER DEFAULT NULL
60   );
61 
62   PROCEDURE get_fk_igs_ge_note (
63     x_reference_number IN NUMBER
64   );
65 
66   PROCEDURE get_fk_igs_tr_note_type (
67     x_trk_note_type IN VARCHAR2
68   );
69 
70   PROCEDURE get_fk_igs_tr_item (
71     x_tracking_id IN NUMBER
72   );
73 
74 END igs_tr_item_note_pkg;