PACKAGE: APPS.IGS_AD_DEPLVL_PRGTY_PKG

Source

1 PACKAGE igs_ad_deplvl_prgty_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAIG7S.pls 115.4 2003/10/30 13:18:01 akadam noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_admission_application_type        IN     VARCHAR2,
7     x_program_type                      IN     VARCHAR2,
8     x_closed_ind                        IN     VARCHAR2,
9     x_mode                              IN     VARCHAR2    DEFAULT 'R'
10   );
11 
12   PROCEDURE lock_row (
13     x_rowid                             IN     VARCHAR2,
14     x_admission_application_type        IN     VARCHAR2,
15     x_program_type                      IN     VARCHAR2,
16     x_closed_ind                        IN     VARCHAR2
17   );
18 
19   PROCEDURE update_row (
20     x_rowid                             IN     VARCHAR2,
21     x_admission_application_type        IN     VARCHAR2,
22     x_program_type                      IN     VARCHAR2,
23     x_closed_ind                        IN     VARCHAR2,
24     x_mode                              IN     VARCHAR2    DEFAULT 'R'
25   );
26 
27   PROCEDURE add_row (
28     x_rowid                             IN OUT NOCOPY VARCHAR2,
29     x_admission_application_type        IN     VARCHAR2,
30     x_program_type                      IN     VARCHAR2,
31     x_closed_ind                        IN     VARCHAR2,
32     x_mode                              IN     VARCHAR2    DEFAULT 'R'
33   );
34 
35   PROCEDURE delete_row (
36     x_rowid                             IN     VARCHAR2
37   );
38 
39   FUNCTION get_pk_for_validation (
40     x_admission_application_type        IN     VARCHAR2,
41     x_program_type                      IN     VARCHAR2 ,
42     x_closed_ind                        IN VARCHAR2 DEFAULT NULL
43   ) RETURN BOOLEAN;
44 
45   PROCEDURE get_fk_igs_ad_ss_appl_typ (
46     x_admission_application_type        IN     VARCHAR2
47   );
48 
49   PROCEDURE before_dml (
50     p_action                            IN     VARCHAR2,
51     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
52     x_admission_application_type        IN     VARCHAR2    DEFAULT NULL,
53     x_program_type                      IN     VARCHAR2    DEFAULT NULL,
54     x_closed_ind                        IN     VARCHAR2    DEFAULT NULL,
55     x_creation_date                     IN     DATE        DEFAULT NULL,
56     x_created_by                        IN     NUMBER      DEFAULT NULL,
57     x_last_update_date                  IN     DATE        DEFAULT NULL,
58     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
59     x_last_update_login                 IN     NUMBER      DEFAULT NULL
60   );
61 
62 END igs_ad_deplvl_prgty_pkg;