PACKAGE: APPS.IGS_EN_TIMESLOT_PRTY_PKG

Source

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