1 PACKAGE EGO_ICC_STRUCTURE_PVT AUTHID CURRENT_USER AS
2 /* $Header: egoistps.pls 120.0.12010000.5 2009/08/20 11:15:42 sisankar noship $ */
3
4 /*
5 * This Procedure will delete the user attributes for components.
6 */
7 Procedure Delete_Comp_User_Attrs(p_comp_seq_id IN NUMBER);
8
9 /*
10 * This Procedure will revert the components for the Draft version of the ICC.
11 */
12 PROCEDURE Revert_draft_components (p_item_catalog_grp_id IN NUMBER,
13 p_version_seq_id IN NUMBER,
14 x_Return_Status OUT NOCOPY NUMBER,
15 x_Error_Message OUT NOCOPY VARCHAR2);
16
17 /*
18 * This Procedure will create the components for the newly released version of the ICC.
19 */
20 PROCEDURE Release_Components (p_item_catalog_grp_id IN NUMBER,
21 p_version_seq_id IN NUMBER,
22 p_start_date IN DATE,
23 x_Return_Status OUT NOCOPY NUMBER,
24 x_Error_Message OUT NOCOPY VARCHAR2);
25
26 /*
27 * This Function will get the ICC Name for a given Bill Seq Id.
28 */
29 Function getIccName(p_item_catalog_grp_id IN NUMBER,
30 p_parent_bill_seq_id IN NUMBER)
31 RETURN VARCHAR2;
32
33 /*
34 * This Function will get the effective version of a ICC for a given date.
35 */
36 Function Get_Effective_Version(p_item_catalog_grp_id IN NUMBER,
37 p_start_date IN DATE)
38 RETURN NUMBER;
39
40 /*
41 * This Function will get the effective version of a Parent ICC for a given date.
42 */
43 Function Get_Parent_Version(p_item_catalog_grp_id IN NUMBER,
44 p_start_date IN DATE)
45 RETURN NUMBER;
46
47 /*
48 * This Function will give whether Draft version has been updated or not.
49 */
50 Function Is_Structure_Updated(p_item_catalog_grp_id IN NUMBER,
51 p_start_date IN DATE)
52 RETURN NUMBER;
53
54 /*
55 * This Function will compare UDA values for two different components and gives whether they are same or different.
56 */
57
58 Function Compare_UDA_Values(p_draft_comp_seq_id IN NUMBER,
59 p_released_comp_seq_id IN NUMBER)
60 RETURN NUMBER;
61
62 Function Compare_components(p_draft_comp_seq_id IN NUMBER,
63 p_released_comp_seq_id IN NUMBER)
64 RETURN NUMBER;
65
66 /*
67 * This Procedure will inherit components to item structure from ICC structure when structure is created.
68 */
69
70 Procedure create_structure_inherit(p_inventory_item_id IN NUMBER,
71 p_organization_id IN NUMBER,
72 p_bill_seq_id IN NUMBER,
73 p_comm_bill_seq_id IN NUMBER,
74 p_structure_type_id IN NUMBER,
75 p_alt_desg IN VARCHAR2,
76 x_Return_Status OUT NOCOPY NUMBER,
77 x_Error_Message OUT NOCOPY VARCHAR2,
78 p_eff_control IN NUMBER);
79
80
81
82 PROCEDURE inherit_icc_components(p_inventory_item_id IN NUMBER,
83 p_organization_id IN NUMBER,
84 p_revision_id IN NUMBER,
85 p_rev_date IN DATE,
86 x_Return_Status OUT NOCOPY NUMBER,
87 x_Error_Message OUT NOCOPY VARCHAR2);
88
89 Function get_revision_start_date(p_rev_id in Number)
90 Return Date;
91
92 Function get_revision_end_date(p_rev_id in Number)
93 Return Date;
94
95 /*
96 * This Function will give whether item structure inherits components from icc structure or not.
97 */
98 Function Is_Structure_Inheriting(p_item_catalog_grp_id IN NUMBER,
99 p_organization_id IN NUMBER,
100 p_inv_item_id IN NUMBER,
101 p_structure_type_id IN NUMBER,
102 p_alt_desig IN VARCHAR2)
103 RETURN NUMBER;
104
105 /*
106 * This Procedure creates default structure header for versioned ICCs based on its hierarchy.
107 */
108 Procedure Create_Default_Header(p_item_catalog_grp_id IN NUMBER,
109 p_commit_flag IN NUMBER);
110
111 /*
112 * This Function gives whether Parent-ICC is updatable for a ICC.
113 */
114 Function Is_Parent_Updatable(p_item_catalog_grp_id IN NUMBER)
115 Return NUMBER;
116
117 /*
118 * This Function validates whether component Base Attributes are valid.
119 */
120 Function Validate_Base_attributes(
121 p_organization_id IN NUMBER,
122 p_operation_seq_num IN NUMBER,
123 p_component_item_id IN NUMBER,
124 p_item_num IN NUMBER,
125 p_basis_type IN NUMBER,
126 p_component_quantity IN NUMBER,
127 p_component_yield_factor IN NUMBER,
128 p_component_remarks IN VARCHAR2,
129 p_planning_factor IN NUMBER,
130 p_quantity_related IN NUMBER,
131 p_so_basis IN NUMBER,
132 p_optional IN NUMBER,
133 p_mutually_exclusive_options IN NUMBER,
134 p_include_in_cost_rollup IN NUMBER,
135 p_check_atp IN NUMBER,
136 p_shipping_allowed IN NUMBER,
137 p_required_to_ship IN NUMBER,
138 p_required_for_revenue IN NUMBER,
139 p_include_on_ship_docs IN NUMBER,
140 p_low_quantity IN NUMBER,
141 p_high_quantity IN NUMBER,
142 p_component_sequence_id IN NUMBER,
143 p_bill_sequence_id IN NUMBER,
147 p_supply_locator_id IN NUMBER,
144 p_wip_supply_type IN NUMBER,
145 p_pick_components IN NUMBER,
146 p_supply_subinventory IN VARCHAR2,
148 p_bom_item_type IN NUMBER,
149 p_component_item_revision_id IN NUMBER,
150 p_enforce_int_requirements IN NUMBER,
151 p_auto_request_material IN VARCHAR2,
152 p_component_name IN VARCHAR2)
153 Return NUMBER;
154
155 END EGO_ICC_STRUCTURE_PVT;