PACKAGE: APPS.IGS_SS_ADMAPPL_SETUP_PKG

Source

1 PACKAGE igs_ss_admappl_setup_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAIB6S.pls 115.10 2002/11/22 13:12:59 knag ship $ */
3   PROCEDURE lock_row (
4     x_rowid IN VARCHAR2,
5     x_admappl_setup_id IN NUMBER,
6     x_alias_type IN VARCHAR2,
7     x_permanent_addr_type IN VARCHAR2,
8     x_mailing_addr_type IN VARCHAR2,
9     x_person_id_type IN VARCHAR2,
10     x_ps_note_type_id IN NUMBER,
11     x_we_note_type_id IN NUMBER,
12     x_act_note_type_id IN NUMBER,
13     x_dependent_of_veteran  IN NUMBER,
14     x_app_source_id  IN NUMBER
15   );
16   PROCEDURE update_row (
17     x_rowid IN VARCHAR2,
18     x_admappl_setup_id IN NUMBER,
19     x_alias_type IN VARCHAR2,
20     x_permanent_addr_type IN VARCHAR2,
21     x_mailing_addr_type IN VARCHAR2,
22     x_person_id_type IN VARCHAR2,
23     x_ps_note_type_id IN NUMBER,
24     x_we_note_type_id IN NUMBER,
25     x_act_note_type_id IN NUMBER,
26     x_dependent_of_veteran  IN NUMBER,
27     x_app_source_id  IN NUMBER ,
28     x_mode IN VARCHAR2 DEFAULT 'R'
29   );
30   FUNCTION get_pk_for_validation (
31     x_admappl_setup_id IN NUMBER
32   ) RETURN BOOLEAN;
33  PROCEDURE get_fk_igs_ad_note_types_act (
34    x_notes_type_id IN NUMBER
35     );
36  PROCEDURE get_fk_igs_pe_alias_types (
37    x_alias_type IN VARCHAR2
38     );
39 /* Code commented as these columns are obsoleted in DLD1.7
40  PROCEDURE get_fk_igs_co_addr_type_mat (
41    x_addr_type IN VARCHAR2
42     );
43  PROCEDURE get_fk_igs_co_addr_type_pat (
44    x_addr_type IN VARCHAR2
45     );
46 */
47  PROCEDURE get_fk_igs_ad_note_types_we (
48    x_notes_type_id IN NUMBER
49     );
50  PROCEDURE get_fk_igs_pe_person_id_typ (
51    x_person_id_type IN VARCHAR2
52     );
53  PROCEDURE get_fk_igs_ad_note_types_psnt (
54    x_notes_type_id IN NUMBER
55     );
56   PROCEDURE check_constraints (
57     column_name IN VARCHAR2 DEFAULT NULL,
58     column_value IN VARCHAR2 DEFAULT NULL
59   );
60   PROCEDURE before_dml (
61     p_action IN VARCHAR2,
62     x_rowid IN VARCHAR2 DEFAULT NULL,
63     x_admappl_setup_id IN NUMBER DEFAULT NULL,
64     x_alias_type IN VARCHAR2 DEFAULT NULL,
65     x_permanent_addr_type IN VARCHAR2 DEFAULT NULL,
66     x_mailing_addr_type IN VARCHAR2 DEFAULT NULL,
67     x_person_id_type IN VARCHAR2 DEFAULT NULL,
68     x_ps_note_type_id IN NUMBER DEFAULT NULL,
69     x_we_note_type_id IN NUMBER DEFAULT NULL,
70     x_act_note_type_id IN NUMBER DEFAULT NULL,
71     x_dependent_of_veteran  IN NUMBER DEFAULT NULL,
72     x_app_source_id  IN NUMBER DEFAULT NULL,
73     x_creation_date IN DATE DEFAULT NULL,
74     x_created_by IN NUMBER DEFAULT NULL,
75     x_last_update_date IN DATE DEFAULT NULL,
76     x_last_updated_by IN NUMBER DEFAULT NULL,
77     x_last_update_login IN NUMBER DEFAULT NULL
78   );
79 END igs_ss_admappl_setup_pkg;