PACKAGE: APPS.IGS_TR_TYPE_STEP_PKG

Source

1 PACKAGE igs_tr_type_step_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSTI06S.pls 115.9 2003/02/19 12:30:52 kpadiyar 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_tracking_type_step_number IN NUMBER,
9     x_description IN VARCHAR2,
10     x_s_tracking_step_type IN VARCHAR2,
11     x_action_days IN NUMBER,
12     x_recipient_id IN NUMBER,
13     x_step_group_id IN NUMBER DEFAULT NULL,
14     x_publish_ind IN VARCHAR2 DEFAULT 'N',
15     x_step_catalog_cd IN VARCHAR2 DEFAULT NULL,
16     x_mode IN VARCHAR2 DEFAULT 'R',
17     x_org_id IN NUMBER
18   );
19 
20   PROCEDURE lock_row (
21     x_rowid IN VARCHAR2,
22     x_tracking_type IN VARCHAR2,
23     x_tracking_type_step_id IN NUMBER,
24     x_tracking_type_step_number IN NUMBER,
25     x_description IN VARCHAR2,
26     x_s_tracking_step_type IN VARCHAR2,
27     x_action_days IN NUMBER,
28     x_recipient_id IN NUMBER,
29     x_step_group_id IN NUMBER DEFAULT NULL,
30     x_publish_ind IN VARCHAR2 DEFAULT 'N',
31     x_step_catalog_cd IN VARCHAR2 DEFAULT NULL
32   );
33 
34   PROCEDURE update_row (
35     x_rowid IN VARCHAR2,
36     x_tracking_type IN VARCHAR2,
37     x_tracking_type_step_id IN NUMBER,
38     x_tracking_type_step_number IN NUMBER,
39     x_description IN VARCHAR2,
40     x_s_tracking_step_type IN VARCHAR2,
41     x_action_days IN NUMBER,
42     x_recipient_id IN NUMBER,
43     x_step_group_id IN NUMBER DEFAULT NULL,
44     x_publish_ind IN VARCHAR2 DEFAULT 'N',
45     x_step_catalog_cd IN VARCHAR2 DEFAULT NULL,
46     x_mode IN VARCHAR2 DEFAULT 'R'
47   );
48 
49   PROCEDURE add_row (
50     x_rowid IN OUT NOCOPY VARCHAR2,
51     x_tracking_type IN VARCHAR2,
52     x_tracking_type_step_id IN NUMBER,
53     x_tracking_type_step_number IN NUMBER,
54     x_description IN VARCHAR2,
55     x_s_tracking_step_type IN VARCHAR2,
56     x_action_days IN NUMBER,
57     x_recipient_id IN NUMBER,
58     x_step_group_id IN NUMBER DEFAULT NULL,
59     x_publish_ind IN VARCHAR2 DEFAULT 'N',
60     x_step_catalog_cd IN VARCHAR2 DEFAULT NULL,
61     x_mode IN VARCHAR2 DEFAULT 'R',
62     x_org_id IN NUMBER
63   );
64 
65   PROCEDURE delete_row (
66     x_rowid IN VARCHAR2
67   );
68 
69   FUNCTION get_pk_for_validation (
70     x_tracking_type IN VARCHAR2,
71     x_tracking_type_step_id IN NUMBER
72   )RETURN BOOLEAN ;
73 
74   PROCEDURE get_fk_igs_pe_person (
75     x_person_id IN NUMBER
76   );
77 
78   PROCEDURE get_fk_igs_lookups_view(
79     x_s_tracking_step_type IN VARCHAR2
80   );
81 
82   -- added to take care of check constraints
83   PROCEDURE check_constraints(
84     column_name IN VARCHAR2 DEFAULT NULL,
85     column_value IN VARCHAR2 DEFAULT NULL
86   );
87 
88   PROCEDURE before_dml (
89     p_action IN VARCHAR2,
90     x_rowid IN VARCHAR2 DEFAULT NULL,
91     x_tracking_type IN VARCHAR2 DEFAULT NULL,
92     x_tracking_type_step_id IN NUMBER DEFAULT NULL,
93     x_tracking_type_step_number IN NUMBER DEFAULT NULL,
94     x_description IN VARCHAR2 DEFAULT NULL,
95     x_action_days IN NUMBER DEFAULT NULL,
96     x_recipient_id IN NUMBER DEFAULT NULL,
97     x_s_tracking_step_type IN VARCHAR2 DEFAULT NULL,
98     x_step_group_id IN NUMBER DEFAULT NULL,
99     x_publish_ind IN VARCHAR2 DEFAULT NULL,
100     x_step_catalog_cd IN VARCHAR2 DEFAULT NULL,
101     x_creation_date IN DATE DEFAULT NULL,
102     x_created_by IN NUMBER DEFAULT NULL,
103     x_last_update_date IN DATE DEFAULT NULL,
104     x_last_updated_by IN NUMBER DEFAULT NULL,
105     x_last_update_login IN NUMBER DEFAULT NULL,
106     x_org_id IN NUMBER DEFAULT NULL
107   );
108 
109 END igs_tr_type_step_pkg;