APPS.GMI_LOCT_INV_DB_PVT dependencies on IC_LOCT_INV

Line 13: | For IC_LOCT_INV |

9: | GMIVLOCB.pls |
10: | |
11: | DESCRIPTION |
12: | This package contains private definitions For DML Actions |
13: | For IC_LOCT_INV |
14: | |
15: | HISTORY |
16: | 12-JAN-2000 H.Verdding |
17: | 27-DEC-2001 J. DiIorio Bug#2117575 11.5.1I |

Line 24: | Code is added to update ic_loct_inv.last_update_date with |

20: | Jalaj Srivastava Bug 2483644 |
21: | Removed code for bug 2117575 as it is already taken care |
22: | of in GMIVQTY.validate_inventory_posting. |
23: | 18-MAR-2003 James Bernard BUG#2847679 |
24: | Code is added to update ic_loct_inv.last_update_date with |
25: | SYSDATE and ic_loct_inv.last_updated_by the user who is currently |
26: | doing the adjust immediate. |
27: +=========================================================================+
28: API Name : GMI_LOCT_INV_DB_PVT

Line 25: | SYSDATE and ic_loct_inv.last_updated_by the user who is currently |

21: | Removed code for bug 2117575 as it is already taken care |
22: | of in GMIVQTY.validate_inventory_posting. |
23: | 18-MAR-2003 James Bernard BUG#2847679 |
24: | Code is added to update ic_loct_inv.last_update_date with |
25: | SYSDATE and ic_loct_inv.last_updated_by the user who is currently |
26: | doing the adjust immediate. |
27: +=========================================================================+
28: API Name : GMI_LOCT_INV_DB_PVT
29: Type : Public

Line 45: FUNCTION UPDATE_IC_LOCT_INV

41: */
42: /* Global variables */
43: G_PKG_NAME CONSTANT VARCHAR2(30):='GMI_LOCT_INV_DB_PVT';
44:
45: FUNCTION UPDATE_IC_LOCT_INV
46: (
47: p_loct_inv IN IC_LOCT_INV%ROWTYPE,
48: p_status_updated IN NUMBER,
49: p_qty_updated IN NUMBER

Line 47: p_loct_inv IN IC_LOCT_INV%ROWTYPE,

43: G_PKG_NAME CONSTANT VARCHAR2(30):='GMI_LOCT_INV_DB_PVT';
44:
45: FUNCTION UPDATE_IC_LOCT_INV
46: (
47: p_loct_inv IN IC_LOCT_INV%ROWTYPE,
48: p_status_updated IN NUMBER,
49: p_qty_updated IN NUMBER
50: )
51: RETURN BOOLEAN

Line 77: UPDATE ic_loct_inv

73: Modified the update statement to update last_update_date with SYSDATE
74: and last_updated_by with the user_id if the current user doing adjust immediate.
75: ==============================================*/
76:
77: UPDATE ic_loct_inv
78: SET
79: loct_onhand = loct_onhand + p_loct_inv.loct_onhand,
80: loct_onhand2 = loct_onhand2 + p_loct_inv.loct_onhand2,
81: last_update_date = SYSDATE,

Line 97: UPDATE ic_loct_inv

93: Modified the update statement to update last_update_date with SYSDATE
94: and last_updated_by with the user_id if the current user doing adjust immediate.
95: ==============================================*/
96:
97: UPDATE ic_loct_inv
98: SET
99: lot_status = p_loct_inv.lot_status,
100: last_update_date = SYSDATE,
101: last_updated_by = p_loct_inv.last_updated_by

Line 116: IF INSERT_IC_LOCT_INV(p_loct_inv)

112: IF SQL%ROWCOUNT = 0
113: THEN
114: /* There was nothing to update so we must insert a row */
115:
116: IF INSERT_IC_LOCT_INV(p_loct_inv)
117: THEN
118: NULL;
119: ELSE
120: RAISE bad_insert;

Line 133: , 'update_ic_LOCT_inv'

129: WHEN OTHERS THEN
130: err_num :=SQLCODE;
131: err_msg :=SUBSTR(SQLERRM,1 ,100);
132: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
133: , 'update_ic_LOCT_inv'
134: );
135: RETURN FALSE;
136:
137: END UPDATE_IC_LOCT_INV;

Line 137: END UPDATE_IC_LOCT_INV;

133: , 'update_ic_LOCT_inv'
134: );
135: RETURN FALSE;
136:
137: END UPDATE_IC_LOCT_INV;
138:
139: FUNCTION INSERT_IC_LOCT_INV
140: (
141: p_LOCT_inv IN IC_LOCT_INV%ROWTYPE

Line 139: FUNCTION INSERT_IC_LOCT_INV

135: RETURN FALSE;
136:
137: END UPDATE_IC_LOCT_INV;
138:
139: FUNCTION INSERT_IC_LOCT_INV
140: (
141: p_LOCT_inv IN IC_LOCT_INV%ROWTYPE
142: )
143: RETURN BOOLEAN

Line 141: p_LOCT_inv IN IC_LOCT_INV%ROWTYPE

137: END UPDATE_IC_LOCT_INV;
138:
139: FUNCTION INSERT_IC_LOCT_INV
140: (
141: p_LOCT_inv IN IC_LOCT_INV%ROWTYPE
142: )
143: RETURN BOOLEAN
144: IS
145: err_num NUMBER;

Line 150: INSERT INTO IC_LOCT_INV

146: err_msg VARCHAR2(100);
147:
148: BEGIN
149:
150: INSERT INTO IC_LOCT_INV
151: (
152: item_id,
153: whse_code,
154: lot_id,

Line 192: , 'insert_ic_LOCT_inv'

188: WHEN OTHERS THEN
189: err_num :=SQLCODE;
190: err_msg :=SUBSTR(SQLERRM,1 ,100);
191: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
192: , 'insert_ic_LOCT_inv'
193: );
194: RETURN FALSE;
195:
196: END INSERT_IC_LOCT_INV;

Line 196: END INSERT_IC_LOCT_INV;

192: , 'insert_ic_LOCT_inv'
193: );
194: RETURN FALSE;
195:
196: END INSERT_IC_LOCT_INV;
197:
198: END GMI_LOCT_INV_DB_PVT;