[Home] [Help]
PACKAGE: APPS.GR_EIN_ASL_RISKS_PKG
Source
1 PACKAGE GR_EIN_ASL_RISKS_PKG AUTHID CURRENT_USER AS
2 /*$Header: GRHIEARS.pls 115.2 2002/10/29 16:32:35 mgrosser noship $*/
3
4 PROCEDURE Insert_Row
5 (p_commit IN VARCHAR2,
6 p_called_by_form IN VARCHAR2,
7 p_sequence_number IN NUMBER,
8 p_risk_phrase_code IN VARCHAR2,
9 p_created_by IN NUMBER,
10 p_creation_date IN DATE,
11 p_last_updated_by IN NUMBER,
12 p_last_update_date IN DATE,
13 p_last_update_login IN NUMBER,
14 x_rowid OUT NOCOPY VARCHAR2,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_oracle_error OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2);
18
19 PROCEDURE Check_Foreign_Keys
20 (p_sequence_number IN NUMBER,
21 p_risk_phrase_code IN VARCHAR2,
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_oracle_error OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2);
25
26
27
28 PROCEDURE Delete_Row
29 (p_commit IN VARCHAR2,
30 p_called_by_form IN VARCHAR2,
31 p_rowid IN VARCHAR2,
32 p_sequence_number IN NUMBER,
33 p_risk_phrase_code IN VARCHAR2,
34 p_created_by IN NUMBER,
35 p_creation_date IN DATE,
36 p_last_updated_by IN NUMBER,
37 p_last_update_date IN DATE,
38 p_last_update_login IN NUMBER,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_oracle_error OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2);
42
43
44
45
46 PROCEDURE Check_Primary_Key
47 (p_sequence_number IN NUMBER,
48 p_risk_phrase_code IN VARCHAR2,
49 p_called_by_form IN VARCHAR2,
50 x_rowid OUT NOCOPY VARCHAR2,
51 x_key_exists OUT NOCOPY VARCHAR2);
52
53
54
55 END GR_EIN_ASL_RISKS_PKG;