1 PACKAGE BOM_UTIL as
2 /* $Header: BOMUTILS.pls 120.0 2006/03/14 15:51:22 seradhak noship $ */
3 FUNCTION get_first_level_components
4 (p_cbill_sequence_id IN
5 BOM_BILL_OF_MATERIALS.bill_sequence_id%TYPE)
6 RETURN NUMBER;
7 -- --------------------------------
8 FUNCTION get_second_level_components
9 (p_component_item_id IN
10 BOM_INVENTORY_COMPONENTS.component_item_id%TYPE,
11 p_organization_id IN NUMBER,
12 p_alternate_bom_designator IN VARCHAR2)
13 RETURN NUMBER;
14 -- --------------------------------
15 FUNCTION get_change_order_count
16 (p_bill_sequence_id IN
17 BOM_BILL_OF_MATERIALS.bill_sequence_id%TYPE)
18 RETURN NUMBER;
19 -- --------------------------------
20 FUNCTION get_effective_date(p_structure_type_id IN NUMBER)
21 RETURN DATE ;
22 -- --------------------------------
23 FUNCTION get_disable_date(p_structure_type_id IN NUMBER)
24 RETURN DATE ;
25 -- --------------------------------
26 FUNCTION check_structures_exist(p_structure_type_id IN NUMBER)
27 RETURN VARCHAR2;
28 -- --------------------------------
29 FUNCTION check_id_exist(p_structure_type_id IN NUMBER)
30 RETURN VARCHAR2;
31 -- --------------------------------
32 FUNCTION getFirstLevelComponents(p_component_item_id IN NUMBER,
33 p_bill_sequence_id IN NUMBER,
34 p_top_bill_sequence_id IN NUMBER,
35 p_plan_level IN NUMBER,
36 p_organization_id IN NUMBER)
37 RETURN NUMBER;
38 -- ---------------------------------------
39 PROCEDURE validate_RefDesig_Entity
40 ( p_organization_id IN NUMBER
41 , p_component_seq_id IN NUMBER
42 , p_ref_desig_name IN VARCHAR2
43 , p_acd_type IN NUMBER
44 , x_return_status IN OUT NOCOPY VARCHAR2
45 );
46 -- ----------------------------------------------------------------------
47 PROCEDURE check_RefDesig_Access
48 ( p_organization_id IN NUMBER
49 , p_assembly_item_id IN NUMBER
50 , p_alternate_bom_code IN VARCHAR2
51 , p_ref_desig_name IN VARCHAR2
52 , p_component_item_id IN NUMBER
53 , p_component_item_name IN VARCHAR2
54 , p_component_seq_id IN NUMBER
55 , x_return_status IN OUT NOCOPY VARCHAR2
56 );
57 -- -----------------------------------------------------------------------
58 PROCEDURE get_RefDesig_Quantity
59 ( p_component_seq_id IN NUMBER
60 , p_acd_type IN NUMBER
61 , x_refdesig_qty IN OUT NOCOPY NUMBER
62 , x_qty_related IN OUT NOCOPY NUMBER
63 , x_comp_qty IN OUT NOCOPY NUMBER
64 );
65 -- -----------------------------------------------------------------------
66 FUNCTION get_person_name(p_user_id IN NUMBER) RETURN VARCHAR2;
67 -- -----------------------------------------------------------------------
68 FUNCTION get_change_notice(p_change_line_id IN NUMBER) return VARCHAR2;
69 -- -----------------------------------------------------------------------
70 FUNCTION get_implemen_date(p_bill_sequence_id IN NUMBER)
71 RETURN DATE;
72 END BOM_UTIL;