[Home] [Help]
PACKAGE: APPS.INV_LOT_EO_PVT
Source
1 package INV_LOT_EO_PVT as
2 /* $Header: INVLTEOS.pls 120.1 2006/09/15 23:51:32 janetli noship $ */
3 /*Exception definitions */
4 g_exc_error EXCEPTION;
5 g_exc_unexpected_error EXCEPTION;
6
7 procedure preprocess_lot(x_return_status out nocopy VARCHAR2
8 , x_msg_count out nocopy NUMBER
9 , x_msg_data out nocopy VARCHAR2
10 , p_inventory_item_id NUMBER
11 , p_organization_id NUMBER
12 , p_lot_number VARCHAR2
13 , p_parent_lot_number VARCHAR2
14 , p_reference_inventory_item_id NUMBER
15 , p_reference_lot_number VARCHAR2 -- OSFM need this to inherite the attributes
16 , p_source NUMBER
17 , x_is_new_lot out nocopy VARCHAR2
18 );
19
20 procedure delete_lot(x_return_status out nocopy VARCHAR2
21 , x_msg_count out nocopy NUMBER
22 , x_msg_data out nocopy VARCHAR2
23 , p_inventory_item_id NUMBER
24 , p_organization_id NUMBER
25 , p_lot_number VARCHAR2
26 );
27
28 procedure rosetta_table_copy_in_p0(t out nocopy inv_lot_api_pub.char_tbl, a0 JTF_VARCHAR2_TABLE_1000);
29 procedure rosetta_table_copy_out_p0(t inv_lot_api_pub.char_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_1000);
30
31 procedure rosetta_table_copy_in_p1(t out nocopy inv_lot_api_pub.number_tbl, a0 JTF_NUMBER_TABLE);
32 procedure rosetta_table_copy_out_p1(t inv_lot_api_pub.number_tbl, a0 out nocopy JTF_NUMBER_TABLE);
33
34 procedure rosetta_table_copy_in_p2(t out nocopy inv_lot_api_pub.date_tbl, a0 JTF_DATE_TABLE);
35 procedure rosetta_table_copy_out_p2(t inv_lot_api_pub.date_tbl, a0 out nocopy JTF_DATE_TABLE);
36
37 procedure create_inv_lot(x_return_status out nocopy VARCHAR2
38 , x_msg_count out nocopy NUMBER
39 , x_msg_data out nocopy VARCHAR2
40 , p_inventory_item_id NUMBER
41 , p_organization_id NUMBER
42 , p_lot_number VARCHAR2
43 , p_expiration_date DATE
44 , p_disable_flag NUMBER
45 , p_attribute_category VARCHAR2
46 , p_lot_attribute_category VARCHAR2
47 , p_attributes_tbl JTF_VARCHAR2_TABLE_1000
48 , p_c_attributes_tbl JTF_VARCHAR2_TABLE_1000
49 , p_n_attributes_tbl JTF_NUMBER_TABLE
50 , p_d_attributes_tbl JTF_DATE_TABLE
51 , p_grade_code VARCHAR2
52 , p_origination_date DATE
53 , p_date_code VARCHAR2
54 , p_status_id NUMBER
55 , p_change_date DATE
56 , p_age NUMBER
57 , p_retest_date DATE
58 , p_maturity_date DATE
59 , p_item_size NUMBER
60 , p_color VARCHAR2
61 , p_volume NUMBER
62 , p_volume_uom VARCHAR2
63 , p_place_of_origin VARCHAR2
64 , p_best_by_date DATE
65 , p_length NUMBER
66 , p_length_uom VARCHAR2
67 , p_recycled_content NUMBER
68 , p_thickness NUMBER
69 , p_thickness_uom VARCHAR2
70 , p_width NUMBER
71 , p_width_uom VARCHAR2
72 , p_territory_code VARCHAR2
73 , p_supplier_lot_number VARCHAR2
74 , p_vendor_name VARCHAR2
75 , p_source NUMBER
76 );
77 procedure update_inv_lot(x_return_status out nocopy VARCHAR2
78 , x_msg_count out nocopy NUMBER
79 , x_msg_data out nocopy VARCHAR2
80 , p_inventory_item_id NUMBER
81 , p_organization_id NUMBER
82 , p_lot_number VARCHAR2
83 , p_expiration_date DATE
84 , p_disable_flag NUMBER
85 , p_attribute_category VARCHAR2
86 , p_lot_attribute_category VARCHAR2
87 , p_attributes_tbl JTF_VARCHAR2_TABLE_1000
88 , p_c_attributes_tbl JTF_VARCHAR2_TABLE_1000
89 , p_n_attributes_tbl JTF_NUMBER_TABLE
90 , p_d_attributes_tbl JTF_DATE_TABLE
91 , p_grade_code VARCHAR2
92 , p_origination_date DATE
93 , p_date_code VARCHAR2
94 , p_status_id NUMBER
95 , p_change_date DATE
96 , p_age NUMBER
97 , p_retest_date DATE
98 , p_maturity_date DATE
99 , p_item_size NUMBER
100 , p_color VARCHAR2
101 , p_volume NUMBER
102 , p_volume_uom VARCHAR2
103 , p_place_of_origin VARCHAR2
104 , p_best_by_date DATE
105 , p_length NUMBER
106 , p_length_uom VARCHAR2
107 , p_recycled_content NUMBER
108 , p_thickness NUMBER
109 , p_thickness_uom VARCHAR2
110 , p_width NUMBER
111 , p_width_uom VARCHAR2
112 , p_territory_code VARCHAR2
113 , p_supplier_lot_number VARCHAR2
114 , p_vendor_name VARCHAR2
115 , p_source NUMBER
116 );
117 end INV_LOT_EO_PVT;