DBA Data[Home] [Help]

PACKAGE: APPS.IGS_PR_CS_SCHDL_PKG

Source


1 PACKAGE igs_pr_cs_schdl_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSQI30S.pls 115.6 2003/06/05 13:06:24 sarakshi ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_igs_pr_cs_schdl_id                IN OUT NOCOPY NUMBER,
7     x_course_type                       IN     VARCHAR2,
8     x_consider_changes                  IN     VARCHAR2,
9     x_start_dt                          IN     DATE,
10     x_end_dt                            IN     DATE,
11     x_mode                              IN     VARCHAR2    DEFAULT 'R'
12   );
13 
14   PROCEDURE lock_row (
15     x_rowid                             IN     VARCHAR2,
16     x_igs_pr_cs_schdl_id                IN     NUMBER,
17     x_course_type                       IN     VARCHAR2,
18     x_consider_changes                  IN     VARCHAR2,
19     x_start_dt                          IN     DATE,
20     x_end_dt                            IN     DATE
21   );
22 
23   PROCEDURE update_row (
24     x_rowid                             IN     VARCHAR2,
25     x_igs_pr_cs_schdl_id                IN     NUMBER,
26     x_course_type                       IN     VARCHAR2,
27     x_consider_changes                  IN     VARCHAR2,
28     x_start_dt                          IN     DATE,
29     x_end_dt                            IN     DATE,
30     x_mode                              IN     VARCHAR2    DEFAULT 'R'
31   );
32 
33   PROCEDURE add_row (
34     x_rowid                             IN OUT NOCOPY VARCHAR2,
35     x_igs_pr_cs_schdl_id                IN OUT NOCOPY NUMBER,
36     x_course_type                       IN     VARCHAR2,
37     x_consider_changes                  IN     VARCHAR2,
38     x_start_dt                          IN     DATE,
39     x_end_dt                            IN     DATE,
40     x_mode                              IN     VARCHAR2    DEFAULT 'R'
41   );
42 
43   PROCEDURE delete_row (
44     x_rowid                             IN     VARCHAR2
45   );
46 
47   FUNCTION get_pk_for_validation (
48     x_igs_pr_cs_schdl_id                IN     NUMBER
49   ) RETURN BOOLEAN;
50 
51   FUNCTION get_uk_for_validation (
52     x_start_dt                          IN     DATE,
53     x_course_type                       IN     VARCHAR2
54   ) RETURN BOOLEAN;
55 
56   PROCEDURE before_dml (
57     p_action                            IN     VARCHAR2,
58     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
59     x_igs_pr_cs_schdl_id                IN     NUMBER      DEFAULT NULL,
60     x_course_type                       IN     VARCHAR2    DEFAULT NULL,
61     x_consider_changes                  IN     VARCHAR2    DEFAULT NULL,
62     x_start_dt                          IN     DATE        DEFAULT NULL,
63     x_end_dt                            IN     DATE        DEFAULT NULL,
64     x_creation_date                     IN     DATE        DEFAULT NULL,
65     x_created_by                        IN     NUMBER      DEFAULT NULL,
66     x_last_update_date                  IN     DATE        DEFAULT NULL,
67     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
68     x_last_update_login                 IN     NUMBER      DEFAULT NULL
69   );
70 
71 END igs_pr_cs_schdl_pkg;