DBA Data[Home] [Help]

PACKAGE: APPS.IGS_PE_HOLD_REL_OVR_PKG

Source


1 PACKAGE igs_pe_hold_rel_ovr_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSNI85S.pls 115.4 2002/11/29 01:33:54 nsidana ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_hold_rel_ovr_id                   IN OUT NOCOPY NUMBER,
7     x_elgb_override_id                  IN     NUMBER,
8     x_hold_type                         IN     VARCHAR2,
9     x_hold_rel_or_ovr                   IN     VARCHAR2,
10     x_hold_old_end_dt                   IN     DATE,
11     x_action_dt                         IN     DATE,
12     x_start_date                        IN     DATE,
13     x_mode                              IN     VARCHAR2    DEFAULT 'R'
14   );
15 
16   PROCEDURE lock_row (
17     x_rowid                             IN     VARCHAR2,
18     x_hold_rel_ovr_id                   IN     NUMBER,
19     x_elgb_override_id                  IN     NUMBER,
20     x_hold_type                         IN     VARCHAR2,
21     x_hold_rel_or_ovr                   IN     VARCHAR2,
22     x_hold_old_end_dt                   IN     DATE,
23     x_action_dt                         IN     DATE,
24     x_start_date                        IN     DATE
25   );
26 
27   PROCEDURE update_row (
28     x_rowid                             IN     VARCHAR2,
29     x_hold_rel_ovr_id                   IN     NUMBER,
30     x_elgb_override_id                  IN     NUMBER,
31     x_hold_type                         IN     VARCHAR2,
32     x_hold_rel_or_ovr                   IN     VARCHAR2,
33     x_hold_old_end_dt                   IN     DATE,
34     x_action_dt                         IN     DATE,
35     x_start_date                        IN     DATE,
36     x_mode                              IN     VARCHAR2    DEFAULT 'R'
37   );
38 
39   PROCEDURE add_row (
40     x_rowid                             IN OUT NOCOPY VARCHAR2,
41     x_hold_rel_ovr_id                   IN OUT NOCOPY NUMBER,
42     x_elgb_override_id                  IN     NUMBER,
43     x_hold_type                         IN     VARCHAR2,
44     x_hold_rel_or_ovr                   IN     VARCHAR2,
45     x_hold_old_end_dt                   IN     DATE,
46     x_action_dt                         IN     DATE,
47     x_start_date                        IN     DATE,
48     x_mode                              IN     VARCHAR2    DEFAULT 'R'
49   );
50 
51   PROCEDURE delete_row (
52     x_rowid                             IN     VARCHAR2
53   );
54 
55   FUNCTION get_pk_for_validation (
56     x_hold_rel_ovr_id                   IN     NUMBER
57   ) RETURN BOOLEAN;
58 
59   FUNCTION get_uk_for_validation (
60     x_elgb_override_id                  IN     NUMBER,
61     x_hold_type                         IN     VARCHAR2,
62     x_start_date                        IN     DATE
63   ) RETURN BOOLEAN;
64 
65   PROCEDURE get_fk_igs_en_elgb_ovr (
66     x_elgb_override_id                  IN     NUMBER
67   );
68 
69   PROCEDURE get_fk_igs_fi_encmb_type (
70     x_encumbrance_type                  IN     VARCHAR2
71   );
72 
73   PROCEDURE before_dml (
74     p_action                            IN     VARCHAR2,
75     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
76     x_hold_rel_ovr_id                   IN     NUMBER      DEFAULT NULL,
77     x_elgb_override_id                  IN     NUMBER      DEFAULT NULL,
78     x_hold_type                         IN     VARCHAR2    DEFAULT NULL,
79     x_hold_rel_or_ovr                   IN     VARCHAR2    DEFAULT NULL,
80     x_hold_old_end_dt                   IN     DATE        DEFAULT NULL,
81     x_action_dt                         IN     DATE        DEFAULT NULL,
82     x_start_date                        IN     DATE        DEFAULT NULL,
83     x_creation_date                     IN     DATE        DEFAULT NULL,
84     x_created_by                        IN     NUMBER      DEFAULT NULL,
85     x_last_update_date                  IN     DATE        DEFAULT NULL,
86     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
87     x_last_update_login                 IN     NUMBER      DEFAULT NULL
88   );
89 
90 END igs_pe_hold_rel_ovr_pkg;