DBA Data[Home] [Help]

PACKAGE: APPS.IGS_UC_COM_SCSICNTS_PKG

Source


1 PACKAGE igs_uc_com_scsicnts_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSXI12S.pls 115.4 2003/06/11 10:34:27 smaddali noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_school                            IN     NUMBER,
7     x_sitecode                          IN     VARCHAR2,
8     x_contact_code                      IN     NUMBER,
9     x_contact_post                      IN     VARCHAR2,
10     x_contact_name                      IN     VARCHAR2,
11     x_telephone                         IN     VARCHAR2,
12     x_fax                               IN     VARCHAR2,
13     x_email                             IN     VARCHAR2,
14     x_principal                         IN     VARCHAR2,
15     x_lists                             IN     VARCHAR2,
16     x_orders                            IN     VARCHAR2,
17     x_forms                             IN     VARCHAR2,
18     x_referee                           IN     VARCHAR2,
19     x_careers                           IN     VARCHAR2,
20     x_eas_contact                       IN     VARCHAR2,
21     x_imported                          IN     VARCHAR2,
22     x_mode                              IN     VARCHAR2    DEFAULT 'R'
23   );
24 
25   PROCEDURE lock_row (
26     x_rowid                             IN     VARCHAR2,
27     x_school                            IN     NUMBER,
28     x_sitecode                          IN     VARCHAR2,
29     x_contact_code                      IN     NUMBER,
30     x_contact_post                      IN     VARCHAR2,
31     x_contact_name                      IN     VARCHAR2,
32     x_telephone                         IN     VARCHAR2,
33     x_fax                               IN     VARCHAR2,
34     x_email                             IN     VARCHAR2,
35     x_principal                         IN     VARCHAR2,
36     x_lists                             IN     VARCHAR2,
37     x_orders                            IN     VARCHAR2,
38     x_forms                             IN     VARCHAR2,
39     x_referee                           IN     VARCHAR2,
40     x_careers                           IN     VARCHAR2,
41     x_eas_contact                       IN     VARCHAR2,
42     x_imported                          IN     VARCHAR2
43   );
44 
45   PROCEDURE update_row (
46     x_rowid                             IN     VARCHAR2,
47     x_school                            IN     NUMBER,
48     x_sitecode                          IN     VARCHAR2,
49     x_contact_code                      IN     NUMBER,
50     x_contact_post                      IN     VARCHAR2,
51     x_contact_name                      IN     VARCHAR2,
52     x_telephone                         IN     VARCHAR2,
53     x_fax                               IN     VARCHAR2,
54     x_email                             IN     VARCHAR2,
55     x_principal                         IN     VARCHAR2,
56     x_lists                             IN     VARCHAR2,
57     x_orders                            IN     VARCHAR2,
58     x_forms                             IN     VARCHAR2,
59     x_referee                           IN     VARCHAR2,
60     x_careers                           IN     VARCHAR2,
61     x_eas_contact                       IN     VARCHAR2,
62     x_imported                          IN     VARCHAR2,
63     x_mode                              IN     VARCHAR2    DEFAULT 'R'
64   );
65 
66   PROCEDURE add_row (
67     x_rowid                             IN OUT NOCOPY VARCHAR2,
68     x_school                            IN     NUMBER,
69     x_sitecode                          IN     VARCHAR2,
70     x_contact_code                      IN     NUMBER,
71     x_contact_post                      IN     VARCHAR2,
72     x_contact_name                      IN     VARCHAR2,
73     x_telephone                         IN     VARCHAR2,
74     x_fax                               IN     VARCHAR2,
75     x_email                             IN     VARCHAR2,
76     x_principal                         IN     VARCHAR2,
77     x_lists                             IN     VARCHAR2,
78     x_orders                            IN     VARCHAR2,
79     x_forms                             IN     VARCHAR2,
80     x_referee                           IN     VARCHAR2,
81     x_careers                           IN     VARCHAR2,
82     x_eas_contact                       IN     VARCHAR2,
83     x_imported                          IN     VARCHAR2,
84     x_mode                              IN     VARCHAR2    DEFAULT 'R'
85   );
86 
87   PROCEDURE delete_row (
88     x_rowid                             IN     VARCHAR2
89   );
90 
91   FUNCTION get_pk_for_validation (
92     x_school                            IN     NUMBER,
93     x_sitecode                          IN     VARCHAR2,
94     x_contact_code                      IN     NUMBER
95   ) RETURN BOOLEAN;
96 
97   PROCEDURE get_fk_igs_uc_com_schsites (
98     x_school                            IN     NUMBER,
99     x_sitecode                          IN     VARCHAR2
100   );
101 
102   PROCEDURE before_dml (
103     p_action                            IN     VARCHAR2,
104     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
105     x_school                            IN     NUMBER      DEFAULT NULL,
106     x_sitecode                          IN     VARCHAR2    DEFAULT NULL,
107     x_contact_code                      IN     NUMBER      DEFAULT NULL,
108     x_contact_post                      IN     VARCHAR2    DEFAULT NULL,
109     x_contact_name                      IN     VARCHAR2    DEFAULT NULL,
110     x_telephone                         IN     VARCHAR2    DEFAULT NULL,
111     x_fax                               IN     VARCHAR2    DEFAULT NULL,
112     x_email                             IN     VARCHAR2    DEFAULT NULL,
113     x_principal                         IN     VARCHAR2    DEFAULT NULL,
114     x_lists                             IN     VARCHAR2    DEFAULT NULL,
115     x_orders                            IN     VARCHAR2    DEFAULT NULL,
116     x_forms                             IN     VARCHAR2    DEFAULT NULL,
117     x_referee                           IN     VARCHAR2    DEFAULT NULL,
118     x_careers                           IN     VARCHAR2    DEFAULT NULL,
119     x_eas_contact                       IN     VARCHAR2    DEFAULT NULL,
120     x_imported                          IN     VARCHAR2    DEFAULT NULL,
121     x_creation_date                     IN     DATE        DEFAULT NULL,
122     x_created_by                        IN     NUMBER      DEFAULT NULL,
123     x_last_update_date                  IN     DATE        DEFAULT NULL,
124     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
125     x_last_update_login                 IN     NUMBER      DEFAULT NULL
126   );
127 
128 END igs_uc_com_scsicnts_pkg;