[Home] [Help]
PACKAGE: APPS.INV_EBI_CHANGE_ORDER_HELPER
Source
1 PACKAGE INV_EBI_CHANGE_ORDER_HELPER AS
2 /* $Header: INVEIHCOS.pls 120.16.12010000.4 2009/02/23 16:22:58 prepatel ship $ */
3
4 G_INCLUDE_REV_ITEMS CONSTANT VARCHAR2(50) := 'INCLUDE_REVISED_ITEMS';
5 G_INCLUDE_COMP_ITEMS CONSTANT VARCHAR2(50) := 'INCLUDE_COMPONENT_ITEMS';
6 G_INCLUDE_SUB_COMP CONSTANT VARCHAR2(50) := 'INCLUDE_SUBSTITUTE_COMPONENTS';
7 G_INCLUDE_REF_DESIGNATORS CONSTANT VARCHAR2(50) := 'INCLUDE_REFERENCE_DESIGNATORS';
8 G_VIEW_SCOPE_ALL CONSTANT VARCHAR2(3) := 'ALL';
9 G_VIEW_SCOPE_CURRENT CONSTANT VARCHAR2(50) := 'CURRENT';
10 G_VIEW_SCOPE_CURR_FUTURE CONSTANT VARCHAR2(50) := 'CURRENT_AND_FUTURE';
11 G_IMPLEMENT_SCOPE_IMPLEMENT CONSTANT VARCHAR2(50) := 'IMPLEMENTED';
12 G_IMPLEMENT_SCOPE_UNIMPLEMENT CONSTANT VARCHAR2(50) := 'UNIMPLEMENTED';
13 G_ASSIGN_ITEM_TO_CHILD_ORG CONSTANT VARCHAR2(50) := 'ASSIGN_ITEM_TO_CHILD_ORG';
14 G_DEFAULT_STRUCTURE_TYPE CONSTANT VARCHAR2(50) := 'DEFAULT_STRUCTURE_TYPE';
15 G_PLM_OR_ERP_CHANGE CONSTANT VARCHAR2(50) := 'CREATE_ERP_CHANGE_ORDER';
16 G_ASSIGN_ITEM VARCHAR2(1) := fnd_api.g_false;
17 PROCEDURE process_eco(
18 p_commit IN VARCHAR2 := FND_API.G_FALSE
19 ,p_change_order IN inv_ebi_change_order_obj
20 ,p_revision_type_tbl IN inv_ebi_eco_revision_tbl
21 ,p_revised_item_type_tbl IN inv_ebi_revised_item_tbl
22 ,p_name_val_list IN inv_ebi_name_value_list
23 ,x_out OUT NOCOPY inv_ebi_eco_output_obj
24 ) ;
25
26 PROCEDURE process_structure_header(
27 p_commit IN VARCHAR2 := FND_API.G_FALSE
28 ,p_organization_code IN VARCHAR2
29 ,p_assembly_item_name IN VARCHAR2
30 ,p_alternate_bom_code IN VARCHAR2
31 ,p_structure_header IN inv_ebi_structure_header_obj
32 ,p_component_item_tbl IN inv_ebi_rev_comp_tbl
33 ,p_name_val_list IN inv_ebi_name_value_list
34 ,x_out OUT NOCOPY inv_ebi_eco_output_obj
35 ) ;
36
37 PROCEDURE process_uda (
38 p_commit IN VARCHAR2 := FND_API.g_false
39 ,p_api_version IN NUMBER DEFAULT 1.0
40 ,p_uda_input_obj IN inv_ebi_uda_input_obj
41 ,p_object_name IN VARCHAR2
42 ,p_data_level IN VARCHAR2
43 ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
44 ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
45 ,x_uda_output_obj OUT NOCOPY inv_ebi_eco_output_obj
46 );
47
48 PROCEDURE process_change_order_uda(
49 p_commit IN VARCHAR2
50 ,p_organization_code IN VARCHAR2
51 ,p_eco_name IN VARCHAR2
52 ,p_alternate_bom_code IN VARCHAR2
53 ,p_revised_item_name IN VARCHAR2
54 ,p_component_tbl IN inv_ebi_rev_comp_tbl
55 ,p_structure_header IN inv_ebi_structure_header_obj
56 ,x_out OUT NOCOPY inv_ebi_eco_output_obj
57 );
58
59 PROCEDURE get_eco (
60 p_change_id IN NUMBER
61 ,p_last_update_status IN VARCHAR2
62 ,p_revised_item_sequence_id IN NUMBER
63 ,p_name_val_list IN inv_ebi_name_value_list
64 ,x_eco_obj OUT NOCOPY inv_ebi_eco_obj
65 ,x_return_status OUT NOCOPY VARCHAR2
66 ,x_msg_count OUT NOCOPY NUMBER
67 ,x_msg_data OUT NOCOPY VARCHAR2
68 );
69
70 PROCEDURE process_replicate_bom(
71 p_eco_obj IN inv_ebi_eco_obj
72 ,x_eco_obj OUT NOCOPY inv_ebi_eco_obj
73 ,x_out OUT NOCOPY inv_ebi_eco_output_obj
74 );
75
76 PROCEDURE get_eco_list(
77 p_name_value_list IN inv_ebi_name_value_tbl
78 ,p_prog_id IN NUMBER
79 ,p_appl_id IN NUMBER
80 ,x_eco OUT NOCOPY inv_ebi_change_id_obj_tbl
81 ,x_return_status OUT NOCOPY VARCHAR2
82 ,x_msg_count OUT NOCOPY NUMBER
83 ,x_msg_data OUT NOCOPY VARCHAR2
84 );
85
86 FUNCTION Check_Workflow_Process(
87 p_change_order_type_id IN NUMBER
88 ,p_priority_code IN VARCHAR2
89 ) RETURN BOOLEAN;
90
91 PROCEDURE set_assign_item(
92 p_assign_item IN VARCHAR2
93 ) ;
94
95 FUNCTION get_current_item_revision(
96 p_inventory_item_id IN NUMBER,
97 p_organization_id IN NUMBER,
98 p_date IN DATE
99 ) RETURN VARCHAR2;
100
101
102 FUNCTION is_child_org (
103 p_organization_id IN NUMBER
104 ) RETURN VARCHAR2;
105
106 FUNCTION is_task_template_set(
107 p_change_order_type_id IN NUMBER
108 ,p_organization_id IN NUMBER
109 ,p_status_code IN NUMBER
110 ) RETURN BOOLEAN;
111
112 FUNCTION get_eco_status_name(p_status_code IN NUMBER)
113 RETURN VARCHAR2;
114
115 FUNCTION get_change_type_code(p_change_type_id IN NUMBER )
116 RETURN VARCHAR2;
117
118 END INV_EBI_CHANGE_ORDER_HELPER;