PACKAGE: APPS.IGS_AD_RECRUIT_PI_PKG

Source

1 PACKAGE igs_ad_recruit_pi_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAIE5S.pls 115.5 2002/11/28 22:33:08 nsidana ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_probability_index_id              IN OUT NOCOPY NUMBER,
7     x_person_id                         IN     NUMBER,
8     x_probability_type_code_id          IN     NUMBER,
9     x_calculation_date                  IN     DATE,
10     x_probability_value                 IN     NUMBER,
11     x_probability_source_code_id        IN     NUMBER,
12     x_mode                              IN     VARCHAR2    DEFAULT 'R'
13   );
14 
15   PROCEDURE lock_row (
16     x_rowid                             IN     VARCHAR2,
17     x_probability_index_id              IN     NUMBER,
18     x_person_id                         IN     NUMBER,
19     x_probability_type_code_id          IN     NUMBER,
20     x_calculation_date                  IN     DATE,
21     x_probability_value                 IN     NUMBER,
22     x_probability_source_code_id        IN     NUMBER
23   );
24 
25   PROCEDURE update_row (
26     x_rowid                             IN     VARCHAR2,
27     x_probability_index_id              IN     NUMBER,
28     x_person_id                         IN     NUMBER,
29     x_probability_type_code_id          IN     NUMBER,
30     x_calculation_date                  IN     DATE,
31     x_probability_value                 IN     NUMBER,
32     x_probability_source_code_id        IN     NUMBER,
33     x_mode                              IN     VARCHAR2    DEFAULT 'R'
34   );
35 
36   PROCEDURE add_row (
37     x_rowid                             IN OUT NOCOPY VARCHAR2,
38     x_probability_index_id              IN OUT NOCOPY NUMBER,
39     x_person_id                         IN     NUMBER,
40     x_probability_type_code_id          IN     NUMBER,
41     x_calculation_date                  IN     DATE,
42     x_probability_value                 IN     NUMBER,
43     x_probability_source_code_id        IN     NUMBER,
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_probability_index_id              IN     NUMBER
53   ) RETURN BOOLEAN;
54 
55   FUNCTION get_uk_for_validation (
56     x_probability_type_code_id          IN     NUMBER,
57     x_calculation_date                  IN     DATE,
58     x_person_id                         IN     NUMBER
59   ) RETURN BOOLEAN;
60 
61   PROCEDURE Check_Constraints (
62     Column_Name IN VARCHAR2  DEFAULT NULL,
63     Column_Value IN VARCHAR2  DEFAULT NULL ) ;
64 
65   PROCEDURE get_fk_igs_pe_person (
66     x_party_id                          IN     NUMBER
67   );
68 
69   PROCEDURE get_fk_igs_ad_code_classes (
70     x_code_id                           IN     NUMBER
71   );
72 
73   PROCEDURE before_dml (
74     p_action                            IN     VARCHAR2,
75     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
76     x_probability_index_id              IN     NUMBER      DEFAULT NULL,
77     x_person_id                         IN     NUMBER      DEFAULT NULL,
78     x_probability_type_code_id          IN     NUMBER      DEFAULT NULL,
79     x_calculation_date                  IN     DATE        DEFAULT NULL,
80     x_probability_value                 IN     NUMBER      DEFAULT NULL,
81     x_probability_source_code_id        IN     NUMBER      DEFAULT NULL,
82     x_creation_date                     IN     DATE        DEFAULT NULL,
83     x_created_by                        IN     NUMBER      DEFAULT NULL,
84     x_last_update_date                  IN     DATE        DEFAULT NULL,
85     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
86     x_last_update_login                 IN     NUMBER      DEFAULT NULL
87   );
88 
89 END igs_ad_recruit_pi_pkg;