1 PACKAGE igs_tr_status_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSTI02S.pls 115.6 2003/02/19 12:55:22 kpadiyar ship $ */
3
4 /*******************************************************************************
5 Created by : Oracle IDC
6 Date created:
7
8 Purpose:
9 1. Used for creation of tracking steps and associating them with
10 system tracking types
11
12 Usage: (e.g. restricted, unrestricted, where to call from)
13 1. Called from IGSTR003.fmb
14
15 Known limitations/enhancements/remarks:
16 -
17
18 Change History: (who, when, what: NO CREATION RECORDS HERE!)
19 Who When What
20 msrinivi 9 Jul, 2001 Added the new column default_ind to TBH
21 *******************************************************************************/
22
23 PROCEDURE insert_row (
24 x_rowid IN OUT NOCOPY VARCHAR2,
25 x_tracking_status IN VARCHAR2,
26 x_description IN VARCHAR2,
27 x_s_tracking_status IN VARCHAR2,
28 x_closed_ind IN VARCHAR2,
29 x_mode IN VARCHAR2 DEFAULT 'R',
30 x_default_ind IN VARCHAR2 DEFAULT 'N'
31 );
32
33 /*******************************************************************************
34 Created by : Oracle IDC
35 Date created:
36
37 Purpose:
38 1. Used for creation of tracking steps and associating them with
39 system tracking types
40
41 Usage: (e.g. restricted, unrestricted, where to call from)
42 1. Called from IGSTR003.fmb
43
44 Known limitations/enhancements/remarks:
45 -
46
47 Change History: (who, when, what: NO CREATION RECORDS HERE!)
48 Who When What
49 msrinivi 9 Jul, 2001 Added the new column default_ind to TBH
50 *******************************************************************************/
51
52 PROCEDURE lock_row (
53 x_rowid IN VARCHAR2,
54 x_tracking_status IN VARCHAR2,
55 x_description IN VARCHAR2,
56 x_s_tracking_status IN VARCHAR2,
57 x_closed_ind IN VARCHAR2,
58 x_default_ind IN VARCHAR2 DEFAULT 'N'
59 );
60
61 /*******************************************************************************
62 Created by : Oracle IDC
63 Date created:
64
65 Purpose:
66 1. Used for creation of tracking steps and associating them with
67 system tracking types
68
69 Usage: (e.g. restricted, unrestricted, where to call from)
70 1. Called from IGSTR003.fmb
71
72 Known limitations/enhancements/remarks:
73 -
74
75 Change History: (who, when, what: NO CREATION RECORDS HERE!)
76 Who When What
77 msrinivi 9 Jul, 2001 Added the new column default_ind to TBH
78 *******************************************************************************/
79
80 PROCEDURE update_row (
81 x_rowid IN VARCHAR2,
82 x_tracking_status IN VARCHAR2,
83 x_description IN VARCHAR2,
84 x_s_tracking_status IN VARCHAR2,
85 x_closed_ind IN VARCHAR2,
86 x_mode IN VARCHAR2 DEFAULT 'R',
87 x_default_ind IN VARCHAR2 DEFAULT 'N'
88 );
89 /*******************************************************************************
90 Created by : Oracle IDC
91 Date created:
92
93 Purpose:
94 1. Used for creation of tracking steps and associating them with
95 system tracking types
96
97 Usage: (e.g. restricted, unrestricted, where to call from)
98 1. Called from IGSTR003.fmb
99
100 Known limitations/enhancements/remarks:
101 -
102 Change History: (who, when, what: NO CREATION RECORDS HERE!)
103 Who When What
104 msrinivi 9 Jul, 2001 Added the new column default_ind to TBH
105 *******************************************************************************/
106
107 PROCEDURE add_row (
108 x_rowid IN OUT NOCOPY VARCHAR2,
109 x_tracking_status IN VARCHAR2,
110 x_description IN VARCHAR2,
111 x_s_tracking_status IN VARCHAR2,
112 x_closed_ind IN VARCHAR2,
113 x_mode IN VARCHAR2 DEFAULT 'R',
114 x_default_ind IN VARCHAR2 DEFAULT 'N'
115 );
116
117 FUNCTION get_pk_for_validation (
118 x_tracking_status IN VARCHAR2
119 )RETURN BOOLEAN;
120
121 -- added to take care of check constraints
122 PROCEDURE check_constraints(
123 column_name IN VARCHAR2 DEFAULT NULL,
124 column_value IN VARCHAR2 DEFAULT NULL
125 );
126
127 /*******************************************************************************
128 Created by : Oracle IDC
129 Date created:
130
131 Purpose:
132 1. Used for creation of tracking steps and associating them with
133 system tracking types
134
135 Usage: (e.g. restricted, unrestricted, where to call from)
136 1. Called from IGSTR003.fmb
137
138 Known limitations/enhancements/remarks:
139 -
140
141 Change History: (who, when, what: NO CREATION RECORDS HERE!)
142 Who When What
143 msrinivi 9 Jul, 2001 Added the new column default_ind to TBH
144 *******************************************************************************/
145
146 PROCEDURE before_dml (
147 p_action IN VARCHAR2,
148 x_rowid IN VARCHAR2 DEFAULT NULL,
149 x_tracking_status IN VARCHAR2 DEFAULT NULL,
150 x_description IN VARCHAR2 DEFAULT NULL,
151 x_s_tracking_status IN VARCHAR2 DEFAULT NULL,
152 x_closed_ind IN VARCHAR2 DEFAULT NULL,
153 x_creation_date IN DATE DEFAULT NULL,
154 x_created_by IN NUMBER DEFAULT NULL,
155 x_last_update_date IN DATE DEFAULT NULL,
156 x_last_updated_by IN NUMBER DEFAULT NULL,
157 x_last_update_login IN NUMBER DEFAULT NULL,
158 x_default_ind IN VARCHAR2 DEFAULT 'N'
159 );
160
161 END igs_tr_status_pkg;