eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.INV_SERIAL_EO_PVT

Source


1 package INV_SERIAL_EO_PVT as
2   /* $Header: INVSNEOS.pls 120.1 2005/07/05 14:09 jxlu noship $ */
3       /*Exception definitions */
4     g_exc_error                    EXCEPTION;
5     g_exc_unexpected_error         EXCEPTION;
6 
7 
8  procedure preprocess_serial(x_return_status out nocopy  VARCHAR2
9         , x_msg_count out nocopy  NUMBER
10         , x_msg_data out nocopy  VARCHAR2
11         , p_inventory_item_id  NUMBER
12         , p_organization_id  NUMBER
13         , p_lot_number  VARCHAR2
14         , p_parent_lot_number  VARCHAR2
15         , p_from_serial_number VARCHAR2
16         , x_is_new_serial out nocopy VARCHAR2
17         , p_revision VARCHAR2
18         , p_to_serial_number VARCHAR2
19 
20   );
21 
22   procedure delete_serial(x_return_status out nocopy  VARCHAR2
23               , x_msg_count out nocopy  NUMBER
24               , x_msg_data out nocopy  VARCHAR2
25               , p_inventory_item_id  NUMBER
26               , p_organization_id  NUMBER
27               , p_from_serial_number  VARCHAR2
28               , p_to_serial_number VARCHAR2
29     );
30 
31   procedure rosetta_table_copy_in_p0(t out nocopy inv_lot_api_pub.char_tbl, a0 JTF_VARCHAR2_TABLE_1000);
32   procedure rosetta_table_copy_out_p0(t inv_lot_api_pub.char_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_1000);
33 
34   procedure rosetta_table_copy_in_p1(t out nocopy inv_lot_api_pub.number_tbl, a0 JTF_NUMBER_TABLE);
35   procedure rosetta_table_copy_out_p1(t inv_lot_api_pub.number_tbl, a0 out nocopy JTF_NUMBER_TABLE);
36 
37   procedure rosetta_table_copy_in_p2(t out nocopy inv_lot_api_pub.date_tbl, a0 JTF_DATE_TABLE);
38   procedure rosetta_table_copy_out_p2(t inv_lot_api_pub.date_tbl, a0 out nocopy JTF_DATE_TABLE);
39 
40 
41   procedure insert_serial(p_api_version  NUMBER
42     , p_init_msg_list  VARCHAR2
43     , p_commit  VARCHAR2
44     , p_validation_level  NUMBER
45     , p_inventory_item_id  NUMBER
46     , p_organization_id  NUMBER
47     , p_serial_number  VARCHAR2
48     , p_initialization_date  DATE
49     , p_completion_date  DATE
50     , p_ship_date  DATE
51     , p_revision  VARCHAR2
52     , p_lot_number  VARCHAR2
53     , p_current_locator_id  NUMBER
54     , p_subinventory_code  VARCHAR2
55     , p_trx_src_id  NUMBER
56     , p_unit_vendor_id  NUMBER
57     , p_vendor_lot_number  VARCHAR2
58     , p_vendor_serial_number  VARCHAR2
59     , p_receipt_issue_type  NUMBER
60     , p_txn_src_id  NUMBER
61     , p_txn_src_name  VARCHAR2
62     , p_txn_src_type_id  NUMBER
63     , p_transaction_id  NUMBER
64     , p_current_status  NUMBER
65     , p_parent_item_id  NUMBER
66     , p_parent_serial_number  VARCHAR2
67     , p_cost_group_id  NUMBER
68     , p_transaction_action_id  NUMBER
69     , p_transaction_temp_id  NUMBER
70     , p_status_id  NUMBER
71     , x_object_id out nocopy  NUMBER
72     , x_return_status out nocopy  VARCHAR2
73     , x_msg_count out nocopy  NUMBER
74     , x_msg_data out nocopy  VARCHAR2
75     , p_organization_type  NUMBER
76     , p_owning_org_id  NUMBER
77     , p_owning_tp_type  NUMBER
78     , p_planning_org_id  NUMBER
79     , p_planning_tp_type  NUMBER
80     , p_wip_entity_id  NUMBER
81     , p_operation_seq_num  NUMBER
82     , p_intraoperation_step_type  NUMBER
83     , p_attribute_category  VARCHAR2
84     , p_attributes_tbl JTF_VARCHAR2_TABLE_1000
85     , p_serial_attribute_category VARCHAR2
86     , p_c_attributes_tbl JTF_VARCHAR2_TABLE_1000
87     , p_n_attributes_tbl JTF_NUMBER_TABLE
88     , p_d_attributes_tbl JTF_DATE_TABLE
89     , p_origination_date  DATE
90     , p_territory_code  VARCHAR2
91   );
92   procedure update_serial(p_api_version  NUMBER
93     , p_init_msg_list  VARCHAR2
94     , p_commit  VARCHAR2
95     , p_validation_level  NUMBER
96     , p_inventory_item_id  NUMBER
97     , p_organization_id  NUMBER
98     , p_serial_number  VARCHAR2
99     , p_initialization_date  DATE
100     , p_completion_date  DATE
101     , p_ship_date  DATE
102     , p_revision  VARCHAR2
103     , p_lot_number  VARCHAR2
104     , p_current_locator_id  NUMBER
105     , p_subinventory_code  VARCHAR2
106     , p_trx_src_id  NUMBER
107     , p_unit_vendor_id  NUMBER
108     , p_vendor_lot_number  VARCHAR2
109     , p_vendor_serial_number  VARCHAR2
110     , p_receipt_issue_type  NUMBER
111     , p_txn_src_id  NUMBER
112     , p_txn_src_name  VARCHAR2
113     , p_txn_src_type_id  NUMBER
114     , p_current_status  NUMBER
115     , p_parent_item_id  NUMBER
116     , p_parent_serial_number  VARCHAR2
117     , p_serial_temp_id  NUMBER
118     , p_last_status  NUMBER
119     , p_status_id  NUMBER
120     , x_object_id out nocopy  NUMBER
121     , x_return_status out nocopy  VARCHAR2
122     , x_msg_count out nocopy  NUMBER
123     , x_msg_data out nocopy  VARCHAR2
124     , p_organization_type  NUMBER
125     , p_owning_org_id  NUMBER
126     , p_owning_tp_type  NUMBER
127     , p_planning_org_id  NUMBER
128     , p_planning_tp_type  NUMBER
129     , p_transaction_action_id  NUMBER
130     , p_wip_entity_id  NUMBER
131     , p_operation_seq_num  NUMBER
132     , p_intraoperation_step_type  NUMBER
133     , p_line_mark_id  NUMBER
134     , p_attribute_category  VARCHAR2
135     , p_attributes_tbl JTF_VARCHAR2_TABLE_1000
136     , p_serial_attribute_category VARCHAR2
137     , p_c_attributes_tbl JTF_VARCHAR2_TABLE_1000
138     , p_n_attributes_tbl JTF_NUMBER_TABLE
139     , p_d_attributes_tbl JTF_DATE_TABLE
140     , p_origination_date  DATE
141     , p_territory_code  VARCHAR2
142   );
143 end INV_SERIAL_EO_PVT;