[Home] [Help]
185: 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||rtrim(name)
186: INTO v_process_name,
187: v_display_name
188: FROM
189: so_cycles
190: WHERE cycle_id = p_cycle_id
191: AND p_item_type in ('OEOH', 'OEOL');
192:
193:
2426:
2427:
2428: /* ***********************************************************************
2429: -- If the SHIP_CONFIRM
2430: -- If the SHIP CONFIRM(action_id = 3) exists in SO cycles,
2431: -- The Receivables Interface(action_id = 7) will transform to
2432: -- WF ==> UPG_FULFILLMENT_SUB and UPG_LINE_INVOICE_INTERFACE_SUB
2433: -- Otherwise the Receivables Interface will only become
2434: -- WF ==> UPG_LINE_INVOICE_INTERFACE_SUB
2448: v_api_error_code number := 0;
2449: v_level_error number := 0;
2450:
2451: cursor c1 is
2452: select cycle_id from so_cycles
2453: where cycle_id in (select cycle_id from so_cycle_actions
2454: where action_id = 7)
2455: and cycle_id not in (select cycle_id from so_cycle_actions
2456: where action_id in (3, 13))
2534: v_cfg_shipping_instance_id number;
2535: v_mfg_instance_id number;
2536:
2537: cursor c1 is
2538: select cycle_id from so_cycles
2539: where cycle_id in (select cycle_id from so_cycle_actions
2540: where action_id = 15);
2541: cursor c3 is
2542: select to_process_activity
2697:
2698:
2699:
2700: Cursor c1 is
2701: select cycle_id from so_cycles
2702: where cycle_id in (select cycle_id from so_cycle_actions
2703: where action_id in (2,3,4,11,16))
2704: and cycle_id in (select cycle_id from so_cycle_actions
2705: where action_id = 13)
3566: */
3567:
3568: CURSOR c1 IS
3569: SELECT cycle_id
3570: FROM so_cycles
3571: WHERE cycle_id NOT IN
3572: (select a.cycle_id from so_cycle_actions a
3573: where exists (Select action_id
3574: from so_cycle_actions
3639: and a1.result_table = 'SO_HEADERS')))
3640: AND cycle_id IN (select cycle_id from oe_upgrade_wf_vld_cyc);
3641:
3642: cursor c3 is
3643: select cycle_id from so_cycles;
3644:
3645: v_vld_hdr_flag VARCHAR2(1) := 'N';
3646: v_vld_lin_flag VARCHAR2(1) := 'N';
3647: v_error_code NUMBER;