PACKAGE: APPS.IGS_TR_GROUP_PKG

Source

1 PACKAGE igs_tr_group_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSTI09S.pls 115.5 2002/11/29 04:16:18 nsidana ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid IN OUT NOCOPY VARCHAR2,
6     x_tracking_group_id IN NUMBER,
7     x_description IN VARCHAR2,
8     x_mode IN VARCHAR2 DEFAULT 'R',
9     x_org_id IN NUMBER
10   );
11 
12   PROCEDURE lock_row (
13     x_rowid IN VARCHAR2,
14     x_tracking_group_id IN NUMBER,
15     x_description IN VARCHAR2
16   );
17 
18   PROCEDURE update_row (
19     x_rowid IN VARCHAR2,
20     x_tracking_group_id IN NUMBER,
21     x_description IN VARCHAR2,
22     x_mode IN VARCHAR2 DEFAULT 'R'
23   );
24 
25   PROCEDURE add_row (
26     x_rowid IN OUT NOCOPY VARCHAR2,
27     x_tracking_group_id IN NUMBER,
28     x_description IN VARCHAR2,
29     x_mode IN VARCHAR2 DEFAULT 'R',
30     x_org_id IN NUMBER
31   );
32 
33   PROCEDURE delete_row (
34     x_rowid IN VARCHAR2
35   );
36 
37   FUNCTION get_pk_for_validation (
38     x_tracking_group_id IN NUMBER
39   )RETURN BOOLEAN;
40 
41   PROCEDURE check_constraints(
42     column_name  IN VARCHAR2 DEFAULT NULL,
43     column_value  IN VARCHAR2 DEFAULT NULL
44   );
45 
46   PROCEDURE before_dml (
47     p_action IN VARCHAR2,
48     x_rowid IN VARCHAR2 DEFAULT NULL,
49     x_tracking_group_id IN NUMBER DEFAULT NULL,
50     x_description IN VARCHAR2 DEFAULT NULL,
51     x_creation_date IN DATE DEFAULT NULL,
52     x_created_by IN NUMBER DEFAULT NULL,
53     x_last_update_date IN DATE DEFAULT NULL,
54     x_last_updated_by IN NUMBER DEFAULT NULL,
55     x_last_update_login IN NUMBER DEFAULT NULL,
56     x_org_id IN NUMBER DEFAULT NULL
57   );
58 
59 END igs_tr_group_pkg;