PACKAGE: APPS.IGS_TR_GEN_001

Source

1 PACKAGE igs_tr_gen_001 AUTHID CURRENT_USER AS
2 /* $Header: IGSTR01S.pls 115.8 2002/11/29 04:18:15 nsidana ship $ */
3 --added new parameter p_override_offset_clc_ind for tracking dld nov2001 release
4 -- (bug#1837257) to function trkp_clc_dt_offset()
5   FUNCTION trkp_clc_action_dt(
6     p_tracking_id IN NUMBER ,
7     p_tracking_step_number IN NUMBER ,
8     p_start_dt IN DATE ,
9     p_sequence_ind IN VARCHAR2 DEFAULT 'N',
10     p_business_days_ind IN VARCHAR2 DEFAULT 'N')
11   RETURN DATE;
12   PRAGMA restrict_references (trkp_clc_action_dt, wnds);
13 
14   FUNCTION trkp_clc_bus_dt(
15     p_start_dt IN DATE ,
16     p_business_days IN NUMBER )
17   RETURN DATE;
18   PRAGMA restrict_references (trkp_clc_bus_dt, wnds,wnps);
19 
20   FUNCTION trkp_clc_days_ovrdue(
21     p_action_dt IN DATE ,
22     p_completion_dt IN DATE ,
23     p_business_days_ind IN VARCHAR2 DEFAULT 'N')
24   RETURN NUMBER;
25   PRAGMA restrict_references (trkp_clc_days_ovrdue, wnds,wnps);
26 
27   FUNCTION trkp_clc_dt_offset(
28     p_start_dt IN DATE ,
29     p_offset_days IN NUMBER ,
30     p_business_days_ind IN VARCHAR2 DEFAULT 'N'  ,
31     -- added for tracking dld nov2001 release (bug#1837257)
32     p_override_offset_clc_ind IN varchar2 DEFAULT 'N' )
33   RETURN DATE;
34   PRAGMA restrict_references (trkp_clc_dt_offset, wnds,wnps);
35 
36   FUNCTION trkp_clc_num_bus_day(
37     p_start_dt IN DATE ,
38     p_end_dt IN DATE ,
39     p_message_name OUT NOCOPY VARCHAR2 )
40   RETURN NUMBER;
41   PRAGMA restrict_references (trkp_clc_num_bus_day, wnds,wnps);
42 
43   FUNCTION trkp_clc_tri_cmp_dt(
44     p_tracking_id IN NUMBER ,
45     p_start_dt IN DATE )
46   RETURN DATE;
47   PRAGMA restrict_references (trkp_clc_tri_cmp_dt, wnds,wnps);
48 
49 END igs_tr_gen_001;