DBA Data[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;