DBA Data[Home] [Help]

APPS.WSM_LOTATTR_PVT dependencies on WSM_LOTATTR_PVT

Line 1: PACKAGE body WSM_LotAttr_PVT as

1: PACKAGE body WSM_LotAttr_PVT as
2: /* $Header: WSMVATRB.pls 120.7.12010000.2 2008/08/06 07:46:26 amayadav ship $ */
3:
4: procedure lot_exists(x_err_code OUT NOCOPY NUMBER,
5: x_err_msg OUT NOCOPY VARCHAR2,

Line 1196: x_err_msg := 'WSM_LotAttr_PVT.create_update_lotattr '|| SUBSTR(SQLERRM,1,2000);

1192:
1193: EXCEPTION
1194: WHEN OTHERS THEN
1195: x_err_code := SQLCODE;
1196: x_err_msg := 'WSM_LotAttr_PVT.create_update_lotattr '|| SUBSTR(SQLERRM,1,2000);
1197: return;
1198: END create_update_lotattr;
1199:
1200: Procedure create_update_lotattr(x_err_code OUT NOCOPY VARCHAR2,

Line 1218: WSM_LotAttr_PVT.create_update_lotattr(x_err_code,

1214: INTO l_lot_number, l_inv_item_id
1215: FROM wip_discrete_jobs
1216: WHERE wip_entity_id=p_wip_entity_id;
1217:
1218: WSM_LotAttr_PVT.create_update_lotattr(x_err_code,
1219: x_err_msg,
1220: l_lot_number,
1221: l_inv_item_id,
1222: p_org_id,

Line 1238: END WSM_LotAttr_PVT;

1234: return;
1235:
1236: END create_update_lotattr;
1237:
1238: END WSM_LotAttr_PVT;