1 PACKAGE igs_co_type_jo_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSLI24S.pls 115.2 2002/11/29 01:07:48 nsidana noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_correspondence_type IN VARCHAR2,
7 x_s_job_name IN VARCHAR2,
8 x_output_num IN NUMBER,
9 x_mode IN VARCHAR2 DEFAULT 'R'
10 );
11
12 PROCEDURE lock_row (
13 x_rowid IN VARCHAR2,
14 x_correspondence_type IN VARCHAR2,
15 x_s_job_name IN VARCHAR2,
16 x_output_num IN NUMBER
17 );
18
19 PROCEDURE delete_row (
20 x_rowid IN VARCHAR2
21 );
22
23 FUNCTION get_pk_for_validation (
24 x_correspondence_type IN VARCHAR2,
25 x_s_job_name IN VARCHAR2,
26 x_output_num IN NUMBER
27 ) RETURN BOOLEAN;
28
29 PROCEDURE before_dml (
30 p_action IN VARCHAR2,
31 x_rowid IN VARCHAR2 DEFAULT NULL,
32 x_correspondence_type IN VARCHAR2 DEFAULT NULL,
33 x_s_job_name IN VARCHAR2 DEFAULT NULL,
34 x_output_num IN NUMBER 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_co_type_jo_pkg;