[Home] [Help]
PACKAGE: APPS.INV_EBI_CHANGE_ORDER_HELPER
Source
1 PACKAGE INV_EBI_CHANGE_ORDER_HELPER AUTHID CURRENT_USER AS
2 /* $Header: INVEIHCOS.pls 120.22.12020000.3 2012/07/19 05:33:04 smukka 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 G_BOM_UPDATES_ALLOWED CONSTANT VARCHAR2(50) := 'STANDALONE_BOM_UPDATES_ALLOWED';
18 G_ALLOW_UNIMP_BOM_UPDATES CONSTANT VARCHAR2(50) := 'UNIMPLEMENTED_BOM_UPDATES_ALLOWED';
19
20 PROCEDURE process_eco(
21 p_commit IN VARCHAR2 := FND_API.G_FALSE
22 ,p_change_order IN inv_ebi_change_order_obj
23 ,p_revision_type_tbl IN inv_ebi_eco_revision_tbl
24 ,p_revised_item_type_tbl IN inv_ebi_revised_item_tbl
25 ,p_name_val_list IN inv_ebi_name_value_list
26 ,x_out OUT NOCOPY inv_ebi_eco_output_obj
27 ) ;
28
29 PROCEDURE process_structure_header(
30 p_commit IN VARCHAR2 := FND_API.G_FALSE
31 ,p_organization_code IN VARCHAR2
32 ,p_assembly_item_name IN VARCHAR2
33 ,p_alternate_bom_code IN VARCHAR2
34 ,p_structure_header IN inv_ebi_structure_header_obj
35 ,p_component_item_tbl IN inv_ebi_rev_comp_tbl
36 ,p_name_val_list IN inv_ebi_name_value_list
37 ,x_out OUT NOCOPY inv_ebi_eco_output_obj
38 ) ;
39
40 PROCEDURE process_uda (
41 p_commit IN VARCHAR2 := FND_API.g_false
42 ,p_api_version IN NUMBER DEFAULT 1.0
43 ,p_uda_input_obj IN inv_ebi_uda_input_obj
44 ,p_object_name IN VARCHAR2
45 ,p_data_level IN VARCHAR2
46 ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
47 ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
48 ,x_uda_output_obj OUT NOCOPY inv_ebi_eco_output_obj
49 );
50
51 PROCEDURE process_change_order_uda(
52 p_commit IN VARCHAR2
53 ,p_organization_code IN VARCHAR2
54 ,p_eco_name IN VARCHAR2
55 ,p_alternate_bom_code IN VARCHAR2
56 ,p_revised_item_name IN VARCHAR2
57 ,p_component_tbl IN inv_ebi_rev_comp_tbl
58 ,p_structure_header IN inv_ebi_structure_header_obj
59 ,x_out OUT NOCOPY inv_ebi_eco_output_obj
60 );
61
62 PROCEDURE get_eco (
63 p_change_id IN NUMBER
64 ,p_last_update_status IN VARCHAR2
65 ,p_revised_item_sequence_id IN NUMBER
66 ,p_name_val_list IN inv_ebi_name_value_list
67 ,x_eco_obj OUT NOCOPY inv_ebi_eco_obj
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73 PROCEDURE process_replicate_bom(
74 p_organization_code IN VARCHAR2
75 ,p_revised_item_obj IN inv_ebi_revised_item_obj
76 ,p_name_value_tbl IN inv_ebi_name_value_tbl
77 ,x_revised_item_obj OUT NOCOPY inv_ebi_revised_item_obj
78 ,x_out OUT NOCOPY inv_ebi_eco_output_obj
79 ) ;
80
81 PROCEDURE get_eco_list(
82 p_name_value_list IN inv_ebi_name_value_tbl
83 ,p_prog_id IN NUMBER
84 ,p_appl_id IN NUMBER
85 ,x_eco OUT NOCOPY inv_ebi_change_id_obj_tbl
86 ,x_return_status OUT NOCOPY VARCHAR2
87 ,x_msg_count OUT NOCOPY NUMBER
88 ,x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91 FUNCTION Check_Workflow_Process(
92 p_change_order_type_id IN NUMBER
93 ,p_priority_code IN VARCHAR2
94 ) RETURN BOOLEAN;
95
96 PROCEDURE set_assign_item(
97 p_assign_item IN VARCHAR2
98 ) ;
99
100 FUNCTION get_current_item_revision(
101 p_inventory_item_id IN NUMBER,
102 p_organization_id IN NUMBER,
103 p_date IN DATE
104 ) RETURN VARCHAR2;
105
106
107 FUNCTION is_child_org (
108 p_organization_id IN NUMBER
109 ) RETURN VARCHAR2;
110
111 FUNCTION is_task_template_set(
112 p_change_order_type_id IN NUMBER
113 ,p_organization_id IN NUMBER
114 ,p_status_code IN NUMBER
115 ) RETURN BOOLEAN;
116
117 FUNCTION get_eco_status_name(p_status_code IN NUMBER)
118 RETURN VARCHAR2;
119
120 FUNCTION get_change_type_code(p_change_type_id IN NUMBER )
121 RETURN VARCHAR2;
122
123 PROCEDURE transform_replicate_bom_info(
124 p_eco_obj_list IN inv_ebi_eco_obj_tbl
125 ,p_revised_item_obj IN inv_ebi_revised_item_obj
126 ,x_revised_item_obj OUT NOCOPY inv_ebi_revised_item_obj
127 ,x_out OUT NOCOPY inv_ebi_eco_output_obj
128 ) ;
129
130 FUNCTION is_bom_exists(
131 p_item_number IN VARCHAR2
132 ,p_organization_code IN VARCHAR2
133 ,p_alternate_bom_code IN VARCHAR2
134 ) RETURN VARCHAR2;
135
136 --Added for bug 13893810
137 FUNCTION Check_Workflow_In_PLM(
138 p_change_id IN NUMBER
139 ) RETURN BOOLEAN;
140
141 END INV_EBI_CHANGE_ORDER_HELPER;