APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on DUAL

Line 487: from dual;

483: IF ( l_serial_number IS NULL ) THEN
484: IF ( l_transaction_temp_id IS NULL ) THEN
485: select mtl_material_Transactions_s.nextval
486: into l_InvPCInRecType.transaction_temp_id
487: from dual;
488:
489: l_transaction_temp_id := l_InvPCInRecType.transaction_temp_id;
490:
491: debug('About to call wsh_integration.Set_Inv_PC_Attributes tempid='||l_transaction_temp_id, 'GET_DELIVERY_LINE_SERIAL_INFO');

Line 2153: from dual

2149: BEGIN
2150: x_return_Status := 'C';
2151: select 1
2152: into exist_unspecified
2153: from dual
2154: where exists (select 1
2155: from wsh_delivery_details_ob_grp_v wdd,
2156: wsh_delivery_assignments_v wda
2157: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 2208: from dual

2204: BEGIN
2205: x_return_Status := 'Y';
2206: select 1
2207: into exist_unqualified
2208: from dual
2209: where exists (select 1
2210: from wsh_delivery_details_ob_grp_v wdd,
2211: wsh_delivery_assignments_v wda
2212: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 2234: from dual

2230: l_loaded VARCHAR2(1) := 'N';
2231: BEGIN
2232: select 'Y'
2233: into l_loaded
2234: from dual
2235: where exists (select 1
2236: from wms_shipping_transaction_temp
2237: where delivery_id = p_delivery_id);
2238: x_return_Status := l_loaded;

Line 2651: from dual;

2647:
2648: if( l_transaction_temp_id = l_new_transaction_temp_id) then
2649: select mtl_material_transactions_s.nextval
2650: into l_new_transaction_temp_id
2651: from dual;
2652: if( l_debug = 1 ) then
2653: debug('new transaction_temp_id is ' || l_new_transaction_temp_id, 'split_Delivery');
2654: end if;
2655: end if;

Line 2818: from dual;

2814:
2815: if( l_transaction_temp_id = l_new_transaction_temp_id) then
2816: select mtl_material_transactions_s.nextval
2817: into l_new_transaction_temp_id
2818: from dual;
2819: if( l_debug = 1 ) then
2820: debug('new transaction_temp_id is ' || l_new_transaction_temp_id, 'split_Delivery');
2821: end if;
2822: end if;