PACKAGE: APPS.IGS_TR_TYPE_PKG

Source

1 PACKAGE igs_tr_type_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSTI05S.pls 115.7 2003/02/19 10:26:05 kpadiyar ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid IN OUT NOCOPY VARCHAR2,
6     x_tracking_type IN VARCHAR2,
7     x_description IN VARCHAR2,
8     x_s_tracking_type IN VARCHAR2,
9     x_target_days IN NUMBER,
10     x_sequence_ind IN VARCHAR2,
11     x_business_days_ind IN VARCHAR2,
12     x_closed_ind IN VARCHAR2,
13     x_publish_ind IN VARCHAR2 DEFAULT 'N',
14     x_mode IN VARCHAR2 DEFAULT 'R',
15     x_org_id IN NUMBER
16   );
17 
18   PROCEDURE lock_row (
19     x_rowid IN VARCHAR2,
20     x_tracking_type IN VARCHAR2,
21     x_description IN VARCHAR2,
22     x_s_tracking_type IN VARCHAR2,
23     x_target_days IN NUMBER,
24     x_sequence_ind IN VARCHAR2,
25     x_business_days_ind IN VARCHAR2,
26     x_closed_ind IN VARCHAR2,
27     x_publish_ind IN VARCHAR2 DEFAULT 'N'
28   );
29 
30   PROCEDURE update_row (
31     x_rowid IN VARCHAR2,
32     x_tracking_type IN VARCHAR2,
33     x_description IN VARCHAR2,
34     x_s_tracking_type IN VARCHAR2,
35     x_target_days IN NUMBER,
36     x_sequence_ind IN VARCHAR2,
37     x_business_days_ind IN VARCHAR2,
38     x_closed_ind IN VARCHAR2,
39     x_publish_ind IN VARCHAR2 DEFAULT 'N',
40     x_mode IN VARCHAR2 DEFAULT 'R'
41   );
42 
43   PROCEDURE add_row (
44     x_rowid IN OUT NOCOPY VARCHAR2,
45     x_tracking_type IN VARCHAR2,
46     x_description IN VARCHAR2,
47     x_s_tracking_type IN VARCHAR2,
48     x_target_days IN NUMBER,
49     x_sequence_ind IN VARCHAR2,
50     x_business_days_ind IN VARCHAR2,
51     x_closed_ind IN VARCHAR2,
52     x_publish_ind IN VARCHAR2 DEFAULT 'N',
53     x_mode IN VARCHAR2 DEFAULT 'R',
54     x_org_id IN NUMBER
55   );
56 
57   FUNCTION get_pk_for_validation (
58     x_tracking_type IN VARCHAR2
59   )RETURN BOOLEAN;
60 
61   PROCEDURE get_fk_igs_lookups_view(
62     x_s_tracking_type IN VARCHAR2
63   );
64 
65   -- added to take care of check constraints
66   PROCEDURE check_constraints(
67     column_name IN VARCHAR2 DEFAULT NULL,
68     column_value IN VARCHAR2 DEFAULT NULL
69   );
70 
71   PROCEDURE before_dml (
72     p_action IN VARCHAR2,
73     x_rowid IN VARCHAR2 DEFAULT NULL,
74     x_tracking_type IN VARCHAR2 DEFAULT NULL,
75     x_description IN VARCHAR2 DEFAULT NULL,
76     x_s_tracking_type IN VARCHAR2 DEFAULT NULL,
77     x_target_days IN NUMBER DEFAULT NULL,
78     x_sequence_ind IN VARCHAR2 DEFAULT NULL,
79     x_business_days_ind IN VARCHAR2 DEFAULT NULL,
80     x_closed_ind IN VARCHAR2 DEFAULT NULL,
81     x_publish_ind IN VARCHAR2 DEFAULT NULL,
82     x_creation_date IN DATE DEFAULT NULL,
83     x_created_by IN NUMBER DEFAULT NULL,
84     x_last_update_date IN DATE DEFAULT NULL,
85     x_last_updated_by IN NUMBER DEFAULT NULL,
86     x_last_update_login IN NUMBER DEFAULT NULL,
87     x_org_id IN NUMBER DEFAULT NULL
88   );
89 
90 END igs_tr_type_pkg;