PACKAGE: APPS.IGS_CO_TYPE_PKG

Source

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