APPS.EGO_GENERIC_TEMP_DML_PVT dependencies on EGO_GENERIC_TEMP

Line 1: PACKAGE BODY EGO_GENERIC_TEMP_DML_PVT AS

1: PACKAGE BODY EGO_GENERIC_TEMP_DML_PVT AS
2: /* $Header: EGOVGTDB.pls 120.0.12010000.2 2009/08/05 13:23:41 vijoshi noship $ */
3:
4: PROCEDURE Insert_Row ( p_api_version IN NUMBER
5: --,p_commit IN VARCHAR2 default G_FALSE

Line 6: ,p_generic_temp_tbl IN EGO_GENERIC_TEMP_TBL_TYPE

2: /* $Header: EGOVGTDB.pls 120.0.12010000.2 2009/08/05 13:23:41 vijoshi noship $ */
3:
4: PROCEDURE Insert_Row ( p_api_version IN NUMBER
5: --,p_commit IN VARCHAR2 default G_FALSE
6: ,p_generic_temp_tbl IN EGO_GENERIC_TEMP_TBL_TYPE
7: ,x_return_status OUT NOCOPY VARCHAR2
8: ,x_msg_data OUT NOCOPY VARCHAR2
9: ,x_msg_count OUT NOCOPY NUMBER
10: )

Line 15: l_c_attrib1 EGO_GENERIC_TEMP.C_ATTRIBUTE1%TYPE;

11: IS
12:
13: l_api_name varchar2(20) := 'Insert_Row';
14:
15: l_c_attrib1 EGO_GENERIC_TEMP.C_ATTRIBUTE1%TYPE;
16: l_c_attrib2 EGO_GENERIC_TEMP.C_ATTRIBUTE2%TYPE;
17: l_n_attrib1 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;
18: l_n_attrib2 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;
19: l_d_attrib1 EGO_GENERIC_TEMP.D_ATTRIBUTE1%TYPE;

Line 16: l_c_attrib2 EGO_GENERIC_TEMP.C_ATTRIBUTE2%TYPE;

12:
13: l_api_name varchar2(20) := 'Insert_Row';
14:
15: l_c_attrib1 EGO_GENERIC_TEMP.C_ATTRIBUTE1%TYPE;
16: l_c_attrib2 EGO_GENERIC_TEMP.C_ATTRIBUTE2%TYPE;
17: l_n_attrib1 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;
18: l_n_attrib2 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;
19: l_d_attrib1 EGO_GENERIC_TEMP.D_ATTRIBUTE1%TYPE;
20: l_d_attrib2 EGO_GENERIC_TEMP.D_ATTRIBUTE1%TYPE;

Line 17: l_n_attrib1 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;

13: l_api_name varchar2(20) := 'Insert_Row';
14:
15: l_c_attrib1 EGO_GENERIC_TEMP.C_ATTRIBUTE1%TYPE;
16: l_c_attrib2 EGO_GENERIC_TEMP.C_ATTRIBUTE2%TYPE;
17: l_n_attrib1 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;
18: l_n_attrib2 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;
19: l_d_attrib1 EGO_GENERIC_TEMP.D_ATTRIBUTE1%TYPE;
20: l_d_attrib2 EGO_GENERIC_TEMP.D_ATTRIBUTE1%TYPE;
21:

Line 18: l_n_attrib2 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;

14:
15: l_c_attrib1 EGO_GENERIC_TEMP.C_ATTRIBUTE1%TYPE;
16: l_c_attrib2 EGO_GENERIC_TEMP.C_ATTRIBUTE2%TYPE;
17: l_n_attrib1 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;
18: l_n_attrib2 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;
19: l_d_attrib1 EGO_GENERIC_TEMP.D_ATTRIBUTE1%TYPE;
20: l_d_attrib2 EGO_GENERIC_TEMP.D_ATTRIBUTE1%TYPE;
21:
22:

Line 19: l_d_attrib1 EGO_GENERIC_TEMP.D_ATTRIBUTE1%TYPE;

15: l_c_attrib1 EGO_GENERIC_TEMP.C_ATTRIBUTE1%TYPE;
16: l_c_attrib2 EGO_GENERIC_TEMP.C_ATTRIBUTE2%TYPE;
17: l_n_attrib1 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;
18: l_n_attrib2 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;
19: l_d_attrib1 EGO_GENERIC_TEMP.D_ATTRIBUTE1%TYPE;
20: l_d_attrib2 EGO_GENERIC_TEMP.D_ATTRIBUTE1%TYPE;
21:
22:
23: BEGIN

Line 20: l_d_attrib2 EGO_GENERIC_TEMP.D_ATTRIBUTE1%TYPE;

16: l_c_attrib2 EGO_GENERIC_TEMP.C_ATTRIBUTE2%TYPE;
17: l_n_attrib1 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;
18: l_n_attrib2 EGO_GENERIC_TEMP.N_ATTRIBUTE1%TYPE;
19: l_d_attrib1 EGO_GENERIC_TEMP.D_ATTRIBUTE1%TYPE;
20: l_d_attrib2 EGO_GENERIC_TEMP.D_ATTRIBUTE1%TYPE;
21:
22:
23: BEGIN
24: x_return_status := G_RET_STS_SUCCESS;

Line 39: INSERT INTO EGO_GENERIC_TEMP (

35: l_d_attrib1 := p_generic_temp_tbl(i).D_ATTRIBUTE1;
36: l_d_attrib2 := p_generic_temp_tbl(i).D_ATTRIBUTE2;
37:
38:
39: INSERT INTO EGO_GENERIC_TEMP (
40: C_ATTRIBUTE1
41: ,C_ATTRIBUTE2
42: ,N_ATTRIBUTE1
43: ,N_ATTRIBUTE2

Line 84: END EGO_GENERIC_TEMP_DML_PVT;

80: ,p_count => x_msg_count
81: ,p_data => x_msg_data);
82:
83: END Insert_Row;
84: END EGO_GENERIC_TEMP_DML_PVT;