DBA Data[Home] [Help]

PACKAGE: APPS.GME_CREATE_BATCH_PVT

Source


1 PACKAGE gme_create_batch_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVCRBS.pls 120.4.12010000.4 2009/04/27 09:46:35 apmishra ship $ */
3 
4    /***********************************************************/
5 /* Oracle Process Manufacturing Process Execution APIs     */
6 /*                                                         */
7 /* File Name: GMEVCRBS.pls                                 */
8 /* Contents:  Private layer for batch creation API         */
9 /* History                                                 */
10 /* =======                                                 */
11 /* 10-JAN-2008 Rajesh Patangya Bug # 6752637               */
12 /* MTQ Quantity should be calculated based on product in   */
13 /* place of just copy from the routing, This is required   */
14 /* by PS engine, New Function UPDATE_STEP_MTQ added        */
15 
16 /* 18-NOV-2008 G. Muratore     Bug 7565054                                */
17 /*     Added parameter p_sum_all_prod_lines to the procedure create_batch */
18 /**************************************************************************/
19    /* Bug 5512352 Added new global */
20    g_no_phant_short_check   NUMBER := 0;
21    FUNCTION construct_batch_header (
22       p_batch_header_rec   IN              gme_batch_header%ROWTYPE
23      ,x_batch_header_rec   OUT NOCOPY      gme_batch_header%ROWTYPE)
24       RETURN BOOLEAN;
25 
26    PROCEDURE validate_wip_entity (p_organization_id  IN   NUMBER,
27                                   p_batch_no         IN   VARCHAR2,
28                                   x_return_status    OUT NOCOPY VARCHAR2);
29 
30    PROCEDURE create_batch (
31       p_validation_level         IN              NUMBER
32             := gme_common_pvt.g_max_errors
33      ,p_batch_header_rec         IN              gme_batch_header%ROWTYPE
34      ,p_batch_size               IN              NUMBER
35      ,p_batch_size_uom           IN              VARCHAR2
36      ,p_creation_mode            IN              VARCHAR2
37      ,p_ignore_qty_below_cap     IN              VARCHAR2
38             DEFAULT fnd_api.g_true
39      ,p_use_workday_cal          IN              VARCHAR2
40      ,p_contiguity_override      IN              VARCHAR2
41      ,p_is_phantom               IN              VARCHAR2 DEFAULT 'N'
42      ,p_sum_all_prod_lines       IN              VARCHAR2 DEFAULT 'A'
43      ,p_use_least_cost_validity_rule     IN      VARCHAR2 := fnd_api.g_false
44      ,x_batch_header_rec         OUT NOCOPY      gme_batch_header%ROWTYPE
45      ,x_exception_material_tbl   OUT NOCOPY      gme_common_pvt.exceptions_tab
46      ,x_return_status            OUT NOCOPY      VARCHAR2);
47 
48 /* 10-JAN-2008 Rajesh Patangya Bug # 6752637               */
49    FUNCTION update_step_mtq (p_batch_id IN NUMBER)
50                    RETURN BOOLEAN ;
51 
52 END gme_create_batch_pvt;