[Home] [Help]
PACKAGE: APPS.INV_REPLENISH_COUNT_LOVS
Source
1 PACKAGE inv_replenish_count_lovs AS
2 /* $Header: INVRPCLS.pls 120.1 2006/04/13 06:26:37 aalex noship $ */
3
4 /** Package : INV_REPLENISH_COUNT_LOVS<br>
5 * File : INVRPCLS.pls<br>
6 * Content :<br>
7 * Description :<br>
8 * Notes :<br>
9 * Modified : Mon Aug 25 12:17:54 GMT+05:30 2003<br>
10 *
11 * Package Specification inv_replenish_count_lovs<p>
12 * This file contains Replenishment Count LOVS being used by the
13 * mobile WMS/INV applications. <br>It is being called from java
14 * LOV beans to populate the LOV. <br>
15 *
16 **/
17 TYPE t_genref IS REF CURSOR;
18
19 /**
20 * This procedure returns valid Replenishment Count Names for counting in mobile.<p>
21 * @param x_replenish_count_lov Returns LOV rows as a reference cursor<br>
22 * @param p_replenish_count Restricts LOV SQL to the user input Count Name<br>
23 * @param p_organization_id Organization ID<br>
24 * @param p_subinventory Subinventory Code<br>
25 **/
26 PROCEDURE get_replenish_count_lov(
27 x_replenish_count_lov OUT NOCOPY t_genref
28 , p_replenish_count IN VARCHAR2
29 , p_organization_id IN NUMBER
30 , p_subinventory IN VARCHAR2
31 );
32
33 /**
34 * This procedure returns valid Subinventories which have atleast one Min Max planned or
35 * PAR level planned item defined in the Item subinventories form.<p>
36 * @param x_replenish_count_subs_lov Returns LOV rows as a reference cursor<br>
37 * @param p_subinventory Subinventory Code<br>
38 * @param p_organization_id Organization ID<br>
39 **/
40 PROCEDURE get_replenish_count_subs_lov(
41 x_replenish_count_subs_lov OUT NOCOPY t_genref
42 , p_subinventory IN VARCHAR2
43 , p_organization_id IN NUMBER
44 );
45
46 /**
47 * This procedure returns all the locators which have
48 * Item-Locator relationship defined in the Item subinventories form.<p>
49 * @param x_replenish_count_locator_kff Returns LOV rows as a reference cursor<br>
50 * @param p_locator Restricts LOV SQL to this user input Locator<br>
51 * @param p_replenish_header_id Replenishment Count Header ID<br>
52 * @param p_organization_id Organization ID<br>
53 * @param p_subinventory Subinventory Code<br>
54 * @param p_qty_tracked Quantity Tracked Subinventory<br>
55 **/
56 PROCEDURE get_replenish_count_locs_kff(
57 x_replenish_count_locator_kff OUT NOCOPY t_genref
58 , p_locator IN VARCHAR2
59 , p_replenish_header_id IN NUMBER
60 , p_organization_id IN NUMBER
61 , p_subinventory IN VARCHAR2
62 , p_qty_tracked IN NUMBER
63 );
64
65 PROCEDURE get_replenish_count_locs_kff(
66 x_replenish_count_locator_kff OUT NOCOPY t_genref
67 , p_locator IN VARCHAR2
68 , p_replenish_header_id IN NUMBER
69 , p_organization_id IN NUMBER
70 , p_subinventory IN VARCHAR2
71 , p_qty_tracked IN NUMBER
72 , p_alias IN VARCHAR2
73 );
74
75 /**
76 * This procedure returns all the items which have Item-Subinventory or
77 * Item-Locator relationship defined in the Item subinventories form.<p>
78 * @param x_replenish_count_items_lov Returns LOV rows as a reference cursor<br>
79 * @param p_item Restricts LOV SQL to this user input Item<br>
80 * @param p_replenish_header_id Replenishment Count Header ID<br>
81 * @param p_organization_id Organization ID<br>
82 * @param p_subinventory Subinventory Code<br>
83 * @param p_locator_id Locator Id<br>
84 * @param p_qty_tracked Quantity Tracked Subinventory<br>
85 **/
86 PROCEDURE get_replenish_count_items_lov(
87 x_replenish_count_items_lov OUT NOCOPY t_genref
88 , p_item IN VARCHAR2
89 , p_replenish_header_id IN NUMBER
90 , p_organization_id IN NUMBER
91 , p_subinventory IN VARCHAR2
92 , p_locator_id IN NUMBER
93 , p_qty_tracked IN NUMBER
94 );
95
96 /**
97 * This procedure returns the Replenishment Count Types allowed for the passed in
98 * input combination of Item, Subinventory and Locator.<p>
99 * @param x_replenish_count_types_lov Returns LOV rows as a reference cursor<br>
100 * @param p_count_type Count Type<br>
101 * @param p_qty_tracked Quantity Tracked Subinventory<br>
102 * @param p_inventory_planning_level Planning Level of the Subinventory<br>
103 * @param p_par_level PAR level for the Locator Item.<p>
104 **/
105 /**---------------------------------------------------------------------<br>
106 * Parameters value passed<br>
107 * ---------------------------------------------------------------------<br>
108 * p_quantity_tracked 1(Check) 1 2 2 <br>
109 *<br>
110 * p_inventory_planning_level 1(PAR) 2(Sub) 1 2<br>
111 *<br>
112 * p_par_level - NULL - NOT NULL<br>
113 * ---------------------------------------------------------------------<br>
114 * Count Types Returned Order Qty Order Qty Onhand Qty Onhand Qty<br>
115 * Order Qty Order Qty<br>
116 *----------------------------------------------------------------------*/
117 PROCEDURE get_replenish_count_types_lov(
118 x_replenish_count_types_lov OUT NOCOPY t_genref
119 , p_count_type IN VARCHAR2
120 , p_qty_tracked IN NUMBER
121 , p_inventory_planning_level IN NUMBER
122 , p_par_level IN NUMBER
123 );
124 END inv_replenish_count_lovs;