PACKAGE: APPS.IGS_CO_LTR_RPT_GRP_PKG

Source

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