[Home] [Help]
PACKAGE: APPS.GML_CREATE_BATCH_FOR_SO_PVT
Source
1 PACKAGE GML_CREATE_BATCH_FOR_SO_PVT AUTHID CURRENT_USER AS
2 /* $Header: GMLCRBTS.pls 120.0 2005/05/25 16:23:50 appldev noship $
3 +=========================================================================+
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
9 | GMLCRBTS.pls |
10 | |
11 | DESCRIPTION |
12 | This package contains private utilities relating to OPM |
13 | reservation. |
14 | |
15 | |
16 | HISTORY |
17 | Feb,2005 Neelima Chekuri Created |
18 +=========================================================================+
19 API Name : GML_CREATE_BATCH_FOR_SO_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):='GML_CREATE_BATCH_FOR_SO_PVT';
31
32 PROCEDURE Create_batch_for_so_line(
33 errbuf OUT NOCOPY VARCHAR2
34 ,retcode OUT NOCOPY VARCHAR2
35 ,p_api_version IN NUMBER
36 ,p_init_msg_list IN VARCHAR2
37 ,p_commit IN VARCHAR2
38 ,p_so_line_id IN NUMBER);
39
40 PROCEDURE Update_batch_pending_trans(
41 p_batch_id IN NUMBER,
42 p_whse_code IN VARCHAR2,
43 p_so_line_id IN NUMBER,
44 p_item_id IN NUMBER,
45 x_return_status OUT NOCOPY NUMBER,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2
48 );
49 PROCEDURE send_workflow_notification(
50 p_batch_id IN NUMBER,
51 p_batch_line_id IN NUMBER,
52 p_so_line_id IN NUMBER,
53 p_item_id IN NUMBER,
54 p_lot_no IN VARCHAR2 DEFAULT NULL,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2)
58 ;
59 PROCEDURE calculate_rsv_and_alloc_qty(
60 p_so_line_id IN NUMBER,
61 x_primary_qty OUT NOCOPY NUMBER,
62 x_secondary_qty OUT NOCOPY NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2)
64 ;
65
66 FUNCTION Submit_Create_batch_Request(p_so_line IN NUMBER) RETURN NUMBER;
67
68 PROCEDURE Copy_attachments ( p_so_category_id IN NUMBER
69 , p_so_line_id IN NUMBER
70 , p_batch_category_id IN NUMBER
71 , p_batch_id IN NUMBER
72 , x_return_status OUT NOCOPY VARCHAR2);
73
74 PROCEDURE ui_create_batch_for_so_line(
75 errbuf OUT NOCOPY VARCHAR2
76 ,retcode OUT NOCOPY VARCHAR2
77 ,p_order_type IN VARCHAR2
78 ,p_order_number_low IN NUMBER
79 ,p_order_number_high IN NUMBER
80 ,p_warehouse IN VARCHAR2
81 ,p_customer_id IN VARCHAR2
82 ,p_inventory_item_id IN VARCHAR2);
83
84 END GML_CREATE_BATCH_FOR_SO_PVT;