1 PACKAGE INV_COST_GROUP_PVT AUTHID CURRENT_USER AS
2 /* $Header: INVVDCGS.pls 120.0.12020000.1 2012/06/26 14:10:16 appldev ship $ */
3
4 -- Glbal constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_COST_GROUP_PVT';
7 G_INPUT_MMTT CONSTANT VARCHAR2(6) := 'MMTT';
8 G_INPUT_MOLINE CONSTANT VARCHAR2(6) := 'MTRL';
9 G_MTL_SUPPLY_COST_GROUP_ID cst_cost_groups.cost_group_id%TYPE := NULL;
10 G_COMINGLE_ERROR CONSTANT VARCHAR2(6) := 'C';
11
12 --Bug 3031884 Global constant identifying the transaction that has caused the
13 --failure. This value has significance only when a failure is returned from
14 --cost group api.
15 g_failure_txn_temp_id NUMBER := NULL;
16
17 PROCEDURE Assign_Cost_Group
18 (
19 p_api_version_number IN NUMBER
20 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
21 , p_commit IN VARCHAR2 := FND_API.G_FALSE
22 , x_return_status OUT NOCOPY VARCHAR2
23 , x_msg_count OUT NOCOPY NUMBER
24 , x_msg_data OUT NOCOPY VARCHAR2
25 , p_transaction_header_id IN NUMBER
26 );
27
28 PROCEDURE Assign_Cost_Group
29 (
30 x_return_status OUT NOCOPY VARCHAR2
31 , x_msg_count OUT NOCOPY NUMBER
32 , x_msg_data OUT NOCOPY VARCHAR2
33 , p_organization_id IN NUMBER
34 , p_mmtt_rec IN mtl_material_transactions_temp%ROWTYPE DEFAULT NULL
35 , p_fob_point IN mtl_interorg_parameters.fob_point%TYPE DEFAULT NULL
36 , p_line_id IN NUMBER
37 , p_input_type IN VARCHAR2
38 , x_cost_group_id OUT NOCOPY NUMBER
39 , x_transfer_cost_group_id OUT NOCOPY NUMBER
40 );
41
42 -- added the average_cost_var_account as a parameter
43 PROCEDURE get_default_cost_group
44 (x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 x_cost_group_id OUT NOCOPY NUMBER,
48 p_material_account IN NUMBER,
49 p_material_overhead_account IN NUMBER,
50 p_resource_account IN NUMBER,
51 p_overhead_account IN NUMBER,
52 p_outside_processing_account IN NUMBER,
53 p_expense_account IN NUMBER,
54 p_encumbrance_account IN NUMBER,
55 p_average_cost_var_account IN NUMBER DEFAULT NULL,
56 p_organization_id IN NUMBER,
57 p_cost_group IN VARCHAR2 DEFAULT NULL
58 );
59
60 PROCEDURE get_cost_group(x_cost_group_id OUT NOCOPY NUMBER,
61 x_cost_group OUT NOCOPY VARCHAR2,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_organization_id IN NUMBER,
66 p_lpn_id IN NUMBER,
67 p_inventory_item_id IN NUMBER,
68 p_revision IN VARCHAR2,
69 p_subinventory_code IN VARCHAR2,
70 p_locator_id IN NUMBER,
71 p_lot_number IN VARCHAR2,
72 p_serial_number IN VARCHAR2);
73
74
75 END INV_COST_GROUP_PVT;