PACKAGE: APPS.INVIDSCS

Source

1 PACKAGE INVIDSCS AUTHID CURRENT_USER as
2 /* $Header: INVIDSCS.pls 120.2.12010000.1 2008/07/24 01:35:19 appldev ship $ */
3 
4 PROCEDURE  CHECK_CAT_SET_MANDATORY(
5 current_cat_set_id          IN     NUMBER,
6 func_area_flag1             OUT  NOCOPY    VARCHAR2,
7 func_area_flag2             OUT  NOCOPY    VARCHAR2,
8 func_area_flag3             OUT  NOCOPY    VARCHAR2,
9 func_area_flag4             OUT  NOCOPY    VARCHAR2,
10 func_area_flag5             OUT  NOCOPY    VARCHAR2,
11 func_area_flag6             OUT  NOCOPY    VARCHAR2,
12 func_area_flag7             OUT  NOCOPY    VARCHAR2,
13 func_area_flag8             OUT  NOCOPY    VARCHAR2,--Bug : 2527058
14 func_area_flag9             OUT  NOCOPY    VARCHAR2,
15 func_area_flag10            OUT  NOCOPY    VARCHAR2,
16 func_area_flag11            OUT  NOCOPY    VARCHAR2
17 );
18 
19 PROCEDURE GET_ITEM_DEFINING_FLAGS(
20 current_item_id            IN   NUMBER,
21 current_org_id             IN   NUMBER,
22 inv_item_flag              OUT  NOCOPY  VARCHAR2,
23 purch_item_flag            OUT  NOCOPY  VARCHAR2,
24 int_order_flag             OUT  NOCOPY  VARCHAR2,
25 serv_item_flag             OUT  NOCOPY  VARCHAR2,
26 cost_enab_flag             OUT  NOCOPY  VARCHAR2,
27 engg_item_flag             OUT  NOCOPY  VARCHAR2,
28 cust_order_flag            OUT  NOCOPY  VARCHAR2,
29 mrp_plan_code              OUT  NOCOPY  NUMBER,
30 eam_item_type              OUT  NOCOPY  NUMBER, --Bug : 2527058
31 contract_item_type         OUT  NOCOPY  VARCHAR2
32 );
33 
34 PROCEDURE INSERT_CATSET_CHILD_ORGS(
35 current_inv_item_id      IN    NUMBER,
36 current_org_id           IN    NUMBER,
37 current_master_org_id    IN    NUMBER,
38 current_cat_set_id       IN    NUMBER,
39 current_cat_id           IN    NUMBER,
40 cat_set_control_level    IN    NUMBER,
41 current_created_by       IN    NUMBER := NULL -- Bug: 6045866
42 );
43 
44 PROCEDURE UPDATE_CATSET_CHILD_ORGS(
45 current_inv_item_id      IN    NUMBER,
46 current_org_id           IN    NUMBER,
47 current_master_org_id    IN    NUMBER,
48 current_cat_set_id       IN    NUMBER,
49 current_cat_id           IN    NUMBER,
50 cat_set_control_level    IN    NUMBER,
51 old_cat_id		 IN    NUMBER,
52 current_last_updated_by  IN    NUMBER := NULL -- Bug : 4949084
53 );
54 
55 PROCEDURE redefault_material_overheads (
56 current_inv_item_id      IN    NUMBER,
57 current_org_id           IN    NUMBER,
58 current_master_org_id    IN    NUMBER,
59 current_cat_set_id       IN    NUMBER,
60 current_cat_id           IN    NUMBER,
61 cat_set_control_level    IN    NUMBER,
62 current_cst_item_type    IN    NUMBER,
63 current_last_updated_by  IN    NUMBER
64 );
65 
66 PROCEDURE get_costing_values (
67 tmp_inv_item_id          IN    NUMBER,
68 tmp_organization_id      IN    NUMBER,
69 tmp_cost_method         OUT  NOCOPY    NUMBER,
70 tmp_cst_lot_size        OUT  NOCOPY    NUMBER,
71 tmp_cst_shrink_rate     OUT  NOCOPY    NUMBER
72 );
73 
74   /* Prasad Peddamatham - 12/8/2000
75   Added current_cat_id parameter to allow the deletion of a Item Category
76   Assignment based upon Multiple Item Category Assignment flag
77   */
78 PROCEDURE DELETE_CATSET_CHILD_ORGS(
79 current_inv_item_id      IN    NUMBER,
80 current_master_org_id    IN    NUMBER,
81 current_cat_set_id       IN    NUMBER,
82 current_cat_id       IN    NUMBER
83 );
84 
85 
86 END INVIDSCS;