DBA Data[Home] [Help]

APPS.EGO_VS_BULKLOAD_PVT dependencies on EGO_VS_BULKLOAD_PVT

Line 1: PACKAGE BODY ego_vs_bulkload_pvt AS

1: PACKAGE BODY ego_vs_bulkload_pvt AS
2: /* $Header: EGOVVSBB.pls 120.24 2011/08/25 07:49:15 vijoshi noship $ */
3:
4: /*==========================================================================+
5: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |

Line 18: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_VS_BULKLOAD_PVT';

14:
15: ---------------------------------------------------------------
16: -- Global Variables and Constants --
17: ---------------------------------------------------------------
18: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_VS_BULKLOAD_PVT';
19: G_APP_SHORT_NAME CONSTANT VARCHAR2(3) := 'EGO';
20:
21: ---------------------------------------------------------------
22: -- Transaction Type. --

Line 2238: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';

2234: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS_VER;
2235: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
2236: G_TOKEN_TBL(2).Token_Value := G_CREATE;
2237: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
2238: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';
2239: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
2240: G_TOKEN_TBL(4).Token_Value := 'Get_Lock_Info';
2241:
2242:

Line 2422: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';

2418: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS_VER;
2419: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
2420: G_TOKEN_TBL(2).Token_Value := G_CREATE;
2421: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
2422: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';
2423: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
2424: G_TOKEN_TBL(4).Token_Value := 'Lock_Unlock_Object';
2425:
2426:

Line 4902: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';

4898: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS_VER;
4899: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
4900: G_TOKEN_TBL(2).Token_Value := l_valueset_tab(j).transaction_type;
4901: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
4902: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';
4903: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
4904: G_TOKEN_TBL(4).Token_Value := 'Release_Value_Set_Version';
4905:
4906:

Line 5118: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';

5114: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS_VER;
5115: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
5116: G_TOKEN_TBL(2).Token_Value := l_valueset_tab(j).transaction_type;
5117: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
5118: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';
5119: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
5120: G_TOKEN_TBL(4).Token_Value := 'Sync_VS_With_Draft';
5121:
5122:

Line 6022: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';

6018: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS;
6019: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
6020: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
6021: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
6022: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';
6023: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6024: G_TOKEN_TBL(4).Token_Value := 'Get_Key_VS_Columns';
6025:
6026:

Line 6593: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';

6589: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS;
6590: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
6591: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
6592: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
6593: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';
6594: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6595: G_TOKEN_TBL(4).Token_Value := 'Get_Key_VS_Columns';
6596:
6597:

Line 8203: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';

8199: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS;
8200: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
8201: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
8202: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
8203: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';
8204: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
8205: G_TOKEN_TBL(4).Token_Value := 'Get_Key_Value_Columns';
8206:
8207:

Line 8992: write_debug(G_PKG_Name,l_api_name,' End of API ego_vs_bulkload_pvt.Process_Value_Set_Value ' );

8988: COMMIT;
8989: END IF;
8990:
8991:
8992: write_debug(G_PKG_Name,l_api_name,' End of API ego_vs_bulkload_pvt.Process_Value_Set_Value ' );
8993: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' End of API ego_vs_bulkload_pvt.Process_Value_Set_Value ' );
8994:
8995:
8996: EXCEPTION

Line 8993: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' End of API ego_vs_bulkload_pvt.Process_Value_Set_Value ' );

8989: END IF;
8990:
8991:
8992: write_debug(G_PKG_Name,l_api_name,' End of API ego_vs_bulkload_pvt.Process_Value_Set_Value ' );
8993: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' End of API ego_vs_bulkload_pvt.Process_Value_Set_Value ' );
8994:
8995:
8996: EXCEPTION
8997: WHEN OTHERS THEN

Line 10983: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';

10979: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS;
10980: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
10981: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
10982: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
10983: G_TOKEN_TBL(3).Token_Value := 'EGO_VS_BULKLOAD_PVT';
10984: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
10985: G_TOKEN_TBL(4).Token_Value := 'Get_Key_VS_Columns';
10986:
10987:

Line 12045: x_return_msg := 'ego_vs_bulkload_pvt.Delete_Processed_Value_Sets - '||SQLERRM;

12041: WHEN OTHERS THEN
12042: write_debug(G_PKG_Name,l_api_name,' In Exception of API. Error : '||SubStr(SQLERRM,1,500) );
12043: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' In Exception of API. Error : '||SubStr(SQLERRM,1,500) );
12044: x_return_status := G_RET_STS_UNEXP_ERROR;
12045: x_return_msg := 'ego_vs_bulkload_pvt.Delete_Processed_Value_Sets - '||SQLERRM;
12046: RETURN;
12047: END Delete_Processed_Value_Sets;
12048:
12049:

Line 12050: END ego_vs_bulkload_pvt;

12046: RETURN;
12047: END Delete_Processed_Value_Sets;
12048:
12049:
12050: END ego_vs_bulkload_pvt;