PACKAGE: APPS.IGS_CO_LTR_PARAM_PKG

Source

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