PACKAGE: APPS.IGS_UC_MAP_OUT_STAT_PKG

Source

1 PACKAGE igs_uc_map_out_stat_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSXI45S.pls 115.2 2002/11/29 04:57:53 nsidana noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_system_code                       IN     VARCHAR2,
7     x_decision_code                     IN     VARCHAR2,
8     x_adm_outcome_status                IN     VARCHAR2,
9     x_default_ind                       IN     VARCHAR2,
10     x_closed_ind                        IN     VARCHAR2,
11     x_mode                              IN     VARCHAR2    DEFAULT 'R'
12   );
13 
14   PROCEDURE lock_row (
15     x_rowid                             IN     VARCHAR2,
16     x_system_code                       IN     VARCHAR2,
17     x_decision_code                     IN     VARCHAR2,
18     x_adm_outcome_status                IN     VARCHAR2,
19     x_default_ind                       IN     VARCHAR2,
20     x_closed_ind                        IN     VARCHAR2
21   );
22 
23   PROCEDURE update_row (
24     x_rowid                             IN     VARCHAR2,
25     x_system_code                       IN     VARCHAR2,
26     x_decision_code                     IN     VARCHAR2,
27     x_adm_outcome_status                IN     VARCHAR2,
28     x_default_ind                       IN     VARCHAR2,
29     x_closed_ind                        IN     VARCHAR2,
30     x_mode                              IN     VARCHAR2    DEFAULT 'R'
31   );
32 
33   PROCEDURE add_row (
34     x_rowid                             IN OUT NOCOPY VARCHAR2,
35     x_system_code                       IN     VARCHAR2,
36     x_decision_code                     IN     VARCHAR2,
37     x_adm_outcome_status                IN     VARCHAR2,
38     x_default_ind                       IN     VARCHAR2,
39     x_closed_ind                        IN     VARCHAR2,
40     x_mode                              IN     VARCHAR2    DEFAULT 'R'
41   );
42 
43   PROCEDURE delete_row (
44     x_rowid                             IN     VARCHAR2
45   );
46 
47   FUNCTION get_pk_for_validation (
48     x_system_code                       IN     VARCHAR2,
49     x_decision_code                     IN     VARCHAR2,
50     x_adm_outcome_status                IN     VARCHAR2
51   ) RETURN BOOLEAN;
52 
53   FUNCTION get_uk_for_validation (
54     x_system_code                       IN     VARCHAR2,
55     x_adm_outcome_status                IN     VARCHAR2
56   ) RETURN BOOLEAN;
57 
58   PROCEDURE get_fk_igs_uc_sys_decision (
59     x_system_code                       IN     VARCHAR2,
60     x_decision_code                     IN     VARCHAR2
61   );
62 
63   PROCEDURE get_fk_igs_ad_ou_stat (
64     x_adm_outcome_status                IN     VARCHAR2
65   );
66 
67   PROCEDURE before_dml (
68     p_action                            IN     VARCHAR2,
69     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
70     x_system_code                       IN     VARCHAR2    DEFAULT NULL,
71     x_decision_code                     IN     VARCHAR2    DEFAULT NULL,
72     x_adm_outcome_status                IN     VARCHAR2    DEFAULT NULL,
73     x_default_ind                       IN     VARCHAR2    DEFAULT NULL,
74     x_closed_ind                        IN     VARCHAR2    DEFAULT NULL,
75     x_creation_date                     IN     DATE        DEFAULT NULL,
76     x_created_by                        IN     NUMBER      DEFAULT NULL,
77     x_last_update_date                  IN     DATE        DEFAULT NULL,
78     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
79     x_last_update_login                 IN     NUMBER      DEFAULT NULL
80   );
81 
82 END igs_uc_map_out_stat_pkg;