APPS.WMS_CARTNZN_PUB dependencies on DUAL

Line 2482: l_package_sequence FROM dual;

2478: BEGIN
2479:
2480: if (g_trace_on = 1) then log_event(' In get next package id'); END IF;
2481: SELECT wms_packaging_hist_s.nextVal into
2482: l_package_sequence FROM dual;
2483:
2484: RETURN l_package_sequence;
2485:
2486: END get_next_package_id;

Line 2990: FROM dual;

2986: api_table_index := api_table_index + 1;
2987:
2988: SELECT mtl_material_transactions_s.NEXTVAL INTO
2989: api_table(api_table_index).transaction_id
2990: FROM dual;
2991:
2992: SELECT primary_quantity ,secondary_transaction_quantity INTO
2993: api_table(api_table_index).primary_quantity,
2994: api_table(api_table_index).secondary_quantity

Line 3080: FROM dual WHERE exists

3076: RETURN 'N';
3077: END IF;
3078:
3079: SELECT 'Y' INTO l_ret
3080: FROM dual WHERE exists
3081: (SELECT inventory_item_id
3082: FROM MTL_SYSTEM_ITEMS
3083: WHERE ORGANIZATION_ID = p_org_id
3084: AND INVENTORY_ITEM_ID = p_item_id

Line 3883: from dual;

3879: IF ( l_qoh = v1.primary_quantity ) THEN
3880: l_lpn_fully_allocated := 'Y';
3881: select v1.transaction_temp_id, 'Y'
3882: into t_lpn_alloc_flag_table(v1.transaction_temp_id)
3883: from dual;
3884:
3885: ELSE
3886: l_lpn_fully_allocated := 'N';
3887: select v1.transaction_temp_id, 'N'

Line 3889: from dual;

3885: ELSE
3886: l_lpn_fully_allocated := 'N';
3887: select v1.transaction_temp_id, 'N'
3888: into t_lpn_alloc_flag_table(v1.transaction_temp_id)
3889: from dual;
3890: END IF;
3891: ELSE
3892: l_lpn_fully_allocated := 'Y';
3893: select v1.transaction_temp_id, 'Y'

Line 3895: from dual;

3891: ELSE
3892: l_lpn_fully_allocated := 'Y';
3893: select v1.transaction_temp_id, 'Y'
3894: into t_lpn_alloc_flag_table(v1.transaction_temp_id)
3895: from dual;
3896: if (g_trace_on = 1) then log_event(' calling qty tree returns unsuccessfully' ); END IF;
3897: END IF ;
3898:
3899: ELSE

Line 3927: from dual;

3923:
3924: --populate lpn_alloc_flag with null for loose item
3925: select v1.transaction_temp_id, null
3926: into t_lpn_alloc_flag_table(v1.transaction_temp_id)
3927: from dual;
3928:
3929:
3930: -- If the content_lpn_id is populated on the mmtt record
3931: -- could be two cases. Either we are trying to pack an LPN

Line 5225: FROM dual;

5221: IF ( p_new_txn_tmp_id IS NULL AND p_transaction_temp_id > 0 ) THEN
5222:
5223: SELECT mtl_material_transactions_s.NEXTVAL
5224: INTO v1.transaction_temp_id
5225: FROM dual;
5226:
5227: ELSE
5228:
5229: v1.transaction_temp_id := p_new_txn_tmp_id;

Line 5745: SELECT 'Y' INTO v_exist FROM dual

5741:
5742: v_exist := 'N';
5743:
5744: BEGIN
5745: SELECT 'Y' INTO v_exist FROM dual
5746: WHERE
5747: exists ( SELECT transaction_temp_id FROM mtl_material_transactions_temp
5748: WHERE transaction_temp_id = v1.transaction_temp_id);
5749: EXCEPTION

Line 5852: -- from dual;

5848: error_code := 'GET_LOG_FLAG';
5849:
5850: -- select fnd_profile.value('INV_DEBUG_TRACE')
5851: -- into g_trace_on
5852: -- from dual;
5853:
5854: -- if( g_trace_on = 1 ) then
5855: -- select fnd_profile.value('INV_DEBUG_LEVEL')
5856: -- into l_dbg_lvl

Line 5857: -- from dual;

5853:
5854: -- if( g_trace_on = 1 ) then
5855: -- select fnd_profile.value('INV_DEBUG_LEVEL')
5856: -- into l_dbg_lvl
5857: -- from dual;
5858: -- END IF;
5859:
5860: if(g_trace_on = 1) THEN --AND l_dbg_lvl > 5 then
5861: log_flag := 'Y';

Line 6200: -- FROM dual;

6196: t_lpn_alloc_flag_table(v1.transaction_temp_id).lpn_alloc_flag := NULL;
6197:
6198: -- SELECT v1.transaction_temp_id, null
6199: -- INTO t_lpn_alloc_flag_table(v1.transaction_temp_id)
6200: -- FROM dual;
6201:
6202: -- If the content_lpn_id is populated on the mmtt record
6203: -- could be two cases. Either we are trying to pack an LPN
6204: -- or a package. We will have packages poulated in this