APPS.GMI_SHIPPING_UTIL dependencies on DUAL

Line 1349: /* staged transaction for the residual quantities */

1345: /* There are two cases to consider and the cursor will retrieve */
1346: /* the characteristics of the row we need (if it exists) */
1347:
1348: /* a) If a staged default lot transaction exists, create a new */
1349: /* staged transaction for the residual quantities */
1350: /* otherwise */
1351: /* c) If no default transaction exists, create the same transaction */
1352: /* as would have been created in 'b'. */
1353:

Line 2570: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_transaction_id from dual;

2566: Fetch get_item_desc INTO l_item_desc;
2567: Close get_item_desc;
2568:
2569: GMI_RESERVATION_UTIL.println('Inserting Detail ' || l_detail_rec.delivery_detail_id || ' into RCV_TRANSACTIONS_INTERFACE ');
2570: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_transaction_id from dual;
2571: l_group_id := p_group_id;
2572:
2573: l_secondary_unit_of_measure := null;
2574:

Line 2905: select RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM DUAL;

2901: l_if_internal := 1; -- internal order
2902:
2903: IF nvl(l_group_id,0) = 0 THEN
2904: /* only do this once */
2905: select RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM DUAL;
2906: END IF;
2907: OPEN c_details_for_interface(l_detail_in_delivery.delivery_detail_id);
2908: FETCH c_details_for_interface into l_detail_rec;
2909: if c_details_for_interface%NOTFOUND then

Line 3165: FROM DUAL;

3161:
3162: BEGIN
3163:
3164: SELECT TO_CHAR(SYSDATE,'SSSSS') INTO l_time
3165: FROM DUAL;
3166: l_FILE := 'MATCHLINES'||l_time;
3167: --DBMS_OUTPut.disable;
3168: -- DBMS_OUTPut.enable(1000000);
3169: