DBA Data[Home] [Help]

PACKAGE: APPS.IGS_PE_TYP_RSP_DFLT_PKG

Source


1 PACKAGE igs_pe_typ_rsp_dflt_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSNI97S.pls 115.1 2002/11/29 01:37:32 nsidana noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_s_person_type                     IN     VARCHAR2,
7     x_responsibility_key                IN     VARCHAR2,
8     x_application_short_name            IN     VARCHAR2,
9     x_mode                              IN     VARCHAR2    DEFAULT 'R'
10   );
11 
12   PROCEDURE lock_row (
13     x_rowid                             IN     VARCHAR2,
14     x_s_person_type                     IN     VARCHAR2,
15     x_responsibility_key                IN     VARCHAR2,
16     x_application_short_name            IN     VARCHAR2
17   );
18 
19   PROCEDURE delete_row (
20     x_rowid                             IN     VARCHAR2
21   );
22 
23   FUNCTION get_pk_for_validation (
24     x_s_person_type                     IN     VARCHAR2,
25     x_responsibility_key                IN     VARCHAR2,
26     x_application_short_name            IN     VARCHAR2
27   ) RETURN BOOLEAN;
28 
29   PROCEDURE before_dml (
30     p_action                            IN     VARCHAR2,
31     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
32     x_s_person_type                     IN     VARCHAR2    DEFAULT NULL,
33     x_responsibility_key                IN     VARCHAR2    DEFAULT NULL,
34     x_application_short_name            IN     VARCHAR2    DEFAULT NULL,
35     x_creation_date                     IN     DATE        DEFAULT NULL,
36     x_created_by                        IN     NUMBER      DEFAULT NULL,
37     x_last_update_date                  IN     DATE        DEFAULT NULL,
38     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
39     x_last_update_login                 IN     NUMBER      DEFAULT NULL
40   );
41 
42 END igs_pe_typ_rsp_dflt_pkg;