1 PACKAGE igs_pe_act_site_pkg AS
2 /* $Header: IGSNIA5S.pls 120.1 2006/02/17 06:55:40 gmaheswa noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_person_id IN NUMBER,
7 x_activity_site_cd IN VARCHAR2,
8 x_location_id IN NUMBER,
9 x_start_date IN DATE,
10 x_end_date IN DATE,
11 x_mode IN VARCHAR2 DEFAULT 'R' ,
12 x_remarks IN VARCHAR2,
13 x_primary_flag IN VARCHAR2 DEFAULT NULL
14 );
15
16 PROCEDURE lock_row (
17 x_rowid IN VARCHAR2,
18 x_person_id IN NUMBER,
19 x_activity_site_cd IN VARCHAR2,
20 x_location_id IN NUMBER,
21 x_start_date IN DATE,
22 x_end_date IN DATE,
23 x_remarks IN VARCHAR2
24 );
25
26 PROCEDURE update_row (
27 x_rowid IN VARCHAR2,
28 x_person_id IN NUMBER,
29 x_activity_site_cd IN VARCHAR2,
30 x_location_id IN NUMBER,
31 x_start_date IN DATE,
32 x_end_date IN DATE,
33 x_mode IN VARCHAR2 DEFAULT 'R' ,
34 x_remarks IN VARCHAR2,
35 x_primary_flag IN VARCHAR2 DEFAULT NULL
36 );
37
38 PROCEDURE add_row (
39 x_rowid IN OUT NOCOPY VARCHAR2,
40 x_person_id IN NUMBER,
41 x_activity_site_cd IN VARCHAR2,
42 x_location_id IN NUMBER,
43 x_start_date IN DATE,
44 x_end_date IN DATE,
45 x_mode IN VARCHAR2 DEFAULT 'R' ,
46 x_remarks IN VARCHAR2,
47 x_primary_flag IN VARCHAR2 DEFAULT NULL
48 );
49
50 PROCEDURE delete_row (
51 x_rowid IN VARCHAR2,
52 x_mode IN VARCHAR2 DEFAULT 'R'
53 );
54
55 FUNCTION get_pk_for_validation (
56 x_person_id IN NUMBER,
57 x_activity_site_cd IN VARCHAR2,
58 x_start_date IN DATE
59 ) RETURN BOOLEAN;
60
61 PROCEDURE get_fk_igs_ad_location (
62 x_location_cd IN VARCHAR2
63 );
64
65 PROCEDURE before_dml (
66 p_action IN VARCHAR2,
67 x_rowid IN VARCHAR2 DEFAULT NULL,
68 x_person_id IN NUMBER DEFAULT NULL,
69 x_activity_site_cd IN VARCHAR2 DEFAULT NULL,
70 x_location_id IN NUMBER DEFAULT NULL,
71 x_start_date IN DATE DEFAULT NULL,
72 x_end_date IN DATE DEFAULT NULL,
73 x_creation_date IN DATE DEFAULT NULL,
74 x_created_by IN NUMBER DEFAULT NULL,
75 x_last_update_date IN DATE DEFAULT NULL,
76 x_last_updated_by IN NUMBER DEFAULT NULL,
77 x_last_update_login IN NUMBER DEFAULT NULL,
78 x_remarks IN VARCHAR2 DEFAULT NULL,
79 x_primary_flag IN VARCHAR2 DEFAULT NULL
80 );
81
82 END igs_pe_act_site_pkg;