PACKAGE: APPS.IGS_TR_STEP_NOTE_PKG

Source

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