PACKAGE: APPS.IGS_EN_TIMESLOT_PREF_PKG

Source

1 PACKAGE igs_en_timeslot_pref_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSEI40S.pls 115.8 2002/11/28 23:42:08 nsidana ship $ */
3  PROCEDURE insert_row (
4    x_rowid IN OUT NOCOPY VARCHAR2,
5    x_igs_en_timeslot_pref_id IN OUT NOCOPY NUMBER,
6    x_igs_en_timeslot_prty_id IN NUMBER,
7    x_preference_order IN NUMBER,
8    x_preference_code IN VARCHAR2,
9    x_preference_version IN NUMBER,
10    x_mode IN VARCHAR2 DEFAULT 'R',
11    x_sequence_number IN NUMBER
12   );
13 
14  PROCEDURE lock_row (
15    x_rowid IN VARCHAR2,
16    x_igs_en_timeslot_pref_id IN NUMBER,
17    x_igs_en_timeslot_prty_id IN NUMBER,
18    x_preference_order IN NUMBER,
19    x_preference_code IN VARCHAR2,
20    x_preference_version IN  NUMBER,
21    x_sequence_number IN NUMBER
22   );
23 
24  PROCEDURE update_row (
25    x_rowid IN VARCHAR2,
26    x_igs_en_timeslot_pref_id IN NUMBER,
27    x_igs_en_timeslot_prty_id IN NUMBER,
28    x_preference_order IN NUMBER,
29    x_preference_code IN VARCHAR2,
30    x_preference_version IN  NUMBER,
31    x_mode IN VARCHAR2 DEFAULT 'R',
32    x_sequence_number IN NUMBER
33   );
34 
35  PROCEDURE add_row (
36    x_rowid IN OUT NOCOPY VARCHAR2,
37    x_igs_en_timeslot_pref_id IN OUT NOCOPY NUMBER,
38    x_igs_en_timeslot_prty_id IN NUMBER,
39    x_preference_order IN NUMBER,
40    x_preference_code IN VARCHAR2,
41    x_preference_version IN  NUMBER,
42    x_mode IN VARCHAR2 DEFAULT 'R',
43    x_sequence_number IN NUMBER
44   ) ;
45 
46  PROCEDURE delete_row (
47    x_rowid IN VARCHAR2
48  ) ;
49  FUNCTION get_pk_for_validation (
50    x_igs_en_timeslot_pref_id IN NUMBER
51    ) RETURN BOOLEAN ;
52 
53  FUNCTION get_uk_for_validation (
54    x_igs_en_timeslot_prty_id IN NUMBER,
55     x_preference_code IN VARCHAR2,
56     x_preference_version IN  NUMBER,
57     x_sequence_number IN  NUMBER
58    ) RETURN BOOLEAN;
59 
60  PROCEDURE get_fk_igs_en_timeslot_prty (
61    x_igs_en_timeslot_prty_id IN NUMBER
62     );
63 
64  PROCEDURE check_constraints (
65    column_name IN VARCHAR2  DEFAULT NULL,
66    column_value IN VARCHAR2  DEFAULT NULL ) ;
67  PROCEDURE before_dml (
68     p_action IN VARCHAR2,
69     x_rowid IN VARCHAR2 DEFAULT NULL,
70     x_igs_en_timeslot_pref_id IN NUMBER DEFAULT NULL,
71     x_igs_en_timeslot_prty_id IN NUMBER DEFAULT NULL,
72     x_preference_order IN NUMBER DEFAULT NULL,
73     x_preference_code IN VARCHAR2 DEFAULT NULL,
74     x_preference_version IN  NUMBER DEFAULT NULL,
75     x_creation_date IN DATE DEFAULT NULL,
76     x_created_by IN NUMBER DEFAULT NULL,
77     x_last_update_date IN DATE DEFAULT NULL,
78     x_last_updated_by IN NUMBER DEFAULT NULL,
79     x_last_update_login IN NUMBER DEFAULT NULL,
80     x_sequence_number IN NUMBER DEFAULT NULL
81  );
82 END igs_en_timeslot_pref_pkg;