DBA Data[Home] [Help]

APPS.AK_ON_OBJECTS_PVT dependencies on AK_ON_OBJECTS_PUB

Line 25: G_LOG_BUFFER_TBL AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

21: G_QUERYOBJ CONSTANT VARCHAR2(10) := 'QUERYOBJ';
22: G_AMPARAM_REGISTRY CONSTANT VARCHAR2(20) := 'AMPARAM_REGISTRY';
23:
24: -- PL/SQL tables for log file in upload and download
25: G_LOG_BUFFER_TBL AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
26:
27: -- Write mode of output file
28: G_WRITE_MODE VARCHAR2(1);
29:

Line 66: p_from_table IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,

62: -- in the from table appended to it.
63: --==============================================
64: procedure APPEND_BUFFER_TABLES (
65: p_return_status OUT NOCOPY VARCHAR2,
66: p_from_table IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,
67: p_to_table IN OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Tbl_Type
68: );
69:
70:

Line 67: p_to_table IN OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Tbl_Type

63: --==============================================
64: procedure APPEND_BUFFER_TABLES (
65: p_return_status OUT NOCOPY VARCHAR2,
66: p_from_table IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,
67: p_to_table IN OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Tbl_Type
68: );
69:
70:
71: --==============================================

Line 221: p_buffer OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,

217: --=======================================================
218: PROCEDURE READ_LINE (
219: p_return_status OUT NOCOPY VARCHAR2,
220: p_index IN OUT NOCOPY Number,
221: p_buffer OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
222: p_lines_read OUT NOCOPY number,
223: p_eof_flag OUT NOCOPY VARCHAR2,
224: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp
225: );

Line 224: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp

220: p_index IN OUT NOCOPY Number,
221: p_buffer OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
222: p_lines_read OUT NOCOPY number,
223: p_eof_flag OUT NOCOPY VARCHAR2,
224: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp
225: );
226:
227:
228: --==============================================

Line 465: p_buffer_tbl IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,

461: -- contents in the PL/SQL table.
462: --=======================================================
463: procedure WRITE_FILE (
464: p_return_status OUT NOCOPY VARCHAR2,
465: p_buffer_tbl IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,
466: p_write_mode IN VARCHAR2 := AK_ON_OBJECTS_PUB.G_APPEND
467: );
468:
469: --=======================================================

Line 466: p_write_mode IN VARCHAR2 := AK_ON_OBJECTS_PUB.G_APPEND

462: --=======================================================
463: procedure WRITE_FILE (
464: p_return_status OUT NOCOPY VARCHAR2,
465: p_buffer_tbl IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,
466: p_write_mode IN VARCHAR2 := AK_ON_OBJECTS_PUB.G_APPEND
467: );
468:
469: --=======================================================
470: -- Procedure WRITE_LOG_FILE

Line 500: p_buffer_tbl IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,

496: -- contents in the PL/SQL table.
497: --=======================================================
498: procedure WRITE_LOG_FILE (
499: p_return_status OUT NOCOPY VARCHAR2,
500: p_buffer_tbl IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,
501: p_write_mode IN VARCHAR2 := AK_ON_OBJECTS_PUB.G_APPEND
502: );
503:
504: procedure WRITE_TO_TABLE (

Line 501: p_write_mode IN VARCHAR2 := AK_ON_OBJECTS_PUB.G_APPEND

497: --=======================================================
498: procedure WRITE_LOG_FILE (
499: p_return_status OUT NOCOPY VARCHAR2,
500: p_buffer_tbl IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,
501: p_write_mode IN VARCHAR2 := AK_ON_OBJECTS_PUB.G_APPEND
502: );
503:
504: procedure WRITE_TO_TABLE (
505: p_buffer IN VARCHAR2