[Home] [Help]
PACKAGE: APPS.BOM_GTIN_RULES
Source
1 PACKAGE BOM_GTIN_Rules AS
2 /* $Header: BOMLGTNS.pls 120.4 2007/07/19 09:34:31 dikrishn ship $ */
3 /****************************************************************************
4 --
5 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- BOMLGTNS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Package spec: BOM Validations for GTIN
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 18-MAY-04 Refai Farook Initial Creation
21 --
22 --
23 ****************************************************************************/
24
25 PROCEDURE Check_GTIN_Attributes ( p_bill_sequence_id IN NUMBER := NULL,
26 p_assembly_item_id NUMBER,
27 p_organization_id IN NUMBER,
28 p_alternate_bom_code IN VARCHAR2 := NULL,
29 p_component_item_id IN NUMBER,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_error_message OUT NOCOPY VARCHAR2);
32
33 /* Overloaded method with p_ignore_published for rollups to ignore
34 * published hierarchies exception */
35 PROCEDURE Check_GTIN_Attributes ( p_bill_sequence_id IN NUMBER := NULL,
36 p_assembly_item_id NUMBER,
37 p_organization_id IN NUMBER,
38 p_alternate_bom_code IN VARCHAR2 := NULL,
39 p_component_item_id IN NUMBER,
40 p_ignore_published IN VARCHAR2,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_error_message OUT NOCOPY VARCHAR2);
43
44 PROCEDURE Update_Top_GTIN( p_organization_id IN NUMBER,
45 p_component_item_id IN NUMBER,
46 p_parent_item_id in NUMBER := NULL,
47 p_structure_name in VARCHAR2 := NULL);
48
49
50 /* Returns the uom conversion rate
51 Returns -99999 when any error occurs */
52
53
54 FUNCTION Get_Suggested_Quantity ( p_component_item_id IN NUMBER,
55 p_component_uom IN VARCHAR2,
56 p_assembly_uom IN VARCHAR2) RETURN NUMBER;
57 FUNCTION Pack_Check(p_item_id IN NUMBER , p_org_id IN NUMBER) return
58 VARCHAR2;
59
60 /*
61 FUNCTION Get_Suggested_Quantity ( p_component_item_id IN NUMBER,
62 p_component_uom_name IN VARCHAR2,
63 p_assembly_uom_name IN VARCHAR2) RETURN NUMBER;
64 */
65
66 FUNCTION Get_Suggested_Quantity ( p_organization_id IN NUMBER,
67 p_assembly_item_id NUMBER,
68 p_component_item_id IN NUMBER ) RETURN NUMBER;
69
70 PROCEDURE Perform_Rollup
71 ( p_item_id IN NUMBER
72 , p_organization_id IN NUMBER
73 , p_parent_item_id IN NUMBER := NULL
74 , p_structure_type_name IN VARCHAR2
75 , p_transaction_type IN VARCHAR2
76 , p_validate IN VARCHAR2 := 'N'
77 , p_halt_on_error IN VARCHAR2 := 'N'
78 , p_structure_name IN VARCHAR2 := NULL
79 , x_error_message OUT NOCOPY VARCHAR2
80 );
81
82
83 PROCEDURE UPDATE_REG_PUB_UPDATE_DATES (p_inventory_item_id NUMBER,
84 p_organization_id IN NUMBER,
85 p_update_reg IN VARCHAR2 := 'N',
86 p_commit IN VARCHAR2 := FND_API.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2
90 );
91
92 PROCEDURE GET_UOM_CLASS_COMPATIBILITY(p_src_uom_code IN VARCHAR2,
93 p_dest_uom_code IN VARCHAR2,
94 x_compatibility_status OUT NOCOPY VARCHAR2);
95
96 PROCEDURE GET_UOM_CLASS_COMPATIBILITY(p_source_item_id IN NUMBER,
97 p_destn_item_id IN NUMBER,
98 p_src_org_id IN NUMBER,
99 p_dest_org_id IN NUMBER,
100 x_compatibility_status OUT NOCOPY VARCHAR2);
101
102 PROCEDURE Validate_Hierarchy_Attrs ( p_group_id IN NUMBER,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_error_message OUT NOCOPY VARCHAR2);
105
106
107 END BOM_GTIN_Rules;