PACKAGE: APPS.OE_ITORD_PUB

Source

1 PACKAGE OE_ITORD_PUB AS
2 /* $Header: OEXPITOS.pls 120.1 2008/01/24 08:36:55 smanian noship $ */
3 
4 TYPE Item_Orderability_Import_Rec IS RECORD
5 (
6     ORG_ID               number
7  ,  INVENTORY_ITEM_ID    number
8  ,  ITEM_CATEGORY_ID     number
9  ,  ITEM_LEVEL           varchar2(1)
10  ,  GENERALLY_AVAILABLE  varchar2(1)
11  ,  RULE_LEVEL              VARCHAR2(30)
12  ,  CUSTOMER_ID             NUMBER
13  ,  CUSTOMER_CLASS_ID       NUMBER
14  ,  CUSTOMER_CATEGORY_CODE  VARCHAR2(30)
15  ,  REGION_ID               NUMBER
16  ,  ORDER_TYPE_ID           NUMBER
17  ,  SHIP_TO_LOCATION_ID     NUMBER
18  ,  SALES_CHANNEL_CODE      VARCHAR2(30)
19  ,  SALES_PERSON_ID         NUMBER
20  ,  END_CUSTOMER_ID         NUMBER
21  ,  BILL_TO_LOCATION_ID     NUMBER
22  ,  DELIVER_TO_LOCATION_ID  NUMBER
23  ,  ENABLE_FLAG             VARCHAR2(1)
24  ,  CREATED_BY           NUMBER
25  ,  CREATION_DATE        DATE
26  ,  LAST_UPDATED_BY      NUMBER
27  ,  LAST_UPDATE_DATE     DATE
28  , CONTEXT                 VARCHAR2(250)
29  ,  ATTRIBUTE1              VARCHAR2(250)
30  , ATTRIBUTE2              VARCHAR2(250)
31  , ATTRIBUTE3              VARCHAR2(250)
32  , ATTRIBUTE4              VARCHAR2(250)
33  , ATTRIBUTE5              VARCHAR2(250)
34  , ATTRIBUTE6              VARCHAR2(250)
35  , ATTRIBUTE7              VARCHAR2(250)
36  , ATTRIBUTE8              VARCHAR2(250)
37  , ATTRIBUTE9              VARCHAR2(250)
38  , ATTRIBUTE10             VARCHAR2(250)
39  , ATTRIBUTE11             VARCHAR2(250)
40  , ATTRIBUTE12             VARCHAR2(250)
41  , ATTRIBUTE13             VARCHAR2(250)
42  , ATTRIBUTE14             VARCHAR2(250)
43  , ATTRIBUTE15             VARCHAR2(250)
44  , ATTRIBUTE16             VARCHAR2(250)
45  , ATTRIBUTE17             VARCHAR2(250)
46  , ATTRIBUTE18             VARCHAR2(250)
47  , ATTRIBUTE19             VARCHAR2(250)
48  , ATTRIBUTE20             VARCHAR2(250)
49  , status		   VARCHAR2(1)
50  , msg_count              number
51  , msg_data               VARCHAR2(5000)
52 );
53 
54 TYPE Item_Orderability_Import_Tbl  IS TABLE OF Item_Orderability_Import_Rec
55 INDEX BY BINARY_INTEGER;
56 
57 
58 Procedure Import_Item_orderability_rules (  p_Item_Orderability_Import_Tbl IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Tbl
59                                            ,p_commit_flag IN Varchar2 DEFAULT 'N' );
60 
61 
62 Procedure  Check_required_fields ( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec );
63 
64 
65 Procedure  Validate_required_fields ( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec );
66 
67 
68 Procedure Validate_conditional_fields ( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec );
69 
70 
71 Procedure Check_duplicate_rules ( p_Item_Orderability_Import_Rec IN OUT NOCOPY  OE_ITORD_PUB.Item_Orderability_Import_Rec );
72 
73 
74 Procedure get_rule_coulumn_details( p_Item_Orderability_Import_Rec IN OE_ITORD_PUB.Item_Orderability_Import_Rec ,
75 				    x_rule_level_column  OUT NOCOPY VARCHAR2,
76 				    x_rule_level_value   OUT NOCOPY VARCHAR2,
77 				    x_data_type          OUT NOCOPY VARCHAR2
78    			           );
79 
80 
81 Procedure Validate_rules_DFF (p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec );
82 
83 Procedure insert_rules( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec );
84 
85 END OE_ITORD_PUB;