APPS.WIP_ONLINE_MTL_TXN_PROCESSOR dependencies on WIP_LPN_COMPLETIONS

Line 15: FROM wip_lpn_completions wlc, wip_lpn_completions_serials wlcs

11: SELECT wlc.inventory_item_id,
12: wlc.organization_id,
13: wlcs.fm_serial_number,
14: wlcs.to_serial_number
15: FROM wip_lpn_completions wlc, wip_lpn_completions_serials wlcs
16: WHERE wlc.header_id = p_header_id
17: and wlc.header_id = wlcs.header_id;
18:
19: l_msg_count NUMBER;

Line 148: FROM WIP_LPN_COMPLETIONS

144: x_return_status OUT NOCOPY VARCHAR2) IS
145:
146: CURSOR c_components(v_source_id NUMBER) IS
147: SELECT HEADER_ID
148: FROM WIP_LPN_COMPLETIONS
149: WHERE v_source_id = SOURCE_ID
150: AND v_source_id <> HEADER_ID;
151: BEGIN
152: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 373: -- insert into wip_lpn_completions

369: end if;
370: raise fnd_api.g_exc_unexpected_error;
371: end if;
372:
373: -- insert into wip_lpn_completions
374: lpnParameter.environment := environment ;
375: lpnParameter.transactionDate := sysdate ;
376: -- for wip_lpn_completions, unscheduled is 3
377: if (p_scheduledFlag = 1) then

Line 376: -- for wip_lpn_completions, unscheduled is 3

372:
373: -- insert into wip_lpn_completions
374: lpnParameter.environment := environment ;
375: lpnParameter.transactionDate := sysdate ;
376: -- for wip_lpn_completions, unscheduled is 3
377: if (p_scheduledFlag = 1) then
378: lpnParameter.scheduledFlag := 1 ;
379: else
380: lpnParameter.scheduledFlag := 3 ;

Line 454: * populates wip_lpn_completions for wms processing.

450: END lpnCompleteFlow;
451:
452: /* Process an Lpn (discrete job) completion, called by LpnCmpProcessor.java Calls
453: * wma online processor in mmtt first, then deletes those records and
454: * populates wip_lpn_completions for wms processing.
455: *
456: * parameters: p_orgID -- current org
457: * p_userID -- current user
458: * p_transactionHeaderID -- header ID in wip_lpn_completions

Line 458: * p_transactionHeaderID -- header ID in wip_lpn_completions

454: * populates wip_lpn_completions for wms processing.
455: *
456: * parameters: p_orgID -- current org
457: * p_userID -- current user
458: * p_transactionHeaderID -- header ID in wip_lpn_completions
459: * p_processHeaderID -- transaction header ID in mmtt
460: * p_processIntID -- transaction temp ID in mmtt
461: * x_err_msg -- err_msg if call fails, null if success
462: * x_return_status -- fnd_api.G_RET_STS_SUCCESS ('S') if successful