APPS.AHL_PRD_MTLTXN_PVT dependencies on DUAL

Line 1859: select AHL_WORKORDER_MTL_TXNS_S.currval into p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id from dual;

1855: X_LAST_UPDATE_DATE => SYSDATE,
1856: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1857: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1858:
1859: select AHL_WORKORDER_MTL_TXNS_S.currval into p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id from dual;
1860: -- p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id:=x_ahl_mtl_txn_id;
1861:
1862: IF G_DEBUG='Y' THEN
1863: AHL_DEBUG_PUB.debug('Entered p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id='||p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id);

Line 3677: FROM DUAL;

3673: --Item is under Lot and Serial Control
3674: --Generate serial transaction Temp id.
3675: SELECT Mtl_Material_Transactions_S.nextval
3676: INTO l_Srl_Txn_Tmp_Id
3677: FROM DUAL;
3678:
3679:
3680:
3681: l_mtlt_rec.Transaction_Temp_Id := x_Txn_Tmp_Id;

Line 4191: FROM DUAL;

4187:
4188: IF(p_x_txn_hdr_id IS NULL) THEN
4189: SELECT Mtl_Material_Transactions_S.nextval
4190: INTO p_x_txn_hdr_id
4191: FROM DUAL;
4192: IF G_DEBUG='Y' THEN
4193: AHL_DEBUG_PUB.debug('Header id created..['||p_x_txn_hdr_id||']');
4194: END IF;
4195: END IF;

Line 4203: FROM DUAL;

4199: WHILE (l_loop_count < p_x_ahl_mtl_txn_rec.Quantity) LOOP
4200:
4201: SELECT Mtl_Material_Transactions_S.nextval
4202: INTO p_x_txn_intf_id
4203: FROM DUAL;
4204:
4205: IF G_DEBUG='Y' THEN
4206: AHL_DEBUG_PUB.debug('Interface id created..['||p_x_txn_intf_id||']');
4207: END IF;

Line 4342: FROM DUAL;

4338:
4339: IF(p_x_ahl_mtl_txn_rec.Serial_Number IS NOT NULL) THEN
4340: SELECT Mtl_Material_Transactions_S.nextval
4341: INTO l_txn_tmp_id
4342: FROM DUAL;
4343: ELSE
4344: l_txn_tmp_id := p_x_txn_intf_id;
4345: END IF;
4346: