DBA Data[Home] [Help]

APPS.WIP_FLOWUTIL_PRIV dependencies on WIP_FLOW_DERIVE

Line 411: if ( (wip_flow_derive.schedule_number(

407: l_errMsg varchar2(240);
408: l_dummy number;
409: begin
410: if ( p_scheduledFlag = 2 ) then
411: if ( (wip_flow_derive.schedule_number(
412: p_sched_num => p_schedNum) = 0 )
413: or (wip_flow_derive.src_project_id(
414: p_src_proj_id => p_srcProjID,
415: p_proj_id => p_projID) = 0 )

Line 413: or (wip_flow_derive.src_project_id(

409: begin
410: if ( p_scheduledFlag = 2 ) then
411: if ( (wip_flow_derive.schedule_number(
412: p_sched_num => p_schedNum) = 0 )
413: or (wip_flow_derive.src_project_id(
414: p_src_proj_id => p_srcProjID,
415: p_proj_id => p_projID) = 0 )
416: or (wip_flow_derive.src_task_id(
417: p_src_task_id => p_srcTaskID,

Line 416: or (wip_flow_derive.src_task_id(

412: p_sched_num => p_schedNum) = 0 )
413: or (wip_flow_derive.src_project_id(
414: p_src_proj_id => p_srcProjID,
415: p_proj_id => p_projID) = 0 )
416: or (wip_flow_derive.src_task_id(
417: p_src_task_id => p_srcTaskID,
418: p_task_id => p_taskID) = 0 )
419: or (wip_flow_derive.bom_revision(
420: p_bom_rev => p_bomRev,

Line 419: or (wip_flow_derive.bom_revision(

415: p_proj_id => p_projID) = 0 )
416: or (wip_flow_derive.src_task_id(
417: p_src_task_id => p_srcTaskID,
418: p_task_id => p_taskID) = 0 )
419: or (wip_flow_derive.bom_revision(
420: p_bom_rev => p_bomRev,
421: p_rev => p_rev,
422: p_bom_rev_date => p_bomRevDate,
423: p_item_id => p_itemID,

Line 426: or (wip_flow_derive.routing_revision(

422: p_bom_rev_date => p_bomRevDate,
423: p_item_id => p_itemID,
424: p_start_date => p_txnDate,
425: p_org_id => p_orgID) = 0 )
426: or (wip_flow_derive.routing_revision(
427: p_rout_rev => p_routRev,
428: p_rout_rev_date => p_routRevDate,
429: p_item_id => p_itemID,
430: p_start_date => p_txnDate,

Line 433: wip_flow_derive.completion_sub(

429: p_item_id => p_itemID,
430: p_start_date => p_txnDate,
431: p_org_id => p_orgID) = 0 )
432: or (p_txnActionID <> WIP_CONSTANTS.SCRASSY_ACTION and
433: wip_flow_derive.completion_sub(
434: p_comp_sub => p_cplSubinv,
435: p_item_id => p_itemID,
436: p_org_id => p_orgID,
437: p_alt_rtg_des => p_altRtgDes) = 0 )

Line 439: wip_flow_derive.completion_locator_id(

435: p_item_id => p_itemID,
436: p_org_id => p_orgID,
437: p_alt_rtg_des => p_altRtgDes) = 0 )
438: or (p_txnActionID <> WIP_CONSTANTS.SCRASSY_ACTION and
439: wip_flow_derive.completion_locator_id(
440: p_comp_loc => p_cplLocID,
441: p_item_id => p_itemID,
442: p_org_id => p_orgID,
443: p_alt_rtg_des => p_altRtgDes,

Line 447: or (wip_flow_derive.class_code(

443: p_alt_rtg_des => p_altRtgDes,
444: p_proj_id => p_srcProjID,
445: p_task_id => p_taskID,
446: p_comp_sub => p_cplSubinv) = 0 )
447: or (wip_flow_derive.class_code(
448: p_class_code => p_classCode,
449: p_err_mesg => l_errMsg,
450: p_org_id => p_orgID,
451: p_item_id => p_itemID,

Line 457: if ( wip_flow_derive.scheduled_flow_derivation(

453: p_project_id => p_srcProjID) = 0 ) ) then
454: return fnd_api.g_ret_sts_error;
455: end if;
456: else -- else of p_scheduledFlag = 2
457: if ( wip_flow_derive.scheduled_flow_derivation(
458: p_txn_action_id => p_txnActionID,
459: p_item_id => p_itemID,
460: p_org_id => p_orgID,
461: p_txn_src_id => p_txnSrcID,