APPS.GML_MOBILE_RECEIPT dependencies on DUAL

Line 372: FROM sys.dual;

368: --Generate transaction_interface_id if the parameter is NULL
369: IF (p_transaction_interface_id IS NULL) THEN
370: SELECT mtl_material_transactions_s.NEXTVAL
371: INTO p_transaction_interface_id
372: FROM sys.dual;
373: END IF;
374:
375: --Generate production_transaction_id if the parameter is NULL
376: IF (p_product_transaction_id IS NULL) THEN

Line 379: FROM sys.dual;

375: --Generate production_transaction_id if the parameter is NULL
376: IF (p_product_transaction_id IS NULL) THEN
377: SELECT rcv_transactions_interface_s.NEXTVAL
378: INTO p_product_transaction_id
379: FROM sys.dual;
380: END IF;
381:
382: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE (
383: transaction_interface_id

Line 3187: l_opm_dualum_ind NUMBER;

3183:
3184: l_opm_um_code VARCHAR2(25);
3185: l_passed_opm_sec_um_code VARCHAR2(25);
3186: l_opm_item_id NUMBER;
3187: l_opm_dualum_ind NUMBER;
3188: l_opm_secondary_um VARCHAR2(25);
3189: l_lot_id NUMBER;
3190:
3191: v_ret_val NUMBER;

Line 3195: ilm.dualum_ind,

3191: v_ret_val NUMBER;
3192:
3193: Cursor Cr_get_opm_attr IS
3194: Select ilm.item_id,
3195: ilm.dualum_ind,
3196: ilm.item_um2
3197: From ic_item_mst ilm
3198: Where ilm.item_no = p_item_no;
3199:

Line 3220: Fetch Cr_get_opm_attr Into l_opm_item_id, l_opm_dualum_ind, l_opm_secondary_um;

3216: RETURN;
3217: ELSE
3218: --Get opm attributes for the item.
3219: Open Cr_get_opm_attr;
3220: Fetch Cr_get_opm_attr Into l_opm_item_id, l_opm_dualum_ind, l_opm_secondary_um;
3221:
3222: IF (Cr_get_opm_attr%NOTFOUND) THEN
3223: --item not an opm item do nothing just return
3224: CLOSE Cr_get_opm_attr;

Line 3229: --if item is not dualum control then return doing nothing.

3225: RETURN;
3226: END IF;
3227: CLOSE Cr_get_opm_attr;
3228:
3229: --if item is not dualum control then return doing nothing.
3230: IF l_opm_dualum_ind = 0 THEN
3231: RETURN;
3232: END IF;
3233:

Line 3230: IF l_opm_dualum_ind = 0 THEN

3226: END IF;
3227: CLOSE Cr_get_opm_attr;
3228:
3229: --if item is not dualum control then return doing nothing.
3230: IF l_opm_dualum_ind = 0 THEN
3231: RETURN;
3232: END IF;
3233:
3234: --Get opm uom code for the passed apps unit of measure.

Line 3354: FROM DUAL

3350: BEGIN
3351: --- check validity
3352: SELECT 'failed'
3353: INTO l_validity_check
3354: FROM DUAL
3355:
3356: WHERE EXISTS( SELECT subinventory_code
3357: FROM mtl_item_locations_kfv
3358: WHERE concatenated_segments = p_concat_segs

Line 3393: FROM DUAL

3389: BEGIN
3390: --- check validity
3391: SELECT 'failed'
3392: INTO l_validity_check
3393: FROM DUAL
3394: WHERE EXISTS( SELECT subinventory_code
3395: FROM mtl_item_locations_kfv
3396: WHERE concatenated_segments = p_concat_segs
3397: AND p_sub_code <> subinventory_code