DBA Data[Home] [Help]

APPS.OKC_AQ_WRITE_ERROR_PVT dependencies on OKC_API

Line 21: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

17: x_aqmv_tbl aqmv_tbl_type;
18:
19: -- Global Variables
20: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_AQ_WRITE_ERROR_PVT';
21: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
25:

Line 31: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE,

27: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
28:
29: --Procedure to write errors and message details to the tables from the message stack
30: PROCEDURE WRITE_MSGDATA(p_api_version IN NUMBER,
31: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
32: p_source_name IN VARCHAR2,
33: p_datetime IN DATE,
34: p_msg_tab IN OKC_AQ_PVT.msg_tab_typ,
35: p_q_name IN VARCHAR2 DEFAULT NULL,

Line 45: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

41: p_commit IN VARCHAR2 DEFAULT 'T');
42:
43: --Procedure to update errors and message details in the tables
44: PROCEDURE UPDATE_ERROR(p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46: p_id IN NUMBER,
47: p_aqe_id IN NUMBER,
48: p_msg_seq_no IN NUMBER,
49: p_source_name IN VARCHAR2,

Line 62: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

58: x_return_status OUT NOCOPY VARCHAR2);
59:
60: --Procedure to delete errors and message details from the tables
61: PROCEDURE DELETE_ERROR(p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
63: p_id IN NUMBER,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2,
66: x_return_status OUT NOCOPY VARCHAR2);