[Home] [Help]
Skip to content
PACKAGE: APPS.EGO_PUB_WS_ICC
Source
1 package EGO_PUB_WS_ICC AUTHID CURRENT_USER AS
2 /* $Header: EGOPICCS.pls 120.1 2011/04/09 11:34:09 kjonnala noship $ */
3
4 /*==========================================================================+
5 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
6 | All rights reserved. |
7 +===========================================================================+
8 | |
9 | File Name : EGOPICCS.pls |
10 | DESCRIPTION : This package is meant for pre-processing the ICC entity |
11 | records in the Metadata Sync flow. |
12 | Created By : kjonnala |
13 | Created On : 25-Mar-2011 |
14 | |
15 +==========================================================================*/
16
17 -- ================================================================================================================
18 -- Name : Preprocess_Input_ICC
19 -- Description : This is the main procedure for pre-processing the ICC entitiy records.
20 -- This procedure performs the following actions:
21 -- 1. Calls Create_Params_ICC() to insert config params to EGO_PUB_WS_CONFIG table.
22 -- 2. Calls Create_Entities_ICC procedure, to populate ODI input table EGO_PUB_WS_ENTITIES
23 -- for entity ICC, based on the invokation type (e.g. batch, list)
24 -- 3. Calls Explode_ICC procedure to explode the ICCs and populate AGs into EGO_PUB_WS_ENTITIES
25 -- 4. In Batch Mode flow, calls Write_Derived_Entites_ToBatFwk procedure to
26 -- add the derived entities (ICCs,AGs) to Batch Fwk Entities table - EGO_PUB_BAT_ENT_OBJS_B
27 -- This procedure gets called from ODI project EGO_SYNCICCDETAILS.
28 --
29 -- Scope : Public
30 --
31 -- Parameters:
32 -- IN :
33 -- p_session_id IN NUMBER
34 -- An Unique DB sequence generated at Java wrapper.
35 --
36 -- ================================================================================================================
37 PROCEDURE Preprocess_Input_ICC(p_session_id IN NUMBER);
38
39
40 PROCEDURE Write_Errors_ToBatFwk(p_session_id IN NUMBER,
41 p_batch_id IN NUMBER);
42
43
44 /*============================================================================*/
45
46 ---------------------------------------------------------------
47 -- Global Variables and Constants --
48 ---------------------------------------------------------------
49 G_CURRENT_USER_ID NUMBER := FND_GLOBAL.User_Id;
50 G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
51 G_ENTITY_TYPE_ICC VARCHAR2(3) := 'ICC';
52 G_ENTITY_TYPE_ICC_VER VARCHAR2(7) := 'ICC_VER';
53 G_ENTITY_TYPE_AG VARCHAR2(7) := 'AG';
54 G_ENTITY_TYPE_VS VARCHAR2(7) := 'VS'; /*will need this when exploding VS associated to TAs*/
55 G_PKG_NAME VARCHAR2(20) := 'EGO_PUB_WS_ICC';
56 G_SHOW_ERROR_FLAG_YES VARCHAR2(1) :='Y';
57 G_SHOW_ERROR_FLAG_NO VARCHAR2(1) :='N';
58 G_USER_ENTERED_FLAG_YES VARCHAR2(1) :='Y';
59 G_USER_ENTERED_FLAG_NO VARCHAR2(1) :='N';
60 G_APPLICATION_ID_EGO NUMBER := EGO_PUB_WS_UTIL.Get_Application_Id('EGO');
61 G_CHAR_TRUE VARCHAR2(4) :='TRUE';
62 G_CHAR_FALSE VARCHAR2(5) :='FALSE';
63 G_CHAR_YES VARCHAR2(5) :='Y';
64 G_CHAR_NO VARCHAR2(5) :='N';
65
66 END EGO_PUB_WS_ICC;