DBA Data[Home] [Help]

PACKAGE: APPS.IGS_PE_ATHLETIC_DTL_PKG

Source


1 PACKAGE igs_pe_athletic_dtl_pkg AS
2 /* $Header: IGSNI95S.pls 120.0 2005/06/01 20:12:40 appldev noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_athletic_details_id               IN OUT NOCOPY NUMBER,
7     x_person_id                         IN     NUMBER,
8     x_athletic_gpa                      IN     NUMBER,
9     x_eligibility_status_cd             IN     VARCHAR2,
10     x_predict_elig_code                 IN     VARCHAR2,
11     x_tentative_adm_code                IN     VARCHAR2,
12     x_review_date                       IN     DATE,
13     x_comments                          IN     VARCHAR2,
14     x_mode                              IN     VARCHAR2    DEFAULT 'R'
15   );
16 
17   PROCEDURE lock_row (
18     x_rowid                             IN     VARCHAR2,
19     x_athletic_details_id               IN     NUMBER,
20     x_person_id                         IN     NUMBER,
21     x_athletic_gpa                      IN     NUMBER,
22     x_eligibility_status_cd             IN     VARCHAR2,
23     x_predict_elig_code                 IN     VARCHAR2,
24     x_tentative_adm_code                IN     VARCHAR2,
25     x_review_date                       IN     DATE,
26     x_comments                          IN     VARCHAR2
27   );
28 
29   PROCEDURE update_row (
30     x_rowid                             IN     VARCHAR2,
31     x_athletic_details_id               IN     NUMBER,
32     x_person_id                         IN     NUMBER,
33     x_athletic_gpa                      IN     NUMBER,
34     x_eligibility_status_cd             IN     VARCHAR2,
35     x_predict_elig_code                 IN     VARCHAR2,
36     x_tentative_adm_code                IN     VARCHAR2,
37     x_review_date                       IN     DATE,
38     x_comments                          IN     VARCHAR2,
39     x_mode                              IN     VARCHAR2    DEFAULT 'R'
40   );
41 
42   PROCEDURE add_row (
43     x_rowid                             IN OUT NOCOPY VARCHAR2,
44     x_athletic_details_id               IN OUT NOCOPY NUMBER,
45     x_person_id                         IN     NUMBER,
46     x_athletic_gpa                      IN     NUMBER,
47     x_eligibility_status_cd             IN     VARCHAR2,
48     x_predict_elig_code                 IN     VARCHAR2,
49     x_tentative_adm_code                IN     VARCHAR2,
50     x_review_date                       IN     DATE,
51     x_comments                          IN     VARCHAR2,
52     x_mode                              IN     VARCHAR2    DEFAULT 'R'
53   );
54 
55   PROCEDURE delete_row (
56     x_rowid                             IN     VARCHAR2,
57   x_mode IN VARCHAR2 DEFAULT 'R'
58   );
59 
60   FUNCTION get_pk_for_validation (
61     x_athletic_details_id               IN     NUMBER
62   ) RETURN BOOLEAN;
63 
64   FUNCTION get_uk_for_validation (
65     x_person_id                         IN     NUMBER
66   ) RETURN BOOLEAN;
67 
68   PROCEDURE get_fk_igs_ad_code_classes (
69     x_code_id                           IN     VARCHAR2
70   );
71 
72   PROCEDURE get_fk_hz_parties (
73     x_party_id                          IN     NUMBER
74   );
75 
76   PROCEDURE before_dml (
77     p_action                            IN     VARCHAR2,
78     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
79     x_athletic_details_id               IN     NUMBER      DEFAULT NULL,
80     x_person_id                         IN     NUMBER      DEFAULT NULL,
81     x_athletic_gpa                      IN     NUMBER      DEFAULT NULL,
82     x_eligibility_status_cd             IN     VARCHAR2    DEFAULT NULL,
83     x_predict_elig_code                 IN     VARCHAR2    DEFAULT NULL,
84     x_tentative_adm_code                IN     VARCHAR2    DEFAULT NULL,
85     x_review_date                       IN     DATE        DEFAULT NULL,
86     x_comments                          IN     VARCHAR2    DEFAULT NULL,
87     x_creation_date                     IN     DATE        DEFAULT NULL,
88     x_created_by                        IN     NUMBER      DEFAULT NULL,
89     x_last_update_date                  IN     DATE        DEFAULT NULL,
90     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
91     x_last_update_login                 IN     NUMBER      DEFAULT NULL
92   );
93 
94 END igs_pe_athletic_dtl_pkg;