[Home] [Help]
PACKAGE: APPS.INVTVTUS
Source
1 PACKAGE INVTVTUS AUTHID CURRENT_USER as
2 /* $Header: INVTVTUS.pls 115.6 2002/07/12 19:01:25 ssia ship $ */
3
4 procedure item_only_summaries (
5 sessionid number,
6 orgid mtl_parameters.organization_id%TYPE,
7 orgloctype number,
8 invid mtl_system_items.inventory_item_id%TYPE,
9 rev mtl_item_revisions.revision%TYPE,
10 uom mtl_system_items.primary_uom_code%TYPE,
11 puom mtl_system_items.primary_uom_code%TYPE,
12 sdate mtl_material_transactions.transaction_date%TYPE,
13 edate mtl_material_transactions.transaction_date%TYPE,
14 cg_id mtl_secondary_inventories.default_cost_group_id%TYPE);
15
16 procedure sub_only_summaries (
17 sessionid number,
18 orgid mtl_parameters.organization_id%TYPE,
19 sub mtl_secondary_inventories.secondary_inventory_name%TYPE,
20 locid mtl_item_locations.inventory_location_id%TYPE,
21 catsetid mtl_category_sets.category_set_id%TYPE,
22 catid mtl_categories.category_id%TYPE,
23 sdate mtl_material_transactions.transaction_date%TYPE,
24 edate mtl_material_transactions.transaction_date%TYPE,
25 cg_id mtl_secondary_inventories.default_cost_group_id%TYPE);
26
27 procedure both_summaries (
28 sessionid number,
29 orgid mtl_parameters.organization_id%TYPE,
30 invid mtl_system_items.inventory_item_id%TYPE,
31 rev mtl_item_revisions.revision%TYPE,
32 uom mtl_system_items.primary_uom_code%TYPE,
33 puom mtl_system_items.primary_uom_code%TYPE,
34 sub mtl_secondary_inventories.secondary_inventory_name%TYPE,
35 locid mtl_item_locations.inventory_location_id%TYPE,
36 sdate mtl_material_transactions.transaction_date%TYPE,
37 edate mtl_material_transactions.transaction_date%TYPE,
38 cg_id mtl_secondary_inventories.default_cost_group_id%TYPE);
39
40 /* procedure cost_group_summaries (
41 sessionid number,
42 orgid mtl_parameters.organization_id%TYPE,
43 orgloctype NUMBER,
44 cost_group_id mtl_secondary_inventories.default_cost_group_id%TYPE,
45 sdate mtl_material_transactions.transaction_date%TYPE,
46 edate mtl_material_transactions.transaction_date%TYPE);
47
48 procedure sub_cost_group_summaries(
49 sessionid NUMBER,
50 orgid mtl_parameters.organization_id%TYPE,
51 sub mtl_secondary_inventories.secondary_inventory_name%TYPE,
52 cost_group_id mtl_secondary_inventories.default_cost_group_id%TYPE,
53 sdate mtl_material_transactions.transaction_date%TYPE,
54 edate mtl_material_transactions.transaction_date%TYPE);*/
55 end INVTVTUS;