DBA Data[Home] [Help]

APPS.WIP_FLOWUTIL_PRIV dependencies on WIP_FLOW_DERIVE

Line 380: if ( (wip_flow_derive.schedule_number(

376: l_errMsg varchar2(240);
377: l_dummy number;
378: begin
379: if ( p_scheduledFlag = 2 ) then
380: if ( (wip_flow_derive.schedule_number(
381: p_sched_num => p_schedNum) = 0 )
382: or (wip_flow_derive.src_project_id(
383: p_src_proj_id => p_srcProjID,
384: p_proj_id => p_projID) = 0 )

Line 382: or (wip_flow_derive.src_project_id(

378: begin
379: if ( p_scheduledFlag = 2 ) then
380: if ( (wip_flow_derive.schedule_number(
381: p_sched_num => p_schedNum) = 0 )
382: or (wip_flow_derive.src_project_id(
383: p_src_proj_id => p_srcProjID,
384: p_proj_id => p_projID) = 0 )
385: or (wip_flow_derive.src_task_id(
386: p_src_task_id => p_srcTaskID,

Line 385: or (wip_flow_derive.src_task_id(

381: p_sched_num => p_schedNum) = 0 )
382: or (wip_flow_derive.src_project_id(
383: p_src_proj_id => p_srcProjID,
384: p_proj_id => p_projID) = 0 )
385: or (wip_flow_derive.src_task_id(
386: p_src_task_id => p_srcTaskID,
387: p_task_id => p_taskID) = 0 )
388: or (wip_flow_derive.bom_revision(
389: p_bom_rev => p_bomRev,

Line 388: or (wip_flow_derive.bom_revision(

384: p_proj_id => p_projID) = 0 )
385: or (wip_flow_derive.src_task_id(
386: p_src_task_id => p_srcTaskID,
387: p_task_id => p_taskID) = 0 )
388: or (wip_flow_derive.bom_revision(
389: p_bom_rev => p_bomRev,
390: p_rev => p_rev,
391: p_bom_rev_date => p_bomRevDate,
392: p_item_id => p_itemID,

Line 395: or (wip_flow_derive.routing_revision(

391: p_bom_rev_date => p_bomRevDate,
392: p_item_id => p_itemID,
393: p_start_date => p_txnDate,
394: p_org_id => p_orgID) = 0 )
395: or (wip_flow_derive.routing_revision(
396: p_rout_rev => p_routRev,
397: p_rout_rev_date => p_routRevDate,
398: p_item_id => p_itemID,
399: p_start_date => p_txnDate,

Line 402: wip_flow_derive.completion_sub(

398: p_item_id => p_itemID,
399: p_start_date => p_txnDate,
400: p_org_id => p_orgID) = 0 )
401: or (p_txnActionID <> WIP_CONSTANTS.SCRASSY_ACTION and
402: wip_flow_derive.completion_sub(
403: p_comp_sub => p_cplSubinv,
404: p_item_id => p_itemID,
405: p_org_id => p_orgID,
406: p_alt_rtg_des => p_altRtgDes) = 0 )

Line 408: wip_flow_derive.completion_locator_id(

404: p_item_id => p_itemID,
405: p_org_id => p_orgID,
406: p_alt_rtg_des => p_altRtgDes) = 0 )
407: or (p_txnActionID <> WIP_CONSTANTS.SCRASSY_ACTION and
408: wip_flow_derive.completion_locator_id(
409: p_comp_loc => p_cplLocID,
410: p_item_id => p_itemID,
411: p_org_id => p_orgID,
412: p_alt_rtg_des => p_altRtgDes,

Line 416: or (wip_flow_derive.class_code(

412: p_alt_rtg_des => p_altRtgDes,
413: p_proj_id => p_srcProjID,
414: p_task_id => p_taskID,
415: p_comp_sub => p_cplSubinv) = 0 )
416: or (wip_flow_derive.class_code(
417: p_class_code => p_classCode,
418: p_err_mesg => l_errMsg,
419: p_org_id => p_orgID,
420: p_item_id => p_itemID,

Line 426: if ( wip_flow_derive.scheduled_flow_derivation(

422: p_project_id => p_srcProjID) = 0 ) ) then
423: return fnd_api.g_ret_sts_error;
424: end if;
425: else -- else of p_scheduledFlag = 2
426: if ( wip_flow_derive.scheduled_flow_derivation(
427: p_txn_action_id => p_txnActionID,
428: p_item_id => p_itemID,
429: p_org_id => p_orgID,
430: p_txn_src_id => p_txnSrcID,