PACKAGE: APPS.IGS_TR_GROUP_MEMBER_PKG

Source

1 PACKAGE igs_tr_group_member_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSTI10S.pls 115.5 2002/11/29 04:16:34 nsidana ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid IN OUT NOCOPY VARCHAR2,
6     x_tracking_group_id IN NUMBER,
7     x_tracking_id IN NUMBER,
8     x_mode IN VARCHAR2 DEFAULT 'R'
9   );
10 
11   PROCEDURE lock_row (
12     x_rowid IN VARCHAR2,
13     x_tracking_group_id IN NUMBER,
14     x_tracking_id IN NUMBER
15   );
16 
17   PROCEDURE delete_row (
18     x_rowid IN VARCHAR2
19   );
20 
21   FUNCTION get_pk_for_validation (
22     x_tracking_group_id IN NUMBER,
23     x_tracking_id IN NUMBER
24   )RETURN BOOLEAN;
25 
26   PROCEDURE before_dml (
27     p_action IN VARCHAR2,
28     x_rowid IN VARCHAR2 DEFAULT NULL,
29     x_tracking_group_id IN NUMBER DEFAULT NULL,
30     x_tracking_id IN NUMBER DEFAULT NULL,
31     x_creation_date IN DATE DEFAULT NULL,
32     x_created_by IN NUMBER DEFAULT NULL,
33     x_last_update_date IN DATE DEFAULT NULL,
34     x_last_updated_by IN NUMBER DEFAULT NULL,
35     x_last_update_login IN NUMBER DEFAULT NULL
36   );
37 
38   PROCEDURE get_fk_igs_tr_group (
39     x_tracking_group_id IN NUMBER
40   );
41 
42   PROCEDURE get_fk_igs_tr_item (
43     x_tracking_id IN NUMBER
44     );
45 
46 END igs_tr_group_member_pkg;