PACKAGE: APPS.IGS_CO_S_LTR_PR_RSTN_PKG

Source

1 PACKAGE igs_co_s_ltr_pr_rstn_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSLI20S.pls 115.5 2002/11/29 01:07:17 nsidana ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_s_letter_parameter_type           IN     VARCHAR2,
7     x_correspondence_type               IN     VARCHAR2,
8     x_mode                              IN     VARCHAR2    DEFAULT 'R'
9   );
10 
11   PROCEDURE lock_row (
12     x_rowid                             IN     VARCHAR2,
13     x_s_letter_parameter_type           IN     VARCHAR2,
14     x_correspondence_type               IN     VARCHAR2
15   );
16 
17   PROCEDURE delete_row (
18     x_rowid                             IN     VARCHAR2
19   );
20 
21   FUNCTION get_pk_for_validation (
22     x_s_letter_parameter_type           IN     VARCHAR2,
23     x_correspondence_type               IN     VARCHAR2
24   ) RETURN BOOLEAN;
25 
26   PROCEDURE get_fk_igs_co_type (
27     x_correspondence_type               IN     VARCHAR2
28   );
29 
30   PROCEDURE get_fk_igs_co_s_ltr_param (
31     x_s_letter_parameter_type           IN     VARCHAR2
32   );
33 
34   PROCEDURE before_dml (
35     p_action                            IN     VARCHAR2,
36     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
37     x_s_letter_parameter_type           IN     VARCHAR2    DEFAULT NULL,
38     x_correspondence_type               IN     VARCHAR2    DEFAULT NULL,
39     x_creation_date                     IN     DATE        DEFAULT NULL,
40     x_created_by                        IN     NUMBER      DEFAULT NULL,
41     x_last_update_date                  IN     DATE        DEFAULT NULL,
42     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
43     x_last_update_login                 IN     NUMBER      DEFAULT NULL
44   );
45 
46 END igs_co_s_ltr_pr_rstn_pkg;