APPS.GMI_SUMM_INV_DB_PVT dependencies on IC_SUMM_INV

Line 13: | For IC_SUMM_INV |

9: | GMIVSUMB.pls |
10: | |
11: | DESCRIPTION |
12: | This package contains private definitions For DML Actions |
13: | For IC_SUMM_INV |
14: | |
15: | HISTORY |
16: | 12-JAN-2000 H.Verdding |
17: | 07-MAR-2001 Jalaj Srivastava

Line 25: IC_SUMM_INV transactions

21: +=========================================================================+
22: API Name : GMI_SUMM_INV_DB_PVT
23: Type : Public
24: Function : This package contains private procedures used to create
25: IC_SUMM_INV transactions
26: Pre-reqs : N/A
27: Parameters: Per function
28:
29: Current Vers : 1.0

Line 43: FUNCTION UPDATE_IC_SUMM_INV

39: /* Global variables */
40: G_PKG_NAME CONSTANT VARCHAR2(30):='GMI_SUMM_INV_DB_PVT';
41: /* Api start of comments */
42:
43: FUNCTION UPDATE_IC_SUMM_INV
44: (
45: p_summ_inv IN IC_SUMM_INV%ROWTYPE
46: )
47: RETURN BOOLEAN

Line 45: p_summ_inv IN IC_SUMM_INV%ROWTYPE

41: /* Api start of comments */
42:
43: FUNCTION UPDATE_IC_SUMM_INV
44: (
45: p_summ_inv IN IC_SUMM_INV%ROWTYPE
46: )
47: RETURN BOOLEAN
48: IS
49:

Line 59: UPDATE IC_SUMM_INV

55: IF ( p_summ_inv.qc_grade is NULL) THEN
56:
57: --Jalaj Srivastava Bug 1662876
58: --nvl is required with qty2 since for pending txns qty2 is null
59: UPDATE IC_SUMM_INV
60: SET
61: onhand_qty = onhand_qty + p_summ_inv.onhand_qty,
62: onhand_qty2 = onhand_qty2 + NVL(p_summ_inv.onhand_qty2,0),
63: onhand_prod_qty = onhand_prod_qty + p_summ_inv.onhand_prod_qty,

Line 97: UPDATE IC_SUMM_INV

93: AND qc_grade IS NULL;
94:
95: ELSE
96:
97: UPDATE IC_SUMM_INV
98: SET
99: onhand_qty = onhand_qty + p_summ_inv.onhand_qty,
100: onhand_qty2 = onhand_qty2 + NVL(p_summ_inv.onhand_qty2,0),
101: onhand_prod_qty = onhand_prod_qty + p_summ_inv.onhand_prod_qty,

Line 148: , 'update_ic_summ_inv'

144: WHEN OTHERS THEN
145: /* err_num :=SQLCODE; */
146: /* err_msg :=SUBSTR(SQLERRM,1 ,100);*/
147: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
148: , 'update_ic_summ_inv'
149: );
150: RETURN FALSE;
151:
152: END UPDATE_IC_SUMM_INV;

Line 152: END UPDATE_IC_SUMM_INV;

148: , 'update_ic_summ_inv'
149: );
150: RETURN FALSE;
151:
152: END UPDATE_IC_SUMM_INV;
153:
154: FUNCTION INSERT_IC_SUMM_INV
155: (
156: p_summ_inv IN IC_SUMM_INV%ROWTYPE

Line 154: FUNCTION INSERT_IC_SUMM_INV

150: RETURN FALSE;
151:
152: END UPDATE_IC_SUMM_INV;
153:
154: FUNCTION INSERT_IC_SUMM_INV
155: (
156: p_summ_inv IN IC_SUMM_INV%ROWTYPE
157: )
158: RETURN BOOLEAN

Line 156: p_summ_inv IN IC_SUMM_INV%ROWTYPE

152: END UPDATE_IC_SUMM_INV;
153:
154: FUNCTION INSERT_IC_SUMM_INV
155: (
156: p_summ_inv IN IC_SUMM_INV%ROWTYPE
157: )
158: RETURN BOOLEAN
159: IS
160: err_num NUMBER;

Line 173: INSERT INTO IC_SUMM_INV

169: INTO l_summ_inv_id
170: FROM dual;
171:
172:
173: INSERT INTO IC_SUMM_INV
174: (
175: summ_inv_id,
176: item_id,
177: whse_code,

Line 239: , 'insert_ic_summ_inv'

235: WHEN OTHERS THEN
236: /* err_num :=SQLCODE;*/
237: /* err_msg :=SUBSTR(SQLERRM,1 ,100);*/
238: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
239: , 'insert_ic_summ_inv'
240: );
241: RETURN FALSE;
242:
243:

Line 244: END INSERT_IC_SUMM_INV;

240: );
241: RETURN FALSE;
242:
243:
244: END INSERT_IC_SUMM_INV;
245:
246: FUNCTION GET_LOT_ATTRIBUTES
247: (
248: p_lot_status IN VARCHAR2,

Line 285: , 'insert_ic_summ_inv'

281: WHEN OTHERS THEN
282: /* err_num :=SQLCODE;*/
283: /* err_msg :=SUBSTR(SQLERRM,1 ,100);*/
284: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
285: , 'insert_ic_summ_inv'
286: );
287: RETURN FALSE;
288:
289: END GET_LOT_ATTRIBUTES;