DBA Data[Home] [Help]

PACKAGE: APPS.GME_MAKE_TO_ORDER_PVT

Source


1 PACKAGE      GME_MAKE_TO_ORDER_PVT AUTHID CURRENT_USER AS
2 /*  $Header: GMECRBTS.pls 120.0 2007/12/24 19:45:25 srpuri noship $
3  +=========================================================================+
4  |                Copyright (c) 2000 Oracle Corporation                    |
5  |                        TVP, Reading, England                            |
6  |                         All rights reserved                             |
7  +=========================================================================+
8  | FILENAME                                                                |
9  |    GMECRBTS.pls                                                         |
10  |                                                                         |
11  | DESCRIPTION                                                             |
12  |     This package contains private utilities  relating to OPM            |
13  |     reservation.                                                        |
14  |                                                                         |
15  |                                                                         |
16  | HISTORY                                                                 |
17  |     Dec,2007  Srinivasulu Created                                   |
18  +=========================================================================+
19   API Name  : GME_MAKE_TO_ORDER_PVT
20   Type      : Private
21   Function  : This package contains Private Utilities procedures used to
22               Create OPM batches and reservations for Sales Orders
23   Pre-reqs  : N/A
24   Parameters: Per function
25 
26   Current Vers  : 1.0
27 
28 */
29 
30 G_PKG_NAME  CONSTANT  VARCHAR2(30):='GME_MAKE_TO_ORDER_PVT';
31 
32 PROCEDURE Create_batch_for_order_line(
33 --                        errbuf          OUT NOCOPY VARCHAR2
34 --			  retcode         OUT NOCOPY VARCHAR2
35 			  p_api_version   IN  NUMBER   := 1.0
36 			 ,p_init_msg_list IN  VARCHAR2 := fnd_api.g_false
37 			 ,p_commit        IN  VARCHAR2 := fnd_api.g_false
38 			 ,p_so_line_id    IN  NUMBER);
39 
40 
41 PROCEDURE Copy_attachments ( p_so_category_id IN NUMBER
42                            , p_so_line_id     IN NUMBER
43                            , p_batch_category_id IN NUMBER
44                            , p_batch_id       IN NUMBER
45                            , x_return_status OUT NOCOPY VARCHAR2);
46 
47 
48 FUNCTION line_qualifies_for_MTO (
49    p_line_id IN NUMBER
50 )
51    RETURN BOOLEAN;
52 
53 PROCEDURE retrieve_rule
54  (
55     p_mto_assignments_rec    IN    GME_MTO_RULE_ASSIGNMENTS%ROWTYPE
56   , x_mto_rules_rec          OUT   NOCOPY GME_MTO_RULES%ROWTYPE
57   , x_mto_assignments_rec    OUT   NOCOPY GME_MTO_RULE_ASSIGNMENTS%ROWTYPE
58   , x_return_status          OUT   NOCOPY VARCHAR2
59   , x_msg_count              OUT   NOCOPY NUMBER
60   , x_msg_data               OUT   NOCOPY VARCHAR2);
61 END GME_MAKE_TO_ORDER_PVT;