1 PACKAGE GMIVDBL AUTHID CURRENT_USER AS
2 /* $Header: GMIVDBLS.pls 115.11 2003/09/17 15:51:38 txyu ship $
3 +=========================================================================+
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
9 | GMIVDBLS.pls |
10 | |
11 | DESCRIPTION |
12 | |
13 | This package specification contains headers and data privately |
14 | accessible from the inventory API processing layers. No other use, |
15 | either public or private is supported. |
16 | |
17 | API NAME |
18 | GMIVDBL Inventory API Database Layer |
19 | |
20 | TYPE |
21 | Private |
22 | |
23 | HISTORY |
24 | 12-May-2000 P.J.Schofield, OPM Development, Oracle UK |
25 | Created for Inventory API Release 3.0 |
26 | 11-Nov-2002 Joe DiIorio Bug#2643440 - 11.5.1J - added nocopy |
27 | 11-Sep-2003 Teresa Wong B2378017 - Added the p_item_rec parameter |
28 | to procedure gmi_item_categories in order to insert |
29 | categories for both existing and new classes. |
30 +=========================================================================+
31 */
32 FUNCTION ic_item_mst_insert (p_ic_item_mst_row IN ic_item_mst%ROWTYPE,
33 x_ic_item_mst_row IN OUT NOCOPY ic_item_mst%ROWTYPE)
34 RETURN BOOLEAN;
35
36 FUNCTION ic_item_mst_select (p_ic_item_mst_row IN ic_item_mst%ROWTYPE,
37 x_ic_item_mst_row IN OUT NOCOPY ic_item_mst%ROWTYPE)
38 RETURN BOOLEAN;
39
40 FUNCTION ic_lots_mst_insert (p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE,
41 x_ic_lots_mst_row IN OUT NOCOPY ic_lots_mst%ROWTYPE)
42 RETURN BOOLEAN;
43
44 FUNCTION ic_lots_mst_select (p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE,
45 x_ic_lots_mst_row IN OUT NOCOPY ic_lots_mst%ROWTYPE)
46 RETURN BOOLEAN;
47
48 FUNCTION ic_item_cpg_insert (p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE,
49 x_ic_item_cpg_row IN OUT NOCOPY ic_item_cpg%ROWTYPE)
50 RETURN BOOLEAN;
51
52 FUNCTION ic_item_cpg_select (p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE,
53 x_ic_item_cpg_row IN OUT NOCOPY ic_item_cpg%ROWTYPE)
54 RETURN BOOLEAN;
55
56 FUNCTION ic_lots_cpg_insert (p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE,
57 x_ic_lots_cpg_row IN OUT NOCOPY ic_lots_cpg%ROWTYPE)
58 RETURN BOOLEAN;
59
60 FUNCTION ic_lots_cpg_select (p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE,
61 x_ic_lots_cpg_row IN OUT NOCOPY ic_lots_cpg%ROWTYPE)
62 RETURN BOOLEAN;
63
64 FUNCTION ic_lots_sts_select (p_ic_lots_sts_row IN ic_lots_sts%ROWTYPE,
65 x_ic_lots_sts_row IN OUT NOCOPY ic_lots_sts%ROWTYPE)
66 RETURN BOOLEAN;
67
68 FUNCTION ic_jrnl_mst_insert (p_ic_jrnl_mst_row IN ic_jrnl_mst%ROWTYPE,
69 x_ic_jrnl_mst_row IN OUT NOCOPY ic_jrnl_mst%ROWTYPE)
70 RETURN BOOLEAN;
71
72 FUNCTION ic_jrnl_mst_select (p_ic_jrnl_mst_row IN ic_jrnl_mst%ROWTYPE,
73 x_ic_jrnl_mst_row IN OUT NOCOPY ic_jrnl_mst%ROWTYPE)
74 RETURN BOOLEAN;
75
76 FUNCTION ic_whse_mst_select (p_ic_whse_mst_row IN ic_whse_mst%ROWTYPE,
77 x_ic_whse_mst_row IN OUT NOCOPY ic_whse_mst%ROWTYPE)
78 RETURN BOOLEAN;
79
80 FUNCTION ic_adjs_jnl_insert (p_ic_adjs_jnl_row IN ic_adjs_jnl%ROWTYPE,
81 x_ic_adjs_jnl_row IN OUT NOCOPY ic_adjs_jnl%ROWTYPE)
82 RETURN BOOLEAN;
83
84 FUNCTION sy_reas_cds_select (p_sy_reas_cds_row IN sy_reas_cds%ROWTYPE,
85 x_sy_reas_cds_row IN OUT NOCOPY sy_reas_cds%ROWTYPE)
86 RETURN BOOLEAN;
87
88 FUNCTION ic_item_cnv_insert (p_ic_item_cnv_row IN ic_item_cnv%ROWTYPE,
89 x_ic_item_cnv_row IN OUT NOCOPY ic_item_cnv%ROWTYPE)
90 RETURN BOOLEAN;
91
92 FUNCTION ic_loct_inv_select (p_ic_loct_inv_row IN ic_loct_inv%ROWTYPE,
93 x_ic_loct_inv_row IN OUT NOCOPY ic_loct_inv%ROWTYPE)
94 RETURN BOOLEAN;
95
96 FUNCTION sy_uoms_mst_select (p_sy_uoms_mst_row IN sy_uoms_mst%ROWTYPE,
97 x_sy_uoms_mst_row IN OUT NOCOPY sy_uoms_mst%ROWTYPE)
98 RETURN BOOLEAN;
99
100 FUNCTION sy_uoms_typ_select (p_sy_uoms_typ_row IN sy_uoms_typ%ROWTYPE,
101 x_sy_uoms_typ_row IN OUT NOCOPY sy_uoms_typ%ROWTYPE)
102 RETURN BOOLEAN;
103
104 FUNCTION qc_actn_mst_select (p_qc_actn_mst_row IN qc_actn_mst%ROWTYPE,
105 x_qc_actn_mst_row IN OUT NOCOPY qc_actn_mst%ROWTYPE)
106 RETURN BOOLEAN;
107
108 FUNCTION qc_grad_mst_select (p_qc_grad_mst_row IN qc_grad_mst%ROWTYPE,
109 x_qc_grad_mst_row IN OUT NOCOPY qc_grad_mst%ROWTYPE)
110 RETURN BOOLEAN;
111
112 FUNCTION po_vend_mst_select (p_po_vend_mst_row IN po_vend_mst%ROWTYPE,
113 x_po_vend_mst_row IN OUT NOCOPY po_vend_mst%ROWTYPE)
114 RETURN BOOLEAN;
115
116 -- TKW 9/11/2003 B2378017 Changed signature of proc below.
117 PROCEDURE gmi_item_categories (p_item_rec IN GMIGAPI.item_rec_typ, p_ic_item_mst_row IN ic_item_mst%ROWTYPE);
118 PROCEDURE gmi_item_categories_insert (p_ic_item_mst_row IN ic_item_mst%ROWTYPE,
119 p_category_set_id NUMBER,
120 p_category_concat_segs mtl_categories_v.category_concat_segs%TYPE,
121 p_structure_id NUMBER,
122 p_category_id IN OUT NOCOPY NUMBER);
123
124 /*
125
126 FUNCTION ic_xfer_mst_insert (p_ic_xfer_mst_row IN ic_xfer_mst%ROWTYPE,
127 x_ic_xfer_mst_row IN OUT NOCOPY ic_xfer_mst%ROWTYPE)
128 RETURN BOOLEAN;
129
130 FUNCTION ic_xfer_mst_select (p_ic_xfer_mst_row IN ic_xfer_mst%ROWTYPE,
131 x_ic_xfer_mst_row IN OUT NOCOPY ic_xfer_mst%ROWTYPE)
132 RETURN BOOLEAN;
133
134 FUNCTION ic_xfer_mst_update (p_ic_xfer_mst_row IN ic_xfer_mst%ROWTYPE,
135 x_ic_xfer_mst_row IN OUT NOCOPY ic_xfer_mst%ROWTYPE)
136 RETURN BOOLEAN;
137
138 FUNCTION ic_xfer_mst_lock (p_ic_xfer_mst_row IN ic_xfer_mst%ROWTYPE,
139 x_ic_xfer_mst_row IN OUT NOCOPY ic_xfer_mst%ROWTYPE)
140 RETURN BOOLEAN;
141 */
142
143
144
145 return_status NUMBER;
146 error_text VARCHAR2(512);
147
148 END GMIVDBL;
[Home] [Help]