PACKAGE BODY: APPS.GMP_BATCH_WRAPPER_PKG

Source

1 PACKAGE BODY GMP_BATCH_WRAPPER_PKG AS
2 /* $Header: GMPBTWRB.pls 120.5 2011/05/06 12:56:31 vkinduri ship $ */
3 
4    PROCEDURE create_batch(
5       p_api_version              IN              NUMBER := 2.0
6      ,p_validation_level         IN              NUMBER := gme_common_pvt.g_max_errors
7      ,p_init_msg_list            IN              VARCHAR2 := fnd_api.g_false
8      ,p_commit                   IN              VARCHAR2 := fnd_api.g_false
9      ,x_message_count            OUT NOCOPY      NUMBER
10      ,x_message_list             OUT NOCOPY      VARCHAR2
11      ,x_return_status            OUT NOCOPY      VARCHAR2
12      ,p_org_code                 IN              VARCHAR2 := NULL
13      ,p_batch_header_rec         IN              gme_batch_header%ROWTYPE
14      ,x_batch_header_rec         OUT NOCOPY      gme_batch_header%ROWTYPE
15      ,p_batch_size               IN              NUMBER := NULL
16      ,p_batch_size_uom           IN              VARCHAR2 := NULL
17      ,p_creation_mode            IN              VARCHAR2
18      ,p_recipe_id                IN              NUMBER := NULL
19      ,p_recipe_no                IN              VARCHAR2 := NULL
20      ,p_recipe_version           IN              NUMBER := NULL
21      ,p_product_no               IN              VARCHAR2 := NULL
22      ,p_item_revision            IN              VARCHAR2 := NULL
23      ,p_product_id               IN              NUMBER := NULL
24      ,p_ignore_qty_below_cap     IN              VARCHAR2 := fnd_api.g_true
25      ,p_use_workday_cal          IN              VARCHAR2 := fnd_api.g_true
26      ,p_contiguity_override      IN              VARCHAR2 := fnd_api.g_true
27      ,p_use_least_cost_validity_rule     IN              VARCHAR2 := fnd_api.g_false
28 --     ,x_exception_material_tbl   OUT NOCOPY      gme_common_pvt.exceptions_tab
29      ,x_exception_material_tbl   OUT NOCOPY      exceptions_tab
30    ) IS
31 
32    retrieval_cursor VARCHAR2(32700) ;
33 
34    BEGIN
35 
36    retrieval_cursor := NULL ;
37 
38   /* Bug: 9710977 Vpedarla - Disable the formula security  */
39     retrieval_cursor := ' begin gmd_p_fs_context.set_additional_attr; end;' ;
40     EXECUTE IMMEDIATE retrieval_cursor ;
41 
42               gme_api_pub.create_batch(
43                   p_api_version           =>  p_api_version
44                   ,p_validation_level      =>  p_validation_level
45                   ,p_init_msg_list         => p_init_msg_list
46                   ,p_commit                => p_commit
47                   ,x_message_count         => x_message_count
48                   ,x_message_list          => x_message_list
49                   ,x_return_status         => x_return_status
50                   ,p_org_code              => p_org_code
51                   ,p_batch_header_rec      => p_batch_header_rec
52                   ,x_batch_header_rec      => x_batch_header_rec
53                   ,p_batch_size            => p_batch_size
54                   ,p_batch_size_uom        => p_batch_size_uom
55                   ,p_creation_mode         => p_creation_mode
56                   ,p_recipe_id             => p_recipe_id
57                   ,p_recipe_no             => p_recipe_no
58                   ,p_recipe_version        => p_recipe_version
59                   ,p_product_no            => p_product_no
60                   ,p_item_revision         => p_item_revision
61                   ,p_product_id            => p_product_id
62                   ,p_ignore_qty_below_cap  => p_ignore_qty_below_cap
63                   ,p_use_workday_cal       => p_use_workday_cal
64                   ,p_contiguity_override   => p_contiguity_override
65                   ,p_use_least_cost_validity_rule => p_use_least_cost_validity_rule
66                   ,x_exception_material_tbl => x_exception_material_tbl
67                   );
68 
69    END create_batch;
70 END GMP_BATCH_WRAPPER_PKG;