PACKAGE: APPS.EGO_ORCHESTRATION_UTIL_PUB

Source

1 package ego_orchestration_util_pub as
2 /* $Header: EGOORCHS.pls 120.1 2007/05/18 10:52:15 pdutta noship $ */
3 
4 C_OBSOLETE_STATUS  	    NUMBER := -1;
5 C_TRANSACTION_SYNC      VARCHAR2(10) := 'SYNC';
6 C_INIT_PROCESS_FLAG     NUMBER := 0;
7 G_RET_STS_SUCCESS   CONSTANT    VARCHAR2(1)  :=  FND_API.g_RET_STS_SUCCESS;     --'S'
8 G_RET_STS_ERROR     CONSTANT    VARCHAR2(1)  :=  FND_API.g_RET_STS_ERROR;       --'E'
9 G_RET_STS_UNEXP_ERROR   CONSTANT    VARCHAR2(1)  :=  FND_API.g_RET_STS_UNEXP_ERROR; --'U'
10 
11 
12 
13 FUNCTION PRE_PRE_PROCESS_BATCHES ( X_BUNDLE_COLLECTION_ID IN NUMBER,
14                                    X_COMMIT               IN VARCHAR2
15                                  )
16                                  RETURN NUMBER;
17 
18 PROCEDURE GET_SUPPLIER_INFO ( X_EXT_SUP_ID            IN VARCHAR2,
19                               X_EXT_SUP_TYPE          IN VARCHAR2,
20                               X_SUP_LEVEL             IN VARCHAR2,
21                               X_SUPPLIER_ID           OUT NOCOPY NUMBER,
22                               X_SUPPLIER_NAME         OUT NOCOPY VARCHAR2
23                             );
24 
25 
26 PROCEDURE ADD_BUNDLES_TO_COL (x_bundle_collection_id   IN NUMBER,
27                               p_bundles_clob           IN CLOB,
28                               x_new_bundle_col_id      OUT NOCOPY NUMBER,
29                               p_commit                 IN VARCHAR2 := 'Y',
30                               p_entity_name            IN VARCHAR2 := 'BUNDLE'
31                               );
32 
33 
34 FUNCTION GET_BUNDLES_FROM_COL ( p_bundle_collection_id   IN NUMBER,
35                                  p_prior_bundle_id        IN NUMBER,
36                                  p_max_elements           IN NUMBER
37                               )
38                                RETURN XMLTYPE;
39 
40 PROCEDURE SAVE_DATA ( p_xml_clob           IN  CLOB,
41                       p_commit             IN  VARCHAR2,
42                       p_source_sys_id      IN  NUMBER,
43                       p_default_batch      IN  VARCHAR2,
44                       x_new_bundle_col_id  OUT NOCOPY NUMBER,
45                       x_err_bundle_col_id  OUT NOCOPY NUMBER);
46 
47 PROCEDURE PROCESS_TL_ROWS(p_table_name     IN VARCHAR2,
48                 p_batch_id       IN NUMBER,
49                 p_unique_id      IN NUMBER,
50                 p_bundle_id      IN NUMBER,
51                 p_xml_data       IN XMLTYPE,
52                 p_entity_name    IN VARCHAR2,
53                 p_column_name    IN VARCHAR2
54                 );
55 
56 
57 PROCEDURE Set_ICC_For_Rec_Bundle
58 (  p_rb_id              IN          NUMBER ,
59    x_Status               OUT NOCOPY  VARCHAR2,
60    x_Gpc_list             OUT NOCOPY  VARCHAR2
61 );
62 
63 PROCEDURE Set_ACC_For_Rec_Bundle
64 (  p_rb_id              IN          NUMBER ,
65    x_Status               OUT NOCOPY  VARCHAR2,
66    x_Gpc_list             OUT NOCOPY  VARCHAR2
67 );
68 
69 
70 PROCEDURE Set_ICC_For_Rec_Collection
71 (  p_rc_id              IN          NUMBER ,
72    x_BundleWithICC               OUT NOCOPY  NUMBER,
73    x_BundleWithoutICC             OUT NOCOPY  NUMBER
74 );
75 
76 PROCEDURE Set_ACC_For_Rec_Collection
77 (  p_rc_id              IN          NUMBER ,
78    x_BundleWithACC               OUT NOCOPY  NUMBER,
79    x_BundleWithoutACC             OUT NOCOPY  NUMBER
80 );
81 
82 PROCEDURE validate_batch
83 (   p_batch_name IN VARCHAR2 ,
84     p_default_batch_name IN VARCHAR2 ,
85     x_batch_id OUT NOCOPY  NUMBER,
86     x_error_msg OUT NOCOPY  VARCHAR2
87 );
88 
89 END EGO_ORCHESTRATION_UTIL_PUB;
90 
91