PACKAGE: APPS.IGS_TR_TYP_STEP_NOTE_PKG

Source

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