[Home] [Help]
PACKAGE: APPS.ASO_ATP_INT
Source
1 PACKAGE aso_atp_int as
2 /* $Header: asoiatps.pls 120.2 2005/06/30 15:59:19 appldev ship $ */
3 -- Start of Comments
4 -- Package name : aso_atp_int
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12
13 --Action Code
14 ATPQUERY CONSTANT INTEGER := 100;
15
16 --Record Structure for getting ATP results
17
18 TYPE ATP_Rec_Typ is RECORD (
19 Inventory_Item_Id NUMBER,
20 Inventory_Item_Name VARCHAR2(240),
21 Inventory_Item_Description VARCHAR2(240),
22 Padded_Concatenated_Segments VARCHAR2(90),
23 Source_Organization_Id NUMBER,
24 Source_Organization_Code VARCHAR2(7),
25 Source_Organization_Name VARCHAR2(240),
26 Identifier NUMBER,
27 Customer_Id NUMBER,
28 Customer_Site_Id NUMBER,
29 Quantity_Ordered NUMBER,
30 Quantity_UOM VARCHAR2(3),
31 UOM_Meaning VARCHAR2(25),
32 Requested_Ship_Date DATE,
33 Ship_Date DATE,
34 Available_Quantity NUMBER,
35 Request_Date_Quantity NUMBER,
36 Error_Code NUMBER,
37 error_description varchar2(80),
38 Message VARCHAR2(2000),
39 request_date_type VARCHAR2(30),
40 request_date_type_meaning VARCHAR2(240),
41 demand_class_code VARCHAR2(30),
42 demand_class_meaning VARCHAR2(80),
43 ship_set_name VARCHAR2(30),
44 arrival_set_name VARCHAR2(30),
45 line_number varchar2(80),
46 group_ship_date Date,
47 requested_arrival_date Date,
48 ship_method_code varchar2(30),
49 ship_method_meaning varchar2(80),
50 quantity_on_hand Number,
51 shipment_id Number,
52 quote_header_id Number,
53 calling_module Number,
54 quote_number Number,
55 ato_line_id Number,
56 ref_line_id Number,
57 top_model_line_id Number,
58 action Number,
59 arrival_date DATE,
60 organization_id Number,
61 component_code varchar2(1200),
62 component_sequence_id Number,
63 included_item_flag Number,
64 cascade_model_info_to_comp Number,
65 ship_to_party_site_id Number,
66 country varchar2(60),
67 state varchar2(60),
68 city varchar2(60),
69 postal_code varchar2(60),
70 match_item_id number
71 );
72
73 TYPE ATP_Tbl_Typ IS TABLE OF ATP_Rec_Typ
74 INDEX BY BINARY_INTEGER;
75
76 -- API Name: Check_ATP
77 -- Type : Public
78 -- Pre-Req :
79
80 PROCEDURE Check_ATP(
81 P_Api_Version_Number IN NUMBER,
82 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
83 p_qte_line_tbl IN ASO_QUOTE_PUB.qte_line_tbl_type,
84 p_shipment_tbl IN ASO_QUOTE_PUB.shipment_tbl_type,
85 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
86 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
87 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
88 X_atp_tbl OUT NOCOPY /* file.sql.39 change */ aso_atp_int.atp_tbl_typ
89 );
90
91 PROCEDURE Check_ATP(
92 P_Api_Version_Number IN NUMBER,
93 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94 p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
95 p_qte_line_tbl IN ASO_QUOTE_PUB.qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
96 p_shipment_tbl IN ASO_QUOTE_PUB.shipment_tbl_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
97 p_entire_quote_flag IN VARCHAR2 :='N',
98 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
99 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
100 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
101 X_atp_tbl OUT NOCOPY /* file.sql.39 change */ aso_atp_int.atp_tbl_typ
102 );
103
104 PROCEDURE update_configuration(
105 P_Api_Version_Number IN NUMBER,
106 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
107 p_commit IN VARCHAR2 := FND_API.G_FALSE,
108 p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
109 p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
110 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
111 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
112 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113 );
114
115 End aso_atp_int;