DBA Data[Home] [Help]

PACKAGE: APPS.IGS_AS_ANON_METHOD_PKG

Source


1 PACKAGE igs_as_anon_method_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSDI60S.pls 115.1 2002/11/28 23:26:04 nsidana noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_load_cal_type                     IN OUT NOCOPY VARCHAR2,
7     x_method                            IN     VARCHAR2,
8     x_assessment_type                   IN     VARCHAR2,
9     x_mode                              IN     VARCHAR2    DEFAULT 'R'
10   );
11 
12   PROCEDURE lock_row (
13     x_rowid                             IN     VARCHAR2,
14     x_load_cal_type                     IN     VARCHAR2,
15     x_method                            IN     VARCHAR2,
16     x_assessment_type                   IN     VARCHAR2
17   );
18 
19   PROCEDURE update_row (
20     x_rowid                             IN     VARCHAR2,
21     x_load_cal_type                     IN     VARCHAR2,
22     x_method                            IN     VARCHAR2,
23     x_assessment_type                   IN     VARCHAR2,
24     x_mode                              IN     VARCHAR2    DEFAULT 'R'
25   );
26 
27   PROCEDURE add_row (
28     x_rowid                             IN OUT NOCOPY VARCHAR2,
29     x_load_cal_type                     IN OUT NOCOPY VARCHAR2,
30     x_method                            IN     VARCHAR2,
31     x_assessment_type                   IN     VARCHAR2,
32     x_mode                              IN     VARCHAR2    DEFAULT 'R'
33   );
34 
35   PROCEDURE delete_row (
36     x_rowid                             IN     VARCHAR2
37   );
38 
39   FUNCTION get_pk_for_validation (
40     x_load_cal_type                     IN     VARCHAR2
41   ) RETURN BOOLEAN;
42 
43   PROCEDURE get_fk_igs_as_assessmnt_typ (
44     x_assessment_type                   IN     VARCHAR2
45   );
46 
47   PROCEDURE get_fk_igs_ca_type (
48     x_cal_type                          IN     VARCHAR2
49   );
50 
51   PROCEDURE before_dml (
52     p_action                            IN     VARCHAR2,
53     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
54     x_load_cal_type                     IN     VARCHAR2    DEFAULT NULL,
55     x_method                            IN     VARCHAR2    DEFAULT NULL,
56     x_assessment_type                   IN     VARCHAR2    DEFAULT NULL,
57     x_creation_date                     IN     DATE        DEFAULT NULL,
58     x_created_by                        IN     NUMBER      DEFAULT NULL,
59     x_last_update_date                  IN     DATE        DEFAULT NULL,
60     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
61     x_last_update_login                 IN     NUMBER      DEFAULT NULL
62   );
63 
64 END igs_as_anon_method_pkg;