[Home] [Help]
PACKAGE: APPS.IGF_AP_APPL_STATUS_PKG
Source
1 PACKAGE igf_ap_appl_status_pkg AS
2 /* $Header: IGFAI77S.pls 120.0 2005/09/09 17:12:00 appldev noship $ */
3
4 FUNCTION get_pk_for_validation (
5 x_base_id IN NUMBER,
6 x_application_code IN VARCHAR2
7 ) RETURN BOOLEAN ;
8
9 PROCEDURE insert_row (
10 x_rowid IN OUT NOCOPY VARCHAR2,
11 x_application_code IN VARCHAR2,
12 x_base_id IN OUT NOCOPY NUMBER,
13 x_application_status_code IN VARCHAR2,
14 x_mode IN VARCHAR2 DEFAULT 'R'
15 );
16
17 PROCEDURE lock_row (
18 x_rowid IN VARCHAR2,
19 x_application_code IN VARCHAR2,
20 x_base_id IN NUMBER,
21 x_application_status_code IN VARCHAR2
22 );
23
24 PROCEDURE update_row (
25 x_rowid IN VARCHAR2,
26 x_application_code IN VARCHAR2,
27 x_base_id IN NUMBER,
28 x_application_status_code IN VARCHAR2,
29 x_mode IN VARCHAR2 DEFAULT 'R'
30 );
31
32 PROCEDURE add_row (
33 x_rowid IN OUT NOCOPY VARCHAR2,
34 x_application_code IN VARCHAR2,
35 x_base_id IN OUT NOCOPY NUMBER,
36 x_application_status_code IN VARCHAR2,
37 x_mode IN VARCHAR2 DEFAULT 'R'
38 );
39
40 PROCEDURE delete_row (
41 x_rowid IN VARCHAR2
42 );
43
44 PROCEDURE before_dml (
45 p_action IN VARCHAR2,
46 x_rowid IN VARCHAR2 DEFAULT NULL,
47 x_application_code IN VARCHAR2 DEFAULT NULL,
48 x_base_id IN NUMBER DEFAULT NULL,
49 x_application_status_code IN VARCHAR2 DEFAULT NULL,
50 x_creation_date IN DATE DEFAULT NULL,
51 x_created_by IN NUMBER DEFAULT NULL,
52 x_last_update_date IN DATE DEFAULT NULL,
53 x_last_updated_by IN NUMBER DEFAULT NULL,
54 x_last_update_login IN NUMBER DEFAULT NULL
55 );
56
57 END igf_ap_appl_status_pkg;