PACKAGE: APPS.IGS_PE_USR_ARG_PKG

Source

1 PACKAGE igs_pe_usr_arg_pkg AS
2 /* $Header: IGSNI82S.pls 120.1 2005/08/16 05:54:50 appldev ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_usr_act_re_gs_id                  IN OUT NOCOPY NUMBER,
7     x_person_type                       IN     VARCHAR2,
8     x_record_open_dt_alias              IN     VARCHAR2,
9     x_record_cutoff_dt_alias            IN     VARCHAR2,
10     x_grad_sch_dt_alias                 IN     VARCHAR2,
11     x_upd_audit_dt_alias                IN     VARCHAR2,
12     x_mode                              IN     VARCHAR2    DEFAULT 'R'
13   );
14 
15   PROCEDURE lock_row (
16     x_rowid                             IN     VARCHAR2,
17     x_usr_act_re_gs_id                  IN     NUMBER,
18     x_person_type                       IN     VARCHAR2,
19     x_record_open_dt_alias              IN     VARCHAR2,
20     x_record_cutoff_dt_alias            IN     VARCHAR2,
21     x_grad_sch_dt_alias                 IN     VARCHAR2,
22     x_upd_audit_dt_alias                IN     VARCHAR2
23   );
24 
25   PROCEDURE update_row (
26     x_rowid                             IN     VARCHAR2,
27     x_usr_act_re_gs_id                  IN     NUMBER,
28     x_person_type                       IN     VARCHAR2,
29     x_record_open_dt_alias              IN     VARCHAR2,
30     x_record_cutoff_dt_alias            IN     VARCHAR2,
31     x_grad_sch_dt_alias                 IN     VARCHAR2,
32     x_upd_audit_dt_alias                IN     VARCHAR2,
33     x_mode                              IN     VARCHAR2    DEFAULT 'R'
34   );
35 
36   PROCEDURE add_row (
37     x_rowid                             IN OUT NOCOPY VARCHAR2,
38     x_usr_act_re_gs_id                  IN OUT NOCOPY NUMBER,
39     x_person_type                       IN     VARCHAR2,
40     x_record_open_dt_alias              IN     VARCHAR2,
41     x_record_cutoff_dt_alias            IN     VARCHAR2,
42     x_grad_sch_dt_alias                 IN     VARCHAR2,
43     x_upd_audit_dt_alias                IN     VARCHAR2,
44     x_mode                              IN     VARCHAR2    DEFAULT 'R'
45   );
46 
47   PROCEDURE delete_row (
48     x_rowid                             IN     VARCHAR2
49   );
50 
51   FUNCTION get_pk_for_validation (
52     x_usr_act_re_gs_id                  IN     NUMBER
53   ) RETURN BOOLEAN;
54 
55   FUNCTION get_uk_for_validation (
56     x_person_type                       IN     VARCHAR2
57   ) RETURN BOOLEAN;
58 
59   PROCEDURE get_fk_igs_pe_person_types (
60     x_person_type_code                  IN     VARCHAR2
61   );
62 
63   PROCEDURE before_dml (
64     p_action                            IN     VARCHAR2,
65     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
66     x_usr_act_re_gs_id                  IN     NUMBER      DEFAULT NULL,
67     x_person_type                       IN     VARCHAR2    DEFAULT NULL,
68     x_record_open_dt_alias              IN     VARCHAR2    DEFAULT NULL,
69     x_record_cutoff_dt_alias            IN     VARCHAR2    DEFAULT NULL,
70     x_grad_sch_dt_alias                 IN     VARCHAR2    DEFAULT NULL,
71     x_upd_audit_dt_alias                IN     VARCHAR2    DEFAULT NULL,
72     x_creation_date                     IN     DATE        DEFAULT NULL,
73     x_created_by                        IN     NUMBER      DEFAULT NULL,
74     x_last_update_date                  IN     DATE        DEFAULT NULL,
75     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
76     x_last_update_login                 IN     NUMBER      DEFAULT NULL
77   );
78 
79 END igs_pe_usr_arg_pkg;