APPS.WMS_CARTNZN_PUB dependencies on DUAL

Line 2457: l_package_sequence FROM dual;

2453: BEGIN
2454:
2455: if (g_trace_on = 1) then log_event(' In get next package id'); END IF;
2456: SELECT wms_packaging_hist_s.nextVal into
2457: l_package_sequence FROM dual;
2458:
2459: RETURN l_package_sequence;
2460:
2461: END get_next_package_id;

Line 2970: FROM dual;

2966: api_table_index := api_table_index + 1;
2967:
2968: SELECT mtl_material_transactions_s.NEXTVAL INTO
2969: api_table(api_table_index).transaction_id
2970: FROM dual;
2971:
2972: SELECT primary_quantity ,secondary_transaction_quantity INTO
2973: api_table(api_table_index).primary_quantity,
2974: api_table(api_table_index).secondary_quantity

Line 3060: FROM dual WHERE exists

3056: RETURN 'N';
3057: END IF;
3058:
3059: SELECT 'Y' INTO l_ret
3060: FROM dual WHERE exists
3061: (SELECT inventory_item_id
3062: FROM MTL_SYSTEM_ITEMS
3063: WHERE ORGANIZATION_ID = p_org_id
3064: AND INVENTORY_ITEM_ID = p_item_id

Line 3865: from dual;

3861: IF ( l_qoh = v1.primary_quantity ) THEN
3862: l_lpn_fully_allocated := 'Y';
3863: select v1.transaction_temp_id, 'Y'
3864: into t_lpn_alloc_flag_table(v1.transaction_temp_id)
3865: from dual;
3866:
3867: ELSE
3868: l_lpn_fully_allocated := 'N';
3869: select v1.transaction_temp_id, 'N'

Line 3871: from dual;

3867: ELSE
3868: l_lpn_fully_allocated := 'N';
3869: select v1.transaction_temp_id, 'N'
3870: into t_lpn_alloc_flag_table(v1.transaction_temp_id)
3871: from dual;
3872: END IF;
3873: ELSE
3874: l_lpn_fully_allocated := 'Y';
3875: select v1.transaction_temp_id, 'Y'

Line 3877: from dual;

3873: ELSE
3874: l_lpn_fully_allocated := 'Y';
3875: select v1.transaction_temp_id, 'Y'
3876: into t_lpn_alloc_flag_table(v1.transaction_temp_id)
3877: from dual;
3878: if (g_trace_on = 1) then log_event(' calling qty tree returns unsuccessfully' ); END IF;
3879: END IF ;
3880:
3881: ELSE

Line 3909: from dual;

3905:
3906: --populate lpn_alloc_flag with null for loose item
3907: select v1.transaction_temp_id, null
3908: into t_lpn_alloc_flag_table(v1.transaction_temp_id)
3909: from dual;
3910:
3911:
3912: -- If the content_lpn_id is populated on the mmtt record
3913: -- could be two cases. Either we are trying to pack an LPN

Line 5251: FROM dual;

5247: IF ( p_new_txn_tmp_id IS NULL AND p_transaction_temp_id > 0 ) THEN
5248:
5249: SELECT mtl_material_transactions_s.NEXTVAL
5250: INTO v1.transaction_temp_id
5251: FROM dual;
5252:
5253: ELSE
5254:
5255: v1.transaction_temp_id := p_new_txn_tmp_id;

Line 5784: SELECT 'Y' INTO v_exist FROM dual

5780:
5781: v_exist := 'N';
5782:
5783: BEGIN
5784: SELECT 'Y' INTO v_exist FROM dual
5785: WHERE
5786: exists ( SELECT transaction_temp_id FROM mtl_material_transactions_temp
5787: WHERE transaction_temp_id = v1.transaction_temp_id);
5788: EXCEPTION

Line 5891: -- from dual;

5887: error_code := 'GET_LOG_FLAG';
5888:
5889: -- select fnd_profile.value('INV_DEBUG_TRACE')
5890: -- into g_trace_on
5891: -- from dual;
5892:
5893: -- if( g_trace_on = 1 ) then
5894: -- select fnd_profile.value('INV_DEBUG_LEVEL')
5895: -- into l_dbg_lvl

Line 5896: -- from dual;

5892:
5893: -- if( g_trace_on = 1 ) then
5894: -- select fnd_profile.value('INV_DEBUG_LEVEL')
5895: -- into l_dbg_lvl
5896: -- from dual;
5897: -- END IF;
5898:
5899: if(g_trace_on = 1) THEN --AND l_dbg_lvl > 5 then
5900: log_flag := 'Y';

Line 6245: -- FROM dual;

6241: t_lpn_alloc_flag_table(v1.transaction_temp_id).lpn_alloc_flag := NULL;
6242:
6243: -- SELECT v1.transaction_temp_id, null
6244: -- INTO t_lpn_alloc_flag_table(v1.transaction_temp_id)
6245: -- FROM dual;
6246:
6247: -- If the content_lpn_id is populated on the mmtt record
6248: -- could be two cases. Either we are trying to pack an LPN
6249: -- or a package. We will have packages poulated in this