1 package ego_pub_ws_ag AUTHID CURRENT_USER as
2 /* $Header: EGOPAGS.pls 120.2 2011/05/06 05:29:10 trudave noship $ */
3 /*==========================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : EGOWSAGS.pls |
9 | DESCRIPTION : This file is a packaged procedure for the AG exploders |
10 | |
11 | |
12 +==========================================================================*/
13
14 --TYPE parameter_name_array_type IS VARRAY(15) OF VARCHAR2(1000);
15
16 PROCEDURE Create_Params_Attribute_Group(p_session_id IN NUMBER);
17
18 -- ============================================================================
19 -- Name : Preprocess_Input_AttrGroup
20 -- Description : This procedure will be used to pre-process input xml for Entity
21 -- type as Attribute Group. This procedure performs the following
22 -- actions:
23 -- 1. Reads the input parameters contained in the XML payload
24 -- stored in table EGO_PUB_WS_PARAMS using session_id and
25 -- stores them in table EGO_PUB_WS_CONFIG.
26 -- 2. Populates ODI input table EGO_ODI_SYNC_ENTITIES for entity AG
27 -- based on the invokation type (e.g. batch, list)
28 -- 3. Explodes the attribute group for all the end-valuesets to process
29 --
30 -- Parameters:
31 -- IN :
32 -- p_session_id IN NUMBER
33 -- An Unique DB sequence generated at Java wrapper.
34 --
35 -- ============================================================================
36
37 PROCEDURE Preprocess_Input_AttrGroup(p_session_id IN NUMBER);
38
39
40 PROCEDURE Explode_Attribute_Group(p_session_id IN NUMBER);
41
42 /*============================================================================*/
43
44 ---------------------------------------------------------------
45 -- Global Variables and Constants --
46 ---------------------------------------------------------------
47 G_CURRENT_USER_ID NUMBER := FND_GLOBAL.User_Id;
48 G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
49 G_ENTITY_TYPE_AG VARCHAR2(2) := 'AG';
50 G_ENTITY_TYPE_VS VARCHAR2(2) := 'VS';
51 G_ENTITY_TYPE_CHILD_VS VARCHAR2(10) := 'CHILD_VS' ;
52
53
54 END EGO_PUB_WS_AG;