PACKAGE: APPS.INV_EBI_UTIL

Source

1 PACKAGE INV_EBI_UTIL AUTHID CURRENT_USER AS
2 /* $Header: INVEIUTLS.pls 120.7.12010000.4 2009/04/06 11:48:55 prepatel ship $ */
3 
4 G_EGO_ITEMMGMT_GROUP           CONSTANT  VARCHAR2(30)   := 'EGO_ITEMMGMT_GROUP';
5 G_ENG_CHANGEMGMT_GROUP         CONSTANT  VARCHAR2(30)   := 'ENG_CHANGEMGMT_GROUP';
6 G_BOM_STRUCTUREMGMT_GROUP      CONSTANT  VARCHAR2(30)   := 'BOM_STRUCTUREMGMT_GROUP';
7 G_BOM_COMPONENTMGMT_GROUP      CONSTANT  VARCHAR2(30)   := 'BOM_COMPONENTMGMT_GROUP';
8 G_CHANGE_LEVEL                 CONSTANT  VARCHAR2(30)   := 'CHANGE_LEVEL';
9 G_STRUCTURES_LEVEL             CONSTANT  VARCHAR2(30)   := 'STRUCTURES_LEVEL';
10 G_COMPONENTS_LEVEL             CONSTANT  VARCHAR2(30)   := 'COMPONENTS_LEVEL';
11 G_EGO_ITEM                     CONSTANT  VARCHAR2(30)   := 'EGO_ITEM';
12 G_CHANGE_OBJ_NAME              CONSTANT  VARCHAR2(30)   := 'ENG_CHANGE';
13 G_BOM_STRUCTURE_OBJ_NAME       CONSTANT  VARCHAR2(30)   := 'BOM_STRUCTURE';
14 G_BOM_COMPONENTS_OBJ_NAME      CONSTANT  VARCHAR2(30)   := 'BOM_COMPONENTS';
15 
16 G_DEBUG boolean default false;
17 
18 FUNCTION is_pim_installed RETURN BOOLEAN ;
19 
20 FUNCTION is_master_org(
21    p_organization_id IN   NUMBER
22  ) RETURN VARCHAR;
23 
24 FUNCTION is_master_org(
25    p_organization_code IN   VARCHAR2
26  ) RETURN VARCHAR;
27 FUNCTION get_master_organization(
28    p_organization_id IN NUMBER
29  ) RETURN NUMBER;
30 
31 PROCEDURE transform_uda (
32     p_uda_input_obj          IN  inv_ebi_uda_input_obj
33    ,x_attributes_row_table   OUT NOCOPY ego_user_attr_row_table
34    ,x_attributes_data_table  OUT NOCOPY ego_user_attr_data_table
35    ,x_return_status          OUT NOCOPY VARCHAR2 --Bug 7240247
36    ,x_msg_count              OUT NOCOPY NUMBER
37    ,x_msg_data               OUT NOCOPY VARCHAR2
38 );
39 PROCEDURE transform_attr_rowdata_uda(
40     p_attributes_row_table    IN          ego_user_attr_row_table
41     ,p_attributes_data_table  IN          ego_user_attr_data_table
42     ,x_uda_input_obj          OUT NOCOPY  inv_ebi_uda_input_obj
43     ,x_return_status          OUT NOCOPY VARCHAR2 --Bug 7240247
44     ,x_msg_count              OUT NOCOPY NUMBER
45     ,x_msg_data               OUT NOCOPY VARCHAR2
46 );
47 
48 FUNCTION get_config_param_value(
49    p_config_tbl        IN inv_ebi_name_value_tbl
50   ,p_config_param_name IN VARCHAR2
51 ) RETURN VARCHAR;
52 
53 FUNCTION get_error_table RETURN inv_ebi_error_tbl_type;
54 
55 FUNCTION get_error_table_msgtxt(
56   p_error_table    IN  inv_ebi_error_tbl_type
57 ) RETURN VARCHAR2;
58 
59 -- Bug 7240247
60 FUNCTION get_application_id(
61       p_application_short_name IN VARCHAR2
62  ) RETURN NUMBER ;
63 
64 PROCEDURE put_names(
65                 p_log_file              VARCHAR2,
66                 p_out_file              VARCHAR2,
67                 p_directory             VARCHAR2);
68 
69 PROCEDURE debug_line(
70                 p_text                  VARCHAR2 );
71 
72 PROCEDURE setup(
73                 p_filename              VARCHAR2 Default NULL
74                 );
75 
76 PROCEDURE wrapup;
77 
78 PROCEDURE set_apps_context( p_name_value_tbl IN inv_ebi_name_value_tbl);
79 
80 END INV_EBI_UTIL;