[Home] [Help]
PACKAGE: APPS.GMIVDBX
Source
1 PACKAGE GMIVDBX AS
2 /* $Header: GMIVDBXS.pls 120.0 2005/05/25 16:02:42 appldev noship $
3 +==========================================================================+
4 | Copyright (c) 1998 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +==========================================================================+
8 | FILE NAME |
9 | GMIVDBXS.pls |
10 | |
11 | PACKAGE NAME |
12 | GMIVDBX |
13 | |
14 | TYPE |
15 | Private |
16 | |
17 | DESCRIPTION |
18 | This package contains the private database insert routines |
19 | for Process / Discrete Transfer only. |
20 | |
21 | CONTENTS |
22 | header_insert |
23 | line_insert |
24 | lot_insert |
25 | get_doc_no |
26 | This will get the doc no from sy_docs_mst and commit the no so that |
27 | there is no lock on the table. |
28 | It is a AUTONOMOUS_TRANSACTION. which will commit before the main |
29 | transaction completes. |
30 | |
31 | |
32 | |
33 | HISTORY |
34 | Created - Jalaj Srivastava |
35 | |
36 | |
37 +==========================================================================+
38 */
39
40
41 /* Procedure Declaration */
42 PROCEDURE header_insert
43 ( p_api_version IN NUMBER
44 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
45 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
46 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
47 , x_return_status OUT NOCOPY VARCHAR2
48 , x_msg_count OUT NOCOPY NUMBER
49 , x_msg_data OUT NOCOPY VARCHAR2
50 , p_hdr_rec IN GMIVDX.hdr_type
51 , x_hdr_row OUT NOCOPY gmi_discrete_transfers%ROWTYPE
52 );
53
54 PROCEDURE line_insert
55 ( p_api_version IN NUMBER
56 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
57 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
58 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
59 , x_return_status OUT NOCOPY VARCHAR2
60 , x_msg_count OUT NOCOPY NUMBER
61 , x_msg_data OUT NOCOPY VARCHAR2
62 , p_hdr_row IN gmi_discrete_transfers%ROWTYPE
63 , p_line_rec IN GMIVDX.line_type
64 , x_line_row OUT NOCOPY gmi_discrete_transfer_lines%ROWTYPE
65 );
66
67
68 PROCEDURE lot_insert
69 ( p_api_version IN NUMBER
70 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
71 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
72 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
73 , x_return_status OUT NOCOPY VARCHAR2
74 , x_msg_count OUT NOCOPY NUMBER
75 , x_msg_data OUT NOCOPY VARCHAR2
76 , p_line_row IN gmi_discrete_transfer_lines%ROWTYPE
77 , p_lot_rec IN GMIVDX.lot_type
78 , x_lot_row OUT NOCOPY gmi_discrete_transfer_lots%ROWTYPE
79 );
80
81 FUNCTION get_doc_no
82 ( x_return_status OUT NOCOPY VARCHAR2
83 , x_msg_count OUT NOCOPY NUMBER
84 , x_msg_data OUT NOCOPY VARCHAR2
85 , p_doc_type IN sy_docs_seq.doc_type%TYPE
86 , p_orgn_code IN sy_docs_seq.orgn_code%TYPE
87 ) RETURN VARCHAR2;
88
89 END GMIVDBX;