[Home] [Help]
190: 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||rtrim(name)
191: INTO v_process_name,
192: v_display_name
193: FROM
194: so_cycles
195: WHERE cycle_id = p_cycle_id
196: AND p_item_type in ('OEOH', 'OEOL');
197:
198:
2441:
2442:
2443: /* ***********************************************************************
2444: -- If the SHIP_CONFIRM
2445: -- If the SHIP CONFIRM(action_id = 3) exists in SO cycles,
2446: -- The Receivables Interface(action_id = 7) will transform to
2447: -- WF ==> UPG_FULFILLMENT_SUB and UPG_LINE_INVOICE_INTERFACE_SUB
2448: -- Otherwise the Receivables Interface will only become
2449: -- WF ==> UPG_LINE_INVOICE_INTERFACE_SUB
2463: v_api_error_code number := 0;
2464: v_level_error number := 0;
2465:
2466: cursor c1 is
2467: select cycle_id from so_cycles
2468: where cycle_id in (select cycle_id from so_cycle_actions
2469: where action_id = 7)
2470: and cycle_id not in (select cycle_id from so_cycle_actions
2471: where action_id in (3, 13))
2549: v_cfg_shipping_instance_id number;
2550: v_mfg_instance_id number;
2551:
2552: cursor c1 is
2553: select cycle_id from so_cycles
2554: where cycle_id in (select cycle_id from so_cycle_actions
2555: where action_id = 15);
2556: cursor c3 is
2557: select to_process_activity
2712:
2713:
2714:
2715: Cursor c1 is
2716: select cycle_id from so_cycles
2717: where cycle_id in (select cycle_id from so_cycle_actions
2718: where action_id in (2,3,4,11,16))
2719: and cycle_id in (select cycle_id from so_cycle_actions
2720: where action_id = 13)
3571: */
3572:
3573: CURSOR c1 IS
3574: SELECT sc.cycle_id
3575: FROM so_cycles sc
3576: WHERE sc.cycle_id NOT IN
3577: (select cycle_id
3578: from oe_upgrade_log
3579: where (module='NU'
3589: where sl.cycle_id = sc.cycle_id
3590: and open_flag = 'Y'));
3591:
3592: cursor c3 is
3593: select cycle_id from so_cycles;
3594:
3595: v_error_code NUMBER;
3596: v_cfg_item VARCHAR2(1) := 'N';
3597: BEGIN