[Home] [Help]
PACKAGE: APPS.GMI_CMP_TRAN_PVT
Source
1 PACKAGE GMI_CMP_TRAN_PVT AUTHID CURRENT_USER AS
2 -- $Header: GMIVCMPS.pls 115.2 99/07/16 04:49:38 porting ship $
3 --+=========================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| TVP, Reading, England |
6 --| All rights reserved |
7 --+=========================================================================+
8 --| FILENAME |
9 --| GMIVCMPS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package contains private procedures to post completed |
13 --| inventory transactions. |
14 --| |
15 --| HISTORY |
16 --| 01-OCT-1998 M.Godfrey Created |
17 --+=========================================================================+
18 -- API Name : GMI_CMP_TRAN_PVT
19 -- Type : Private
20 -- Function : This package contains private procedures used to post
21 -- completed inventory transactions.
22 -- Pre-reqs : N/A
23 -- Parameters: Per function
24 --
25 -- Current Vers : 1.0
26 --
27 -- Previous Vers : N/A
28 --
29 -- Initial Vers : 1.0
30 -- Notes
31 --
32 -- API specific parameters to be presented in SQL RECORD format
33 TYPE cmp_tran_typ IS RECORD
34 ( item_id IC_TRAN_CMP.item_id%TYPE
35 , line_id IC_TRAN_CMP.line_id%TYPE
36 , trans_id IC_TRAN_CMP.trans_id%TYPE
37 , co_code IC_TRAN_CMP.co_code%TYPE
38 , orgn_code IC_TRAN_CMP.orgn_code%TYPE
39 , whse_code IC_TRAN_CMP.whse_code%TYPE
40 , lot_id IC_TRAN_CMP.lot_id%TYPE
41 , location IC_TRAN_CMP.location%TYPE
42 , doc_id IC_TRAN_CMP.doc_id%TYPE
43 , doc_type IC_TRAN_CMP.doc_type%TYPE
44 , doc_line IC_TRAN_CMP.doc_line%TYPE
45 , line_type IC_TRAN_CMP.line_type%TYPE
46 , reason_code IC_TRAN_CMP.reason_code%TYPE
47 , creation_date IC_TRAN_CMP.creation_date%TYPE
48 , trans_date IC_TRAN_CMP.trans_date%TYPE
49 , trans_qty IC_TRAN_CMP.trans_qty%TYPE
50 , trans_qty2 IC_TRAN_CMP.trans_qty2%TYPE
51 , qc_grade IC_TRAN_CMP.qc_grade%TYPE
52 , lot_status IC_TRAN_CMP.lot_status%TYPE
53 , trans_stat IC_TRAN_CMP.trans_stat%TYPE
54 , trans_um IC_TRAN_CMP.trans_um%TYPE
55 , trans_um2 IC_TRAN_CMP.trans_um2%TYPE
56 , user_id FND_USER.user_id%TYPE
57 , gl_posted_ind IC_TRAN_CMP.gl_posted_ind%TYPE
58 , event_id IC_TRAN_CMP.event_id%TYPE
59 , text_code IC_TRAN_CMP.text_code%TYPE
60 );
61 --
62 FUNCTION Update_Quantity_Transaction
63 ( p_cmp_tran_rec IN cmp_tran_typ
64 )
65 RETURN BOOLEAN;
66 --
67 FUNCTION Update_Movement
68 ( p_cmp_tran_rec IN cmp_tran_typ
69 )
70 RETURN BOOLEAN;
71 --
72 FUNCTION Update_Lot_Status
73 ( p_cmp_tran_rec IN cmp_tran_typ
74 )
75 RETURN BOOLEAN;
76 --
77 FUNCTION Update_Qc_Grade
78 ( p_cmp_tran_rec IN cmp_tran_typ
79 )
80 RETURN BOOLEAN;
81 --
82 FUNCTION Insert_ic_tran_cmp
83 ( p_cmp_tran_rec IN cmp_tran_typ
84 )
85 RETURN BOOLEAN;
86 --
87 FUNCTION Update_ic_loct_inv
88 ( p_cmp_tran_rec IN cmp_tran_typ
89 )
90 RETURN BOOLEAN;
91 --
92 FUNCTION Insert_ic_loct_inv
93 ( p_cmp_tran_rec IN cmp_tran_typ
94 )
95 RETURN BOOLEAN;
96 --
97 FUNCTION Update_ic_summ_inv
98 ( p_cmp_tran_rec IN cmp_tran_typ
99 )
100 RETURN BOOLEAN;
101 --
102 FUNCTION Update_ic_loct_inv_Lot_Status
103 ( p_cmp_tran_rec IN cmp_tran_typ
104 )
105 RETURN BOOLEAN;
106 FUNCTION Update_ic_summ_inv_Qc_Grade
107 ( p_cmp_tran_rec IN cmp_tran_typ
108 )
109 RETURN BOOLEAN;
110 --
111
112 END GMI_CMP_TRAN_PVT;