1 PACKAGE ego_pub_ws_vs AUTHID CURRENT_USER AS
2 /* $Header: EGOPVSS.pls 120.5 2011/05/02 17:36:55 vijoshi noship $ */
3
4 /*==========================================================================+
5 | Copyright (c) 2011 Oracle Corporation , California, USA |
6 | All rights reserved. |
7 +===========================================================================+
8 | |
9 | File Name : EGOPVSS.pls |
10 | DESCRIPTION : This file is a packaged procedure for the VS exploders |
11 | |
12 | 01-Mar-2011 vijoshi Initial Creation |
13 +==========================================================================*/
14
15
16
17 -- ============================================================================
18 -- Name : Explode_Value_Set
19 -- Description : This procedure will be used to explode the child value sets
20 -- and store them in the entities table.
21 -- actions:
22 -- 1. Explodes the value set entity for any child value sets
23 --
24 -- Parameters:
25 -- IN :
26 -- p_session_id IN NUMBER
27 -- An Unique DB sequence generated at Java wrapper.
28 --
29 -- ============================================================================
30 PROCEDURE Explode_Value_Set ( p_session_id IN NUMBER);
31
32 -- ============================================================================
33 -- Name : Create_Params_Value_Set
34 -- Description : This procedure will determine the mode- BATCH/LIST and insert
35 -- the appropriate parameters in the ego_pub_ws_config table
36 -- actions:
37 -- Called from Preprocess_Input_ValueSet
38 --
39 -- Parameters:
40 -- IN :
41 -- p_session_id IN NUMBER
42 -- An Unique DB sequence generated at Java wrapper.
43 --
44 -- ============================================================================
45
46 PROCEDURE Create_Params_Value_Set (p_session_id IN NUMBER);
47
48 -- ============================================================================
49 -- Name : Preprocess_Input_ValueSet
50 -- Description : This procedure will be used to pre-process input xml for Entity
51 -- type as Value Set. This procedure performs the following
52 -- actions:
53 -- 1. Reads the input parameters contained in the XML payload
54 -- stored in table EGO_PUB_WS_PARAMS using session_id and
55 -- stores them in table EGO_PUB_WS_CONFIG.
56 -- 2. Populates ODI input table EGO_ODI_SYNC_ENTITIES for entity VS
57 -- based on the invokation type (e.g. batch, list)
58 -- 3. Explodes the value set entity for any child value sets
59 --
60 -- Parameters:
61 -- IN :
62 -- p_session_id IN NUMBER
63 -- An Unique DB sequence generated at Java wrapper.
64 --
65 -- ============================================================================
66
67 PROCEDURE Preprocess_Input_ValueSet(p_session_id IN NUMBER);
68
69
70 PROCEDURE Write_Error_Entites_ToBatFwk( p_session_id IN NUMBER,
71 p_batch_id IN NUMBER);
72
73
74
75 ---
76 --- This procedure inserts the Value Set entity in the ego_pub_ws_entities table
77 --- if it does not already exist for the session
78 ---
79 PROCEDURE Insert_Vs_Entity ( p_session_id IN NUMBER
80 ,p_vs_id IN NUMBER
81 ,p_vs_name IN VARCHAR2
82 ,p_vs_version IN NUMBER
83 ,p_user_entered_flag IN VARCHAR2 DEFAULT 'N'
84 );
85
86
87
88 /*============================================================================*/
89
90 ---------------------------------------------------------------
91 -- Global Variables and Constants --
92 ---------------------------------------------------------------
93 G_CURRENT_USER_ID NUMBER := FND_GLOBAL.User_Id;
94 G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
95 G_ENTITY_TYPE_VS VARCHAR2(2) := 'VS';
96 G_ENTITY_TYPE_CHILD_VS VARCHAR2(10) := 'CHILD_VS' ;
97
98
99
100
101
102 END EGO_PUB_WS_VS;